gardellajp [http://community.jboss.org/people/gardellajp] created the discussion "Re: JBPM's persistence reusing existing connection" To view the discussion, visit: http://community.jboss.org/message/642449#642449 -------------------------------------------------------------- Hi Andres, You can configure a JTA datasource and reuse in your application and in jBPM. Then open the transaction with the transaction manager. In the official documentation you have an example. Juan -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/642449#642449] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

gardellajp [http://community.jboss.org/people/gardellajp] created the discussion "Re: JBPM's persistence reusing existing connection" To view the discussion, visit: http://community.jboss.org/message/642466#642466 -------------------------------------------------------------- Hi Andres, See http://docs.jboss.org/hibernate/entitymanager/3.6/reference/en/html/archi... http://docs.jboss.org/hibernate/entitymanager/3.6/reference/en/html/archi.... +In a transaction-scoped container managed entity manager (common case in a Java EE environment), the JTA transaction propagation is the same as the persistence context resource propagation. In other words, container-managed transaction-scoped entity managers retrieved within a given JTA transaction all share the same persistence context. *In Hibernate terms, this means all managers share the same session.*+ So, you share session with JTA. Good things that jBPM JPAKnowledgeService use JTA to obtain transactions. JPAKnowledgeService javadoc says: +Long term out of the box persistence of runtime state with JPA is possible with Drools & jBPM. You will need to configure a JPA entity manager (e.g. using hibernate) *and have a JTA transaction manager* (for development/testing purposes we recommend Bitronix as it's simple to setup and works embedded, but for production the use of JBoss Transactions is recommended).+ Correct me Mauricio if I don't understand well how manage persistent in jBPM with JPAKnowledgeService. Andrés you can refer to some database with JTA, see http://stackoverflow.com/questions/3217586/difference-between-a-jta-datas... http://stackoverflow.com/questions/3217586/difference-between-a-jta-datas... Juan -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/642466#642466] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Andres Fernandez [http://community.jboss.org/people/ysh_fdez] created the discussion "Re: JBPM's persistence reusing existing connection" To view the discussion, visit: http://community.jboss.org/message/642648#642648 -------------------------------------------------------------- Thank very much Juan and Mauricio. Our applications create the connection as mode application managed entity manager. I'll trying to get a valid EntityManager from an instance of hibernate.Session. I will have the option to add a JTA transaction manager as plan B. We tested code that we have seen on the web, but as nothing has worked so I began to doubt. *First* way http://community.jboss.org/thread/163990 http://community.jboss.org/thread/163990 Code {{{      org.hibernate.Session session = ...      Configuration cfg = new Configuration();      cfg.configure("/hibernate.cfg.xml");      EntityManagerFactory emf =            new EntityManagerFactoryImpl(session.getSessionFactory(), PersistenceUnitTransactionType.RESOURCE_LOCAL, true, null, cfg);      Environment env = KnowledgeBaseFactory.newEnvironment();      env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);      StatefulKnowledgeSession ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null, env); }}} Error {{{      21/12/2011 08:38:10 [ERROR] (org.drools.persistence.SingleSessionCommandService)  - Could not commit session      java.lang.NullPointerException           at org.drools.persistence.jta.JtaTransactionManager.getStatus(JtaTransactionManager.java:205) }}}} *Second* way http://docs.jboss.org/drools/release/5.3.0.CR1/drools-expert-docs/html/ch... http://docs.jboss.org/drools/release/5.3.0.CR1/drools-expert-docs/html/ch... http://docs.jboss.org/jbpm/v5.1/javadocs/org/drools/runtime/StatefulKnowl... http://docs.jboss.org/jbpm/v5.1/javadocs/org/drools/runtime/StatefulKnowl... Code {{{      org.hibernate.Session session = ...      StatefulKnowledgeSession ksession = kbase.newStatefulKnowledgeSession();      ksession.setGlobal("hbnSession", session); }}} Error {{{      java.lang.RuntimeException: Unexpected global [hbnSession]           at org.drools.common.AbstractWorkingMemory.setGlobal(AbstractWorkingMemory.java:586)           at org.drools.impl.StatefulKnowledgeSessionImpl.setGlobal(StatefulKnowledgeSessionImpl.java:332) }}} If I get the code that works I'll put it here. Greetings -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/642648#642648] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]