|
Hi
I am getting the below exception whan i deployed the application on WAS 6.0.2 On WAS 5.x the same application is working well.
Hibernate version: I just upgraded to 3.1.3 thinking it might fix
and i am using
txn.factory = org.hibernate.transaction.JTATransactionFactory
txn.manager = org.hibernate.transaction.WebSphereTransactionManagerLookup
Please let mw know what ever information you have
Thanks in ADV
==================
[9/18/06 13:52:24:647 EDT] 0000005c 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), data(0000010dc20e9e8d000000010000000113f69dcf08f2e1f41bd6c95116d7864ad9040d720000010dc20e9e8d000000010000000113f69dcf08f2e1f41bd6c95116d7864ad9040d72000000010000000000000000000000000002)}: 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(WSJdbcConnection.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(Loader.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(HibernateTemplate.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(ServerSession.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/18/06 13:52:24:735 EDT] 0000000a WsServerImpl A WSVR0002I: Server MMS-SVR1-Q open for e-business, problems occurred during startup
[9/18/06 13:52:25:540 EDT] 0000005c 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(WSJdbcConnection.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(Loader.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(HibernateTemplate.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(ServerSession.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/18/06 13:52:25:684 EDT] 0000005c 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(WSJdbcConnection.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(Loader.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(HibernateTemplate.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(ServerSession.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/18/06 13:52:26:351 EDT] 0000005f WorkSpaceMana A WKSP0023I: Workspace configuration consistency check is enabled.
[9/18/06 13:52:26:468 EDT] 0000005c JDBCException W SQL Error: 0, SQLState: null
[9/18/06 13:52:26:475 EDT] 0000005c JDBCException E enlist: caught Exception
[9/18/06 13:52:26:490 EDT] 0000005c ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "process" on bean "BeanId(MMS#mms-txn-ejb.jar#MMSTransactionProcessor, null)". Exception data: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception
Caused by: java.sql.SQLException: enlist: caught Exception
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1160)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:603)
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(Loader.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(HibernateTemplate.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(ServerSession.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)
Caused by: javax.resource.ResourceException: enlist: caught Exception
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:723)
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(WSJdbcConnection.java:549)
... 47 more
Caused by: 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)
... 50 more
[9/18/06 13:52:26:638 EDT] 0000005c ServerSession W WMSG0031E: Exception processing JMS Message for MDB MMSTransactionConsumerBean, JMSDestination jms/MMSTxnQ : javax.ejb.TransactionRolledbackLocalException: ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception
Caused by: java.sql.SQLException: enlist: caught Exception
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1160)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:603)
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(Loader.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(HibernateTemplate.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(ServerSession.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)
Caused by: javax.resource.ResourceException: enlist: caught Exception
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:723)
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(WSJdbcConnection.java:549)
... 47 more
Caused by: 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)
... 50 more
javax.ejb.TransactionRolledbackLocalException: ; nested exception is: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select transactio0_.TXN_TYPE_ID as TXN1_1_, transactio0_.NAME as NAME1_, transactio0_.DESCRIPTION as DESCRIPT3_1_ from MMS_TXN_TYPE transactio0_ where transactio0_.NAME=?]; SQL state [null]; error code [0]; enlist: caught Exception; nested exception is java.sql.SQLException: enlist: caught Exception
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:268)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
at org.springframework.orm.hibernate3.HibernateTemplate.findByNamedQueryAndNamedParam(HibernateTemplate.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(ServerSession.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)
|
Login
FAQ
Search
