Hi,

I am using Hibernate 3.0 with weblogic 9.0. Database is MSSQLServer 2000

I have done the necessary transaction attribute settings in my stateless session bean.

I have created the datasource using BEA MS SQL Server Driver with 2 phase commit enabled


Also I have done the necessary settings in hibernate.cfg.xml file

<property name="transaction.factory_class">
org.hibernate.transaction.CMTTransactionFactory
</property>
<property name="transaction.manager_lookup_class">
org.hibernate.transaction.WeblogicTransactionManagerLookup
</property>

When we try to run our processes , we are getting the following error

2006-04-04 15:48:11,974 [[STANDBY] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.enfs

.pes.job.server.USPInvoker - null:Error in getCallableStatement()

java.sql.SQLException: The transaction is no longer active - status: 'Committing'. No further JDBC access is allowed wit

hin this transaction.

at weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:190)

at weblogic.jdbc.wrapper.JTSConnection.checkConnection(JTSConnection.java:200)

at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:87)

at weblogic.jdbc.wrapper.Connection.prepareCall(Connection.java:537)

at weblogic.jdbc.wrapper.JTSConnection.prepareCall(JTSConnection.java:552)

at com.enfs.pes.job.server.USPInvoker.getCallableStatement(USPInvoker.java:181)

at com.enfs.common.jmsx.SimpleListener.logMessage(SimpleListener.java:185)

at com.enfs.common.jmsx.SimpleListener.processMessage(SimpleListener.java:115)

at com.enfs.common.jmsx.SimpleListener.onMessage(SimpleListener.java:68)

at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:3069)

at weblogic.jms.client.JMSSession.execute(JMSSession.java:2989)

at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:3448)

at weblogic.work.ServerWorkManagerImpl$WorkAdapterImpl.run(ServerWorkManagerImpl.java:518)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:179)

2006-04-04 15:48:12,115 [[STANDBY] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.enfs

.common.logging.Log - null:com.enfs.pes.dao.exception.DataAccessException: java.sql.SQLException: The transaction is no

longer active - status: 'Committing'. No further JDBC access is allowed within this transaction.

2006-04-04 15:48:12,162 [[STANDBY] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.enfs

.common.logging.Log - null:com.enfs.common.jmsx.JMSManagerException: com.enfs.pes.dao.exception.DataAccessException: jav

a.sql.SQLException: The transaction is no longer active - status: 'Committing'. No further JDBC access is allowed within

this transaction.


pl help me. It is very crucial in our project