-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Hibernate & WAS 6.0
PostPosted: Mon Sep 18, 2006 1:08 pm 
Newbie

Joined: Mon Sep 18, 2006 12:56 pm
Posts: 1
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)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 18, 2006 2:47 pm 
Newbie

Joined: Tue Sep 27, 2005 5:44 pm
Posts: 13
Check out the following threads. I went through a few hoops getting hibernate up with WAS. Others had similar difficulties so I think its a WAS problem.

http://opensource.atlassian.com/projects/hibernate/browse/HHH-198

http://forum.hibernate.org/viewtopic.php?t=963579


Top
 Profile  
 
 Post subject:
PostPosted: Mon Sep 18, 2006 11:38 pm 
Beginner
Beginner

Joined: Sat Nov 22, 2003 3:54 pm
Posts: 42
Your transaction manager should be "org.hibernate.transaction.WebSphereExtendedJTATransactionLookup" for WAS 6.0 and above.

If you are using just container managed transaction then you might want to try "org.hibernate.transaction.CMTTransactionFactory" as your transaction factory.

Cheers
Vijay


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.