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

[Brian Stansberry (JIRA)]

     [ https://issues.jboss.org/browse/WFLY-3569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brian Stansberry updated WFLY-3569:
-----------------------------------

       Assignee: Jesper Pedersen  (was: Jason Greene)
    Component/s: JCA


> 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) 
>          Components: JCA
>    Affects Versions: 8.1.0.Final
>            Reporter: Philippe Van Der Gucht
>            Assignee: Jesper Pedersen
>
> 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)