Hi All,
I have started to see a new error in our application. In this application, we spawn new threads for each MQ message received, and the steps provided below is what we do on each
thread. During my research, I found that this may be a thread safe issue. A brief description of what we do in the class that is generating this error:
1.Begin DB transaction
2.Insert/Update to DB
3.If Successful, Commit DB transaction
4.If Failure, Rollback DB transaction
5.Finally clause, whether an error occurs or not, we call a connection cleanup class that should close the connection. (This is the section which throws the following error regardless of previous DB transaction failure or success)
Have anyone seen this issue before, and if so, please advise what could be causing this.
Thanks,
Lulu
***********************************************************************
[4/14/05 1:12:41:325 CDT] 189856ab
MCWrapper E J2CA0081E: Method cleanup
failed while trying to execute method cleanup
on ManagedConnection
com.ibm.ws.rsadapter.spi.WSRdbManagedConnection
Impl@6fecd6a7 from resource
jdbc/TMTPDataSource. Caught exception:
com.ibm.ws.exception.WsException: DSRA0080E:
An exception was received by the Data Store
Adapter. See original exception message:
Cannot call 'cleanup' on a ManagedConnection
while it is still in a transaction..