We are using hibernate 2.1.7. Everything seems to work fine when we run it on SQLServer. But we run into the following exception when we try it on Oracle. The driver version is 9.2.0.5.

[6/14/05 11:17:56:417 PDT] 37074a26 MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@18e98a77 from resource PostXDB. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction..
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:217)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:171)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:209)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:2613)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:2320)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1169)
at com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java:326)
at com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java:1275)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:1678)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionClosed(ConnectionEventListener.java:217)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionClosedEvent(WSRdbManagedConnectionImpl.java:1042)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.closeWrapper(WSJdbcConnection.java:561)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:126)
at com.postx.websphere.hibernate.WSDataSourceConnectionProvider.closeConnection(WSDataSourceConnectionProvider.java:104)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:103)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1160)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:794)
at net.sf.hibernate.jmx.HibernateService.buildSessionFactory(HibernateService.java:163)
at net.sf.hibernate.jmx.HibernateService.start(HibernateService.java:130)
at com.postx.hibernate.PxHibernateService.start(PxHibernateService.java:142)
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:60)
at java.lang.reflect.Method.invoke(Method.java:391)
at com.tivoli.jmx.DynamicMBeanSupport.invokeMethod(DynamicMBeanSupport.java:242)
at com.tivoli.jmx.DynamicMBeanSupport.invoke(DynamicMBeanSupport.java:166)
at com.tivoli.jmx.GenericMBeanSupport.invoke(GenericMBeanSupport.java:178)
at com.tivoli.jmx.MBeanAccess.invoke(MBeanAccess.java:113)
at com.tivoli.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:290)
at com.postx.startup.ServiceLauncherThread.run(ServiceLauncherThread.java:269)

Let me know if you have run into a similar problem.

Thanks
Shankar