|
Home > Archive > WebSphere Application Server > September 2006 > XAER_PROTO Error Using WAS 6.x and DB2 8.X
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 |
XAER_PROTO Error Using WAS 6.x and DB2 8.X
|
|
|
| Hi,
I am getting the following exception. I am running the application on WAS 6.x
The application is still running fine on WAS 5.x.
Please let me know is there any specific settings i need to do in WAS 6.x to connect to DB2 for XA datasources.
[9/15/06 10:16:12:455 EDT] 00000020 XATransaction E J2CA0027E: An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/MMSXA_QA, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), da
ta(0000010db1d59f7300000001000000014327f
f75b309a9dffbc0d70947caadb557d968d700000
10db1d59f7300000001000000014327ff75b309a
9dffbc0d70947caadb557d968d70000000100000
00000000000000000000002)}: com.ibm.db2.jcc.b.se: XAER_PROTO
at com.ibm.db2.jcc.uw.UWXAResource.a(UWXAResource.java:713)
at com.ibm.db2.jcc.uw.UWXAResource.start(UWXAResource.java:614)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1481)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1288)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1084)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:514)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3019)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:622)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1759)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java:549)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1830)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1785)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader. doQueryAndInitializeNonLazyCollections(L
oader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:925)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate. findByNamedQueryAndNamedParam(HibernateT
emplate.java:916)
at com.staples.mms.dao.AbstractHibernateDAO.findByNamedQuery(AbstractHibernateDAO.java:65)
at com.staples.mms.dao.AbstractHibernateDAO.findUnique(AbstractHibernateDAO.java:201)
at com.staples.mms.dao.txn.TransactionTypeDAO.findByTypeName(TransactionTypeDAO.java:43)
at com.staples.mms.service.txn.generic.TransactionTypeValidationRule.validate(TransactionTypeValidationRule.java:56)
at com.staples.mms.service.txn.generic.TransactionValidationServiceImpl. process(TransactionValidationServiceImpl
.java:47)
at com.staples.mms.service.txn.generic.TransactionProcessorServiceImpl.process(TransactionProcessorServiceImpl.java:43)
at com.staples.mms.txn.ejb.MMSTransactionProcessorBean.process(Unknown Source)
at com.staples.mms.txn.ejb. EJSLocalStatelessMMSTransactionProcessor
_83279595.process(Unknown Source)
at com.staples.mms.txn.ejb.AbstractTransactionConsumerBean.onMessage(Unknown Source)
at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:316)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage(MDBWrapper.java:285)
at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBWrapper.java:263)
at com.ibm.mq.jms.MQSession.run(MQSession.java:1682)
at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHandle.java:960)
at com.ibm.ejs.jms.listener.ServerSession. connectionConsumerOnMessage(ServerSessio
n.java:826)
at com.ibm.ejs.jms.listener.ServerSession.onMessage(ServerSession.java:616)
at com.ibm.ejs.jms.listener.ServerSession.dispatch(ServerSession.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ejs.jms.listener.ServerSessionDispatcher.dispatch(ServerSessionDispatcher.java:37)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:91)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:127)
at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:458)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)
..
[9/15/06 10:16:12:638 EDT] 00000026 DiscoveryMBea I ADMD0023I: The system discovered process (name: nodeagent, type: NodeAgent, pid: 458914)
[9/15/06 10:16:12:702 EDT] 00000020 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_PROTO. The exception stack trace follows: com.ibm.db2.jcc.b.
se: XAER_PROTO
at com.ibm.db2.jcc.uw.UWXAResource.a(UWXAResource.java:713)
at com.ibm.db2.jcc.uw.UWXAResource.start(UWXAResource.java:614)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1481)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1288)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:140)
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1084)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:514)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3019)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:622)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1759)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java:549)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1830)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1785)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader. doQueryAndInitializeNonLazyCollections(L
oader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:925)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate. findByNamedQueryAndNamedParam(HibernateT
emplate.java:916)
at com.staples.mms.dao.AbstractHibernateDAO.findByNamedQuery(AbstractHibernateDAO.java:65)
at com.staples.mms.dao.AbstractHibernateDAO.findUnique(AbstractHibernateDAO.java:201)
at com.staples.mms.dao.txn.TransactionTypeDAO.findByTypeName(TransactionTypeDAO.java:43)
at com.staples.mms.service.txn.generic.TransactionTypeValidationRule.validate(TransactionTypeValidationRule.java:56)
at com.staples.mms.service.txn.generic.TransactionValidationServiceImpl. process(TransactionValidationServiceImpl
.java:47)
at com.staples.mms.service.txn.generic.TransactionProcessorServiceImpl.process(TransactionProcessorServiceImpl.java:43)
at com.staples.mms.txn.ejb.MMSTransactionProcessorBean.process(Unknown Source)
at com.staples.mms.txn.ejb. EJSLocalStatelessMMSTransactionProcessor
_83279595.process(Unknown Source)
at com.staples.mms.txn.ejb.AbstractTransactionConsumerBean.onMessage(Unknown Source)
at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:316)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage(MDBWrapper.java:285)
at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBWrapper.java:263)
at com.ibm.mq.jms.MQSession.run(MQSession.java:1682)
at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHandle.java:960)
at com.ibm.ejs.jms.listener.ServerSession. connectionConsumerOnMessage(ServerSessio
n.java:826)
at com.ibm.ejs.jms.listener.ServerSession.onMessage(ServerSession.java:616)
at com.ibm.ejs.jms.listener.ServerSession.dispatch(ServerSession.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ejs.jms.listener.ServerSessionDispatcher.dispatch(ServerSessionDispatcher.java:37)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:91)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:127)
at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:458)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)
[9/15/06 10:16:12:866 EDT] 00000020 XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: XAResource start association error:XAER_PROTO
at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1134)
at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:514)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3019)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:376)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:622)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:1759)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2043)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection. beginTransactionIfNecessary(WSJdbcConnec
tion.java:549)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1830)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1785)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader. doQueryAndInitializeNonLazyCollections(L
oader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.springframework.orm.hibernate3.HibernateTemplate$33.doInHibernate(HibernateTemplate.java:925)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate. findByNamedQueryAndNamedParam(HibernateT
emplate.java:916)
at com.staples.mms.dao.AbstractHibernateDAO.findByNamedQuery(AbstractHibernateDAO.java:65)
at com.staples.mms.dao.AbstractHibernateDAO.findUnique(AbstractHibernateDAO.java:201)
at com.staples.mms.dao.txn.TransactionTypeDAO.findByTypeName(TransactionTypeDAO.java:43)
at com.staples.mms.service.txn.generic.TransactionTypeValidationRule.validate(TransactionTypeValidationRule.java:56)
at com.staples.mms.service.txn.generic.TransactionValidationServiceImpl. process(TransactionValidationServiceImpl
.java:47)
at com.staples.mms.service.txn.generic.TransactionProcessorServiceImpl.process(TransactionProcessorServiceImpl.java:43)
at com.staples.mms.txn.ejb.MMSTransactionProcessorBean.process(Unknown Source)
at com.staples.mms.txn.ejb. EJSLocalStatelessMMSTransactionProcessor
_83279595.process(Unknown Source)
at com.staples.mms.txn.ejb.AbstractTransactionConsumerBean.onMessage(Unknown Source)
at com.ibm.ejs.jms.listener.MDBWrapper$PriviledgedOnMessage.run(MDBWrapper.java:316)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ejs.jms.listener.MDBWrapper.callOnMessage(MDBWrapper.java:285)
at com.ibm.ejs.jms.listener.MDBWrapper.onMessage(MDBWrapper.java:263)
at com.ibm.mq.jms.MQSession.run(MQSession.java:1682)
at com.ibm.ejs.jms.JMSSessionHandle.run(JMSSessionHandle.java:960)
at com.ibm.ejs.jms.listener.ServerSession. connectionConsumerOnMessage(ServerSessio
n.java:826)
at com.ibm.ejs.jms.listener.ServerSession.onMessage(ServerSession.java:616)
at com.ibm.ejs.jms.listener.ServerSession.dispatch(ServerSession.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ejs.jms.listener.ServerSessionDispatcher.dispatch(ServerSessionDispatcher.java:37)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:91)
at com.ibm.ejs.container.MDBWrapper.onMessage(MDBWrapper.java:127)
at com.ibm.ejs.jms.listener.ServerSession.run(ServerSession.java:458)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1394)
while trying to enlist resources from datasource jdbc/MMSXA_QA with the Transaction Manager for the current transaction, and threw a ResourceException.
[9/15/06 10:16:12:964 EDT] 0000000a WsServerImpl A WSVR0002I: Server MMS-SVR1-Q open for e-business, problems occurred during startup
Thanks in Advance
| |
|
|
| Randy Schnier 2006-09-16, 1:48 pm |
| I see Spring and Hibernate classes in the stack trace. You'd probably
want to consult with Spring and/or Hibernate support first, since those
classes are effectively part of the user application.
Spring and Hibernate have been known in the past to call into
undocumented private WebSphere implementation classes, with similar
problems resulting. If you decide to consult with Spring or Hibernate
support, you may want to ask that they make sure to provide you a
version of their products that uses only standard, public, documented APIs.
Ben_ wrote:
> Maybe you're missing a fix.
>
> http://www-1.ibm.com/support/search... />
0+DB500&dtm
>
>
|
|
|
|
|