Re: [rules-users] Drools flow persistence with Oracle, Could not obtain BTM transaction manager instance

The DBA added the grant to allow the recover of oracle ressource, so it resolve the problem. But another exception appear :-( Hibernate: select hibernate_sequence.nextval from dual May 12, 2011 2:14:09 PM org.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: 0, SQLState: null May 12, 2011 2:14:09 PM org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/CCOD02 in state ACCESSIBLE wrapping oracle.jdbc.xa.client.OracleXAConnection@1de2b1 on oracle.jdbc.driver.OracleConnection@dee38 java.lang.RuntimeException: Could not commit session at org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:119) at org.drools.persistence.jpa.impl.JPAKnowledgeServiceProviderImpl.newStatefulKnowledgeSession(JPAKnowledgeServiceProviderImpl.java:44) at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:93) at com.sample.ProcessTest.main(ProcessTest.java:61) Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not get next sequence value at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:226) at org.drools.persistence.session.SingleSessionCommandService.<init>(SingleSessionCommandService.java:107) ... 3 more Caused by: org.hibernate.exception.GenericJDBCException: could not get next sequence value at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:119) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122) at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49) at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154) at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110) at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61) at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:645) at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:619) at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:623) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220) ... 4 more Caused by: java.sql.SQLException: error enlisting a JdbcConnectionHandle of a JdbcPooledConnection from datasource jdbc/CCOD02 in state ACCESSIBLE wrapping oracle.jdbc.xa.client.OracleXAConnection@1de2b1 on oracle.jdbc.driver.OracleConnection@dee38 at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:61) at bitronix.tm.resource.jdbc.JdbcConnectionHandle.prepareStatement(JdbcConnectionHandle.java:200) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) at org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:145) at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96) ... 13 more Caused by: bitronix.tm.internal.BitronixSystemException: cannot enlist an XAResourceHolderState with uniqueName=jdbc/CCOD02 XAResource=oracle.jdbc.xa.client.OracleXAResource@1790581 with XID a Bitronix XID [3138342E35312E31362E3232300000012FE420DBC400000000 : 3138342E35312E31362E3232300000012FE420DC5100000002], error=XAER_PROTO at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:83) at bitronix.tm.resource.common.TransactionContextHelper.enlist(TransactionContextHelper.java:267) at bitronix.tm.resource.common.TransactionContextHelper.enlistInCurrentTransaction(TransactionContextHelper.java:49) at bitronix.tm.resource.jdbc.JdbcConnectionHandle.enlistResource(JdbcConnectionHandle.java:59) ... 17 more Caused by: javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.disallowLocalTxnMode(OracleXAResource.java:1045) at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:153) at bitronix.tm.internal.XAResourceHolderState.start(XAResourceHolderState.java:179) at bitronix.tm.internal.XAResourceManager.enlist(XAResourceManager.java:89) at bitronix.tm.BitronixTransaction.enlistResource(BitronixTransaction.java:76) ... 20 more -- View this message in context: http://drools.46999.n3.nabble.com/Drools-flow-persistence-with-Oracle-Cou... Sent from the Drools: User forum mailing list archive at Nabble.com.