|
Problem(Abstract) |
If you are using WebSphere® Application Server V5.0.1,
V5.0.2, or V5.0.2.1 and your application uses a 1-phase commit (1PC) data
source, you might see the following error message when you enable
security:
WTRN0062E: An illegal attempt to use multiple resources that have only
one-phase capability has occurred within a global transaction. |
|
|
|
Cause |
When security is enabled, the connection to the datasource
is not shared. For each query, a new 1PC resource is enlisted in the
global transaction. This is illegal for 1PC resource and is the cause of
the error.
[12/23/03 18:33:08:162 EST]
15ce7d LocalTransact > enlist
[12/23/03 18:33:08:162 EST] 15ce7d LocalTransact d enlisting
LocalTranWrapper :58ba0e63 with coordinator
:com.ibm.ejs.jts.jts.CoordinatorImpl@1210175097#tid=2
[12/23/03 18:33:08:162 EST] 15ce7d JTSXA
> enlistOnePhase: args:
com.ibm.ejs.jts.jts.CoordinatorImpl@1210175097#tid=2
com.ibm.ejs.j2c.LocalTransactionWrapper@58ba0e63
[12/23/03 18:33:08:163 EST] 15ce7d CoordinatorIm >
get_jta_transaction()
[12/23/03 18:33:08:163 EST] 15ce7d CoordinatorIm <
get_jta_transaction()
com.ibm.ejs.jts.jta.TransactionImpl@2
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm >
enlistResource: args:
com.ibm.ejs.j2c.LocalTransactionWrapper@58ba0e63
-1
[12/23/03 18:33:08:163 EST] 15ce7d CoordinatorIm >
get_status
[12/23/03 18:33:08:163 EST] 15ce7d CoordinatorIm <
get_status
0
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm d getStatus:
Status.StatusActive
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm e Illegal attempt to
enlist more than one 1PC resource.
[12/23/03 18:33:08:163 EST] 15ce7d TransactionIm E WTRN0062E: An illegal
attempt to use multiple resources that have only one-phase capability has
occurred within a global transaction.
[12/23/03 18:33:08:196 EST] 15ce7d TransactionIm e
resourceEnlistmentValid() - ENLISTMENT_INVALID
[12/23/03 18:33:08:196 EST] 15ce7d TransactionIm e Invalid resource
enlistment. Throwing IllegalStateException.
[12/23/03 18:33:08:197 EST] 15ce7d TransactionIm < enlistResource
With security disabled, the connections are flagged as identical and
equal; therefore, the resource connection handle is shared, eliminating
the need to enlist another resource. |
|
|
Resolving the
problem |
The problem is fixed with APAR PQ75055
which is included in WebSphere
Application Server 5.0.2 Cumulative Fix 2. Upgrading to WebSphere
Application Server 5.0.2 Cumulative Fix 2 or higher fixes the
problem. |
|
|
|
|
Cross Reference information |
Segment |
Product |
Component |
Platform |
Version |
Edition |
Application Servers |
Runtimes for Java Technology |
Java SDK |
|
|
|
|
|
|