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-Could-not-obtain-BTM-transaction-manager-instance-tp2927178p2931539.html Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users