Troubleshooting
Problem
WebSphere Adapter for JDBC is included as part of a global transction and accesses shared data in database tables. This shared data in the database tables is also accessed by another application. As part of the global transaction, WebSphere JDBC Adapter holds locks on the table, which causes the other application to timeout when it tries to access the same shared data.
Symptom
In addition to transactions timing out, you might also see the following error messages:
6/23/08 14:36:00:754 EDT] 0000c4be ExceptionUtil E CNTR0019E: EJB
threw an unexpected (non-declared) exception during invocation of method
"invokeFaultFlow". Exception data:
com.ibm.websphere.csi.CSITransactionRolledbackException: Transaction
rolled back; nested exception is:
javax.transaction.TransactionRolledbackException:
Transaction is ended due to timeout
:
:
:
6/23/08 16:43:29:163 EDT] 0000cda2 UnlockUtil E
com.ibm.wbiserver.sequencing.wcc.UnlockUtil unlock CWRES0005E: Failed to unlock with error javax.ejb.TransactionRolledbackLocalException: ;
nested exception is: javax.transaction.TransactionRolledbackException:
Transaction is ended due to timeout
com.ibm.wbiserver.sequencing.exceptions.LockManagerException:
javax.ejb.TransactionRolledbackLocalException: ; nested exception is:
javax.transaction.TransactionRolledbackException: Transaction is ended
due to timeout at
com.ibm.wbiserver.sequencing.wcc.UnlockUtil.unlockOnly(UnlockUtil.java(C
ompiled Code))
Cause
WebSphere JDBC Adapter is included as part of a global transaction, and accesses shared data in database tables.
Resolving The Problem
Remove the WebSphere JDBC Adapter from the global transaction if it accesses shared data. Instead, use some mechanism at the business level to ensure that the business data is consistent. For example, use variables to indicate whether or not the operation on the shared data is successful, and log the critical operation on this data.
Was this topic helpful?
Document Information
More support for:
WebSphere Adapters Family
Software version:
7.5, 7.0.2, 7.0.1, 7.0.0.4, 7.0.0.3, 7.0.0.2, 7.0.0.1, 7.0, 6.2.0.3, 6.2.0.2, 6.2.0.1, 6.2, 6.1, 6.0.2.3
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
357823
Modified date:
15 June 2018
UID
swg21316337