Hi guys,

We are running our j2ee application in Websphere App Svr 6.0. We are connect
ing to two sql server 2000 sp4/win2k databases using two different datasourc
es from a session ejb bean one by one. No updation of data, only data retrie
val queries are executed. W
e are getting an sqlexception seldom, only while creating a prepared stateme
nt using the connection created by the second datasource. I have given the t
race below :

[1/16/06 17:01:40:408 CST] 000000f6 WSRdbXaResour E   DSRA0304E:  XAExce
ption occurred. XAException contents and details are: The cause is          
     : null.
[1/16/06 17:01:40:428 CST] 000000f6 WSRdbXaResour E   DSRA0302E:  XAExce
ption occurred.  Error code is: XAER_RMERR (-3).  Exception is: [IBM]	
1;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 exce
ption occurred while invoking start on an XA Resource Adapter from dataSourc
e jdbc/testds, within transaction ID {XidImpl: formatId(57415344), gtri
d_length(36), bqual_length(54), data
 (00000108d272ba1e00000002000001b73c88231
a4aa12e9679b56703eae3bfac52efc555000
 00108d272ba1e00000002000001b73c88231a4aa
12e9679b56703eae3bfac52efc5550000000
10000000000000000000000000002)}: 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(Un
known Source)
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown S
ource)
at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.ja
va: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(RegisteredResourc
es.java:1086)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredR
esources.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(WSRdbManag
edConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WS
JdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Co
de))


[1/16/06 17:01:40:458 CST] 000000f6 RegisteredRes E   WTRN0078E: An atte
mpt 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 tr
ace follows: javax.transaction.
xa.XAException: [IBM][SQLServer JDBC Driver]There is no process to r
ead data written to a pipe.
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Un
known Source)
at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown S
ource)
at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.ja
va: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(RegisteredResourc
es.java:1086)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredR
esources.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(WSRdbManag
edConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WS
JdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Co
de))


[1/16/06 17:01:40:472 CST] 000000f6 XATransaction E   J2CA0030E: Method 
enlist caught javax.transaction.SystemException: XAResource start associatio
n error:XAER_RMERR
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResourc
es.java:1140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredR
esources.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(WSRdbManag
edConnectionImpl.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WS
JdbcConnection.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnect
ion.java(Compiled Code))
at com.visa.fams.ejb.dao.AuditDAO.getAAEQryResults(AuditDAO.java(Compiled Co
de))



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

[ Post a follow-up to this message ]

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 sess
ion ejb bean one by one. No updation of data, only data retrieval queries are execut
ed.
We are getting an sqlexception seldom, only while creating a prepared statement using the co
nnection created by the second datasource. I have given the trace below :
>
> [1/16/06 17:01:40:408 CST] 000000f6 WSRdbXaResour E   DSRA0304E:  XAEx
ception occurred. XAException contents and details are: The cause is        
       : null.
> [1/16/06 17:01:40:428 CST] 000000f6 WSRdbXaResour E   DSRA0302E:  XAEx
ception occurred.  Error code is: XAER_RMERR (-3).  Exception is: [IBM]&
#91;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_le
ngth(54), da
 ta(00000108d272ba1e00000002000001b73c882
31a4aa12e9679b56703eae3bfac52efc5550
 0000108d272ba1e00000002000001b73c88231a4
aa12e9679b56703eae3bfac52efc55500000
0010000000000000000000000000002)}: javax.transaction.xa.XAException: [IB
M][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(Unknow
n 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:1
289)
> 	at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:
140)
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredReso
urces.java:1086)
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(Register
edResources.java:515)
> 	at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionI
mpl.java:3099)
> 	at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:3
76)
> 	at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:
623)
> 	at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:17
66)
> 	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbMa
nagedConnectionImpl.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary
(WSJdbcConnection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.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 a
n error. The error code was XAER_RMERR. The exception stack trace follows: javax.tra
nsactio
n.xa.XAException: [IBM][SQLServer JDBC Driver]There is no process to read data writt
en to a pipe.
> 	at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc
(Unknown Source)
> 	at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknow
n 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:1
289)
> 	at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:
140)
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredReso
urces.java:1086)
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(Register
edResources.java:515)
> 	at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionI
mpl.java:3099)
> 	at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:3
76)
> 	at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:
623)
> 	at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:17
66)
> 	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbMa
nagedConnectionImpl.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary
(WSJdbcConnection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.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: Metho
d enlist caught javax.transaction.SystemException: XAResource start associat
ion error:XAER_RMERR
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredReso
urces.java:1140)
> 	at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(Register
edResources.java:515)
> 	at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionI
mpl.java:3099)
> 	at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:3
76)
> 	at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:
623)
> 	at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:17
66)
> 	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbMa
nagedConnectionImpl.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary
(WSJdbcConnection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.java(Compiled Code))
> 	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConn
ection.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

[ Post a follow-up to this message ]

hi,

sorry for the delayed reply.

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

with regards,
t.jayakumar

[ Post a follow-up to this message ]