All geek questions in one place

WebSphere J2CA0086W local transaction restriction issue

In WebSphere, if you open two parallel database connections, you get a form error:

J2CA0086W: Shared connection MCWrapper id 556e556e Managed connection WSRdbManagedConnectionImpl @ 52365236 Status: STATE_TRAN_WRAPPER_INUSE from the jdbc / abc resource was used within the local transaction boundary.

Our structure allows us to do this (nested transactions, which can be on a separate connection or several named transactions). I saw a lot of links on disabling a switch in WebSphere to enable connection sharing, but no details on how to set this flag. Can someone point me to the steps to achieve this?

In particular, if you see this article: http://www-01.ibm.com/support/docview.wss?rs=180&context=SSEQTP&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB540&dc=DB510&dc=d1=jq=001dc=001dc=001dc=001dc=00_dc=001dc=00_dc = swg21121449 & loc = en_US & cs = utf-8 & lang = en

in the "Problem Solving" section. I want to know how to set the connection pool fuzzy (assuming that it really solves the problem).

+3
source share
2 answers

What version of IBM WAS are you using? If you have WAS 8, go to Resources-> JDC-> Data Sources-> your data sources → WebSphere Application Server Properties → Data Sources are not Transactional.

Sorry for my English.

+3

, dataSource.getConnection() . jdbc/oracle - . con.close() getConnection()

+1

Source: https://habr.com/ru/post/1765367/

More articles:


All Articles