topic Re: Transaction RollbackException with Activiti/WebSphere/Spring in Alfresco Archive

Transaction RollbackException with Activiti/WebSphere/Spring

bwestrich — Wed, 02 Nov 2011 17:07:32 GMT

Hello Activiti gurus, I'm attempting to embed Activiti (5.8) into a WebSphere (7.x) application using Spring (3.0.4), but am getting a javax.transaction.RollbackException. Here's my Spring config: <tx:annotation-driven /><tx:jta-transaction-manager /><bean id="dataSource" class="org.s

Re: Transaction RollbackException with Activiti/WebSphere/Spring

bwestrich — Wed, 02 Nov 2011 17:28:28 GMT

I also noticed this on the SystemOut.log……..


[11/2/11 12:22:40:974 CDT] 00000026 SystemOut     O [12:22:40,974 INFO  'WMQJCAResourceAdapter : 0' org.mypackage.ArrivedListener ArrivedListener] arrived fired for process instance 3505
[11/2/11 12:22:41:209 CDT] 00000026 RegisteredRes E   WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.[11/2/11 12:22:41:224 CDT] 00000026 RegisteredRes E   WTRN0086I: XAException encountered during prepare phase for transaction BPSMEA#bpsm-service-ejb-1.39-SNAPSHOT.jar#BpsmListenerService 00000133654DDA03000000010000001737CC227B4A7BDDB5D2D3D44C9362B668BF7B37E700000133654DDA03000000010000001737CC227B4A7BDDB5D2D3D44C9362B668BF7B37E700000001. Local resources follow.
[11/2/11 12:22:41:224 CDT] 00000026 JTAResourceBa I   WTRN0089I: LocalTransactionWrapper@:16d716d7  localTransaction:com.ibm.ws.rsadapter.spi.WSRdbSpiLocalTransactionImpl@53c853c8  enlisted:trueHas Tran Rolled Back = false  registeredForSynctruemcWrapper.hashcode()371267105: Vote: none.
[11/2/11 12:22:41:224 CDT] 00000026 JTAResourceBa I   WTRN0089I: XATransactionWrapper@ 6730673  XAResource: com.ibm.ejs.jms.JMSManagedSession$JMSXAResource@6ec46ec4  enlisted: trueHas Tran Rolled Back = false  mcWrapper.hashCode()1802660722: Vote: commit.

Re: Transaction RollbackException with Activiti/WebSphere/Spring

trademak — Wed, 02 Nov 2011 18:46:56 GMT

Is the database you configured a XA resource?
And are you using a XA transaction manager because you need two phase commit?

Best regards,

Re: Transaction RollbackException with Activiti/WebSphere/Spring

bwestrich — Wed, 02 Nov 2011 19:28:39 GMT

Yes, the datasource I initially used was an XA resource. We don't need two phase commit, so I just changed the datasource to a non XA resource, and this resolved the issue. Many thanks!