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)
|