[jboss-jira] [JBoss JIRA] (WFLY-3569) DB2 jdbc driver and XA datasource

[Philippe Van Der Gucht (JIRA)]

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 at 1de1a1e[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection at 187619 connection handles=0 lastUse=1404136358809 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool at 1d0f8a mcp=SemaphoreArrayListManagedConnectionPool at b559c4[pool=ourDS] xaResource=XAResourceWrapperImpl at 1e747c0[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection at 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)