An illegal attempt to commit a one phase capable resource with existing two phase capable resources
surf...@aol.com
When I debug my code, I see that I can insert to DB2 and even can close connection without any Exception. However, the transaction gets rolled back with following exception message:
[11/11/05 17:21:32:265 EST] 639d639d WSRdbDataSour I DSRA8203I: Database product name : DB2
[11/11/05 17:21:32:281 EST] 639d639d WSRdbDataSour I DSRA8204I: Database product version : 07.01.0001
[11/11/05 17:21:32:281 EST] 639d639d WSRdbDataSour I DSRA8205I: JDBC driver name : IBM DB2 JDBC 2.0 Type 2
[11/11/05 17:21:32:281 EST] 639d639d WSRdbDataSour I DSRA8206I: JDBC driver version : 07.02.0000
[11/11/05 17:21:41:031 EST] 639d639d RegisteredRes E WTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred.
[11/11/05 17:21:41:218 EST] 639d639d ServerSession W WMSG0031E: Exception processing JMS Message for MDB ArchiveIngest, JMSDestination jms/SAM.TEST : javax.ejb.TransactionRolledbackLocalException: ; nested exception is: com.ibm.ws.exception.WsEJBException
com.ibm.ws.exception.WsEJBException
at java.lang.Throwable.<init>(Throwable.java)
at javax.ejb.EJBException.<init>(EJBException.java:26)
at com.ibm.ws.exception.WsEJBException.<init>(WsEJBException.java:105)
at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapException(LocalExceptionMappingStrategy.java:159)
at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapCSITransactionRolledBackException(LocalExceptionMappingStrategy.java:293)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3128)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:102)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:127)
at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:372)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
javax.ejb.TransactionRolledbackLocalException: ; nested exception is: com.ibm.ws.exception.WsEJBException
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java:73)
at javax.ejb.EJBException.<init>(EJBException.java:50)
at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapCSIException(LocalExceptionMappingStrategy.java:96)
at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapException(LocalExceptionMappingStrategy.java:165)
at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapCSITransactionRolledBackException(LocalExceptionMappingStrategy.java:293)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3128)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:102)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:127)
at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:372)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
What settings do I need in WSAD test server?
Paul Ilechko
> I listen to message in Message Driven bean. I use Datasource to
> insert record in DB2 from onMessage(..) by calling other DataAccess
> POJO classes using Datasource.
>
> When I debug my code, I see that I can insert to DB2 and even can
> close connection without any Exception. However, the transaction gets
> rolled back with following exception message:
The fact that you can insert a row to a database has no correlation to
the ability of that database, using a given driver, to participate in a
two-phase commit XA transaction. If you don't understand what I just
said, you're either in the wrong business or you need to start doing
some serious reading. A J2EE application server is an XA transaction
coordinator, so it's very helpful to know what a transaction is.