-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
8.1.0.Final
-
None
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:
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@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)
datasource configuration:
<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>