|
Home > Archive > WebSphere Application Server > January 2006 > XA Resource Adapter Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
XA Resource Adapter Error
|
|
|
| Hi guys,
We are running our j2ee application in Websphere App Svr 6.0. We are connecting to two sql server 2000 sp4/win2k databases using two different datasources from a session ejb bean one by one. No updation of data, only data retrieval queries are executed. W
e are getting an sqlexception seldom, only while creating a prepared statement using the connection created by the second datasource. I have given the trace below :
[1/16/06 17:01:40:408 CST] 000000f6 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
[1/16/06 17:01:40:428 CST] 000000f6 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is: [IBM][SQLServer JDBC Driver]There is no process to read data written to a pipe.
[1/16/06 17:01:40:443 CST] 000000f6 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/testds, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), data
(00000108d272ba1e00000002000001b73c88231
a4aa12e9679b56703eae3bfac52efc5550000010
8d272ba1e00000002000001b73c88231a4aa12e9
679b56703eae3bfac52efc555000000010000000
000000000000000000002)}: javax.transaction.xa.XAException: [IBM][SQLServer JDBC Driver]There is
no process to read data written to a pipe.
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1322)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1086)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
[1/16/06 17:01:40:458 CST] 000000f6 RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.
xa.XAException: [IBM][SQLServer JDBC Driver]There is no process to read data written to a pipe.
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown Source)
at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1322)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1086)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
[1/16/06 17:01:40:472 CST] 000000f6 XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: XAResource start association error:XAER_RMERR
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
Whenever the data retrieval failed bcoz of the above exception, if the form is resubmitted it will execute and retrieve the data without any problem. We couldn't figure out what may be the reason for the above?
Did anybody faced similar problem and got the solution?
with regards,
t.jayakumar
| |
| Kenneth Stephen 2006-01-18, 8:50 pm |
| thuyamanijayakumar@yahoo.com wrote:
> Hi guys,
>
> We are running our j2ee application in Websphere App Svr 6.0. We are connecting to two sql server 2000 sp4/win2k databases using two different datasources from a session ejb bean one by one. No updation of data, only data retrieval queries are executed.
We are getting an sqlexception seldom, only while creating a prepared statement using the connection created by the second datasource. I have given the trace below :
>
> [1/16/06 17:01:40:408 CST] 000000f6 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
> [1/16/06 17:01:40:428 CST] 000000f6 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is: [IBM][SQLServer JDBC Driver]There is no process to read data written to a pipe.
> [1/16/06 17:01:40:443 CST] 000000f6 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/testds, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), da
ta(00000108d272ba1e00000002000001b73c882
31a4aa12e9679b56703eae3bfac52efc55500000
108d272ba1e00000002000001b73c88231a4aa12
e9679b56703eae3bfac52efc5550000000100000
00000000000000000000002)}: javax.transaction.xa.XAException: [IBM][SQLServer JDBC Driver]There
is no process to read data written to a pipe.
> at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
> at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown Source)
> at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
> at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1322)
> at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
> at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
> at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1086)
> at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
> at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
> at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
> at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
> at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
> at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
>
>
> [1/16/06 17:01:40:458 CST] 000000f6 RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: javax.transactio
n.xa.XAException: [IBM][SQLServer JDBC Driver]There is no process to read data written to a pipe.
> at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
> at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown Source)
> at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
> at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1322)
> at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1289)
> at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
> at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1086)
> at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
> at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
> at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
> at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
> at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
> at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
>
>
> [1/16/06 17:01:40:472 CST] 000000f6 XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: XAResource start association error:XAER_RMERR
> at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1140)
> at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:515)
> at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3099)
> at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
> at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:623)
> at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1766)
> at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled Code))
> at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Code))
>
>
>
Hi,
In the WAS v5.x admin console, if one looks at the datasource, there is
a button to "Test Connection" via the datasource. There probably is a
similar button for v6. Have you tried testing the datasource in this way?
Thanks,
Kenneth
| |
|
| hi,
sorry for the delayed reply.
yeah, the connection is working successfully while clicking the test button.
with regards,
t.jayakumar
|
|
|
|
|