[jboss-jira] [JBoss JIRA] (WFLY-3569) DB2 jdbc driver and XA datasource
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)