Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

XA Resource Adapter Error

264 views
Skip to first unread message

thuyamani...@yahoo.com

unread,
Jan 17, 2006, 4:26:14 AM1/17/06
to
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), data(00000108d272ba1e00000002000001b73c88231a4aa12e9679b56703eae3bfac52efc55500000108d272ba1e00000002000001b73c88231a4aa12e9679b56703eae3bfac52efc555000000010000000000000000000000000002)}: 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(WSJdbcConnection.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(WSJdbcConnection.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(WSJdbcConnection.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

unread,
Jan 18, 2006, 8:46:28 PM1/18/06
to
thuyamani...@yahoo.com wrote:

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

thuyamani...@yahoo.com

unread,
Jan 23, 2006, 1:38:37 AM1/23/06
to
hi,

sorry for the delayed reply.

yeah, the connection is working successfully while clicking the test button.

with regards,
t.jayakumar

0 new messages