Philippe Van Der Gucht created WFLY-3569: -------------------------------------------- Summary: DB2 jdbc driver and XA datasource Key: WFLY-3569 URL: https://issues.jboss.org/browse/WFLY-3569 Project: WildFly Issue Type: Bug Security Level: Public (Everyone can see) Affects Versions: 8.1.0.Final Reporter: Philippe Van Der Gucht Assignee: Jason Greene Our type 4 JDBC compliant driver has trouble when writing to two different xa-datasources. A write has been issued to the datasources but not committed (2 phase). Then, before the commit, a read is done from one of the datasources and this happens: {noformat} 2014-06-30 15:53:59,837 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (default task-2) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1de1a1e[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@187619 connection handles=0 lastUse=1404136358809 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@1d0f8a mcp=SemaphoreArrayListManagedConnectionPool@b559c4[pool=ourDS] xaResource=XAResourceWrapperImpl@1e747c0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection(a)187619 pad=false overrideRmValue=null productName=IDS/UNIX64 productVersion=IFX11700 jndiName=java:/ourDS] txSync=null]: com.ibm.db2.jcc.am.XaException: [jcc][t4][10401][12066][4.13.127] XA exception: XAER_NOTA ERRORCODE=-4228, SQLSTATE=null at com.ibm.db2.jcc.am.id.c(id.java:454) at com.ibm.db2.jcc.am.id.c(id.java:478) at com.ibm.db2.jcc.t4.bc.a(bc.java:2094) at com.ibm.db2.jcc.t4.bc.a(bc.java:2333) at com.ibm.db2.jcc.t4.bc.start(bc.java:1934) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259) at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:203) {noformat} datasource configuration: {code:xml} <xa-datasource jndi-name="java:/ourDS" pool-name="ourDS" enabled="true"> <xa-datasource-property name="ServerName">127.0.0.1</xa-datasource-property> <xa-datasource-property name="PortNumber">9033</xa-datasource-property> <xa-datasource-property name="DatabaseName">ours</xa-datasource-property> <xa-datasource-property name="DriverType">4</xa-datasource-property> <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class> <driver>com.informix</driver> <security> <user-name>user</user-name> <password>password</password> </security> </xa-datasource> {code:xml} -- This message was sent by Atlassian JIRA (v6.2.6#6264)