Hi Martin,<br><br>I think that em.persist only updates the entity context (hibernate session). The DB is updated only after you commit transaction. So it looks like the transactions are not being committed in your case. That would be my guess.<br>
<br>Best regards<br>Michal<br><br><br><div class="gmail_quote">On Tue, Aug 4, 2009 at 9:14 AM, Ševčík Martin <span dir="ltr">&lt;<a href="mailto:MaSevcik@cpoj.cz">MaSevcik@cpoj.cz</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have a simple flow with human task and I want to persist it into database. I&#39;m using MSSQL DB.<br>
<br>
My code is like this:<br>
<br>
                KnowledgeBase kbase = readKnowledgeBase();<br>
                        // create the entity manager factory and register it in the environment<br>
                        EntityManagerFactory emf =<br>
                            Persistence.createEntityManagerFactory( &quot;org.drools.persistence.jpa&quot; );<br>
                        Environment env = KnowledgeBaseFactory.newEnvironment();<br>
                        env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );<br>
                        BitronixTransactionManager btm = TransactionManagerServices.getTransactionManager();<br>
                        env.set( EnvironmentName.TRANSACTION_MANAGER, btm);<br>
<br>
                        StatefulKnowledgeSession ksession =<br>
                            JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );<br>
<br>
                        KnowledgeRuntimeLogger logger = KnowledgeRuntimeLoggerFactory.newFileLogger(ksession, &quot;test&quot;);<br>
                        ksession.getWorkItemManager().registerWorkItemHandler(&quot;Human Task&quot;, new WSHumanTaskHandler());<br>
                        // start a new process instance<br>
                        Map&lt;String,Object&gt; data = new HashMap&lt;String,Object&gt;();<br>
                        data.put(&quot;data3&quot;, new MyTask(1,&quot;This is taks 1&quot;));<br>
                        ProcessInstance pi = ksession.startProcess(&quot;com.sample.ruleflow&quot;,data);<br>
                        logger.close();<br>
<br>
But when i run it, it end up with this error and there is nothing in the database (the tables were created, but there are all empty):<br>
<br>
java.lang.NullPointerException<br>
        at org.drools.persistence.processinstance.ProcessInstanceInfo.getId(ProcessInstanceInfo.java:70)<br>
        at org.drools.persistence.processinstance.JPAProcessInstanceManager.addProcessInstance(JPAProcessInstanceManager.java:34)<br>
        at org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1620)<br>
        at org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:46)<br>
        at org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:10)<br>
        at org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:229)<br>
        at org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:163)<br>
        at com.sample.RuleFlowPersistenceTest.main(RuleFlowPersistenceTest.java:74)<br>
java.lang.RuntimeException: Could not rollback transaction<br>
        at org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:258)<br>
        at org.drools.process.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:163)<br>
        at com.sample.RuleFlowPersistenceTest.main(RuleFlowPersistenceTest.java:74)<br>
Caused by: java.lang.RuntimeException: Could not execute command<br>
        at org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:255)<br>
        ... 2 more<br>
Caused by: java.lang.NullPointerException<br>
        at org.drools.persistence.processinstance.ProcessInstanceInfo.getId(ProcessInstanceInfo.java:70)<br>
        at org.drools.persistence.processinstance.JPAProcessInstanceManager.addProcessInstance(JPAProcessInstanceManager.java:34)<br>
        at org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1620)<br>
        at org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:46)<br>
        at org.drools.process.command.StartProcessCommand.execute(StartProcessCommand.java:10)<br>
        at org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:229)<br>
        ... 2 more<br>
<br>
In JPAProcessInstanceManager.java there this method is called:<br>
<br>
    public void addProcessInstance(ProcessInstance processInstance) {<br>
        ProcessInstanceInfo processInstanceInfo = new ProcessInstanceInfo( processInstance );<br>
        EntityManager em = (EntityManager) this.workingMemory.getEnvironment().get( EnvironmentName.ENTITY_MANAGER );<br>
        em.persist( processInstanceInfo );<br>
        ((ProcessInstance) processInstance).setId( processInstanceInfo.getId() );<br>
        processInstanceInfo.updateLastReadDate();<br>
        internalAddProcessInstance(processInstance);<br>
    }<br>
<br>
<br>
But em.persist does nothing, no connection do DB is called. And then the  next line will fail.<br>
<br>
<br>
<br>
<br>
Can anybody help me.<br>
<br>
Thanks<br>
<br>
Martin Sevcik<br>
<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</blockquote></div><br>