For the records: I have created <meta http-equiv="content-type" content="text/html; charset=utf-8"><a href="https://issues.jboss.org/browse/JBRULES-2913">https://issues.jboss.org/browse/JBRULES-2913</a>. I will fix it as soon as Mark fixes the trunk ;)<div>
<br></div><div>Best Regards,<br clear="all"><br>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX<br><br>Esteban Aliverti<br>- Developer @ <a href="http://www.plugtree.com" target="_blank">http://www.plugtree.com </a><br>- Blog @ <a href="http://ilesteban.wordpress.com" target="_blank">http://ilesteban.wordpress.com</a><br>
<br><br><div class="gmail_quote">2011/3/1 odelyaholiday <span dir="ltr"><<a href="mailto:odelyay@sintecmedia.com">odelyay@sintecmedia.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thanks!</span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Can you elaborate the solution?</span></p><p class="MsoNormal">
<span style="font-size:11.0pt;color:#1F497D"> </span></p><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> Esteban [via Drools - Java Rules Engine] [mailto:<a href="http://user/SendEmail.jtp?type=node&node=2602869&i=0" rel="nofollow" target="_blank">[hidden email]</a>] <br>
<b>Sent:</b> Tuesday, March 01, 2011 2:37 PM<br><b>To:</b> Odelya Holiday<br><b>Subject:</b> Re: Caused by: java.lang.NullPointerException at org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:181)</span></p>
</div><div class="im"><p class="MsoNormal"> </p><p class="MsoNormal">Unfortunately there is a "bug" (it is not really a bug but an omission in the code) that hides the real exception going on. The piece of code giving you troubles is (SingleSessionCommandService.java lines 119 - 138):</p>
<div><p class="MsoNormal"> </p></div><div><div><p class="MsoNormal"> <i><span style="font-family:"Courier New"">try {</span></i></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> this.txm.begin();</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> </span></i></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> //this.appScopedEntityManager.joinTransaction();</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> registerRollbackSync();</span></i></p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> jpm.getApplicationScopedPersistenceContext().persist( this.sessionInfo );</span></i></p>
</div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> this.txm.commit();</span></i></p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">
<i><span style="font-family:"Courier New""> } catch ( Exception <b>t1</b> ) {</span></i></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> try {</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> <b>this.txm.rollback();</b></span></i></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> } catch ( Throwable t2 ) {</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> <b> throw new RuntimeException( "Could not commit session or rollback",</b></span></i></p></div><div><p class="MsoNormal">
<b><i><span style="font-family:"Courier New""> t2 );</span></i></b></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> }</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> throw new RuntimeException( "Could not commit session",</span></i></p></div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> t1 );</span></i></p>
</div><div><p class="MsoNormal"><i><span style="font-family:"Courier New""> }</span></i></p></div></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">As you can see, when there is a problem in the body of the try-catch, drools tries to rollback the session. If the rollback itself fails, you get the exception "Could not commit session or rollback", but the original exception (t1) is lost.</p>
</div><div><p class="MsoNormal">We already fixed a similar issue in SingleSessionCommandService#execute() and created a rollbackTransaction() method that logs the first exception if the session rollback fails. </p></div>
<div>
<p class="MsoNormal">So, the solution (not a solution but a hack to see what is really going on) is to use the same rollbackTransaction() method in the catch part. If you want to see the real exception, you will need to download drools-persistence-jpa sources from <a href="https://github.com/droolsjbpm/drools/tree/master/drools-persistence-jpa" rel="nofollow" link="external" target="_blank">https://github.com/droolsjbpm/drools/tree/master/drools-persistence-jpa</a> and debug through the lines I mentioned. Or you can wait us to patch the code ;)</p>
</div><div><p class="MsoNormal">For the records, this is the bug previously reported: <a href="https://issues.jboss.org/browse/JBRULES-2656" rel="nofollow" link="external" target="_blank">https://issues.jboss.org/browse/JBRULES-2656</a>. I will create a new one and link them together. </p>
</div><div><p class="MsoNormal"> </p></div></div><div><div class="im"><p class="MsoNormal" style="margin-bottom:12.0pt">Best Regards,<br clear="all"><br>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX<br><br>Esteban Aliverti<br>
- Developer @ <a href="http://www.plugtree.com" rel="nofollow" link="external" target="_blank">http://www.plugtree.com </a><br>- Blog @ <a href="http://ilesteban.wordpress.com" rel="nofollow" link="external" target="_blank">http://ilesteban.wordpress.com</a><br>
<br></p></div><div><div><div></div><div class="h5"><p class="MsoNormal">On Tue, Mar 1, 2011 at 7:53 AM, odelyaholiday <<a href="http://user/SendEmail.jtp?type=node&node=2602731&i=0&by-user=t" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:</p>
</div></div><p class="MsoNormal"></p><div><div></div><div class="h5">Hi!<br><br>I am working already for 3 days, trying to configure bitronix with spring<br>and drools.<br><br>I defined<br><br>1. persistence unit:<br><br>
<persistence-unit name="org.drools.persistence.jpa" transaction-type="JTA"><br> <provider>org.hibernate.ejb.HibernatePersistence</provider><br> <jta-data-source>jdbc/DS1</jta-data-source><br>
<class>org.drools.persistence.info.SessionInfo</class><br><br><class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class><br> <class>org.drools.persistence.info.WorkItemInfo</class><br>
<exclude-unlisted-classes>true</exclude-unlisted-classes><br> <properties><br> <property name="hibernate.dialect"<br>value="org.hibernate.dialect.Oracle10gDialect" /><br>
<property name="hibernate.connection.autocommit" value="false" /><br> <property name="hibernate.max_fetch_depth" value="3" /><br>
<property name="hibernate.show_sql" value="true" /><br> <property name="hibernate.current_session_context_class" value="jta" /><br>
<property name="hibernate.connection.driver_class"<br>value="oracle.jdbc.xa.client.OracleXADataSource" /><br> <property name="hibernate.jndi.class"<br>
value="bitronix.tm.jndi.BitronixInitialContextFactory"/><br> <property name="hibernate.transaction.manager_lookup_class"<br>value="org.hibernate.transaction.BTMTransactionManagerLookup" /><br>
</properties><br> </persistence-unit><br><br>2. in my application context:<br><!-- Bitronix Transaction Manager embedded configuration --><br> <bean id="oracleDataSource"<br>
class="bitronix.tm.resource.jdbc.PoolingDataSource"<br> init-method="init" destroy-method="close"><br> <property name="className"<br>value="oracle.jdbc.xa.client.OracleXADataSource" /><br>
<property name="uniqueName" value="jdbc/DS1" /><br> <property name="maxPoolSize" value="5" /><br> <property name="allowLocalTransactions" value="true" /><br>
<property name="testQuery" value="SELECT 1 FROM DUAL" /><br> <property name="driverProperties"><br> <props><br> <prop key="user">myuser</prop><br>
<prop key="password">myuser</prop><br> <prop key="URL">myurl</prop><br> </props><br> </property><br>
</bean><br><br><br> <bean id="btmConfig" factory-method="getConfiguration"<br> class="bitronix.tm.TransactionManagerServices"><br> <property name="serverId" value="spring-btm" /><br>
</bean><br><br><br> <bean id="BitronixTransactionManager"<br>factory-method="getTransactionManager"<br> class="bitronix.tm.TransactionManagerServices" depends-on="btmConfig"<br>
destroy-method="shutdown" /><br><br><br> <bean id="JtaTransactionManager"<br> class="org.springframework.transaction.jta.JtaTransactionManager"><br>
<property name="transactionManager" ref="BitronixTransactionManager" /><br> <property name="userTransaction" ref="BitronixTransactionManager" /><br>
</bean><br> <!-- end of Bitronix Transaction Manager embedded configuration --><br><br>3. and in the code:<br>EntityManagerFactory emf =<br>Persistence.createEntityManagerFactory("org.drools.persistence.jpa");<br>
Environment env = KnowledgeBaseFactory.newEnvironment();<br> env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);<br> env.set(EnvironmentName.GLOBALS, new MapGlobalResolver());<br>
env.set(EnvironmentName.TRANSACTION_MANAGER,<br>TransactionManagerServices.getTransactionManager());<br> ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null,<br>env);<br><br>
However in the last code I get:<br><br>Caused by: java.lang.IllegalStateException:<br>java.lang.reflect.InvocationTargetException<br> at<br>org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:130)<br>
at<br>org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:54)<br> at<br>org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:109)<br>
at<br>com.mycompany.util.BookWorkflowUtilities.createSession(BookWorkflowUtilities.java:83)<br> at com.mycompany.util.BookWorkflowService.init(BookWorkflowService.java:62)<br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
at<br>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br>
at<br>org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)<br> at<br>org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)<br>
at<br>org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)<br> ... 29 more<br>Caused by: java.lang.reflect.InvocationTargetException<br>
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br> at<br>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br> at<br>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br>
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br> at<br>org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommanService(KnowledgeStoreServiceImpl.java:116)<br> ... 40 more<br>
Caused by: java.lang.RuntimeException: Could not commit session or rollback<br> at<br>org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:133)<br> ... 45 more<br>Caused by: java.lang.RuntimeException: Unable to rollback transaction<br>
at<br>org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:184)<br> at<br>org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:131)<br>
... 45 more<br>Caused by: java.lang.NullPointerException<br> at<br>org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:181)<br></div></div><span style="color:#888888"><div><div>
</div><div class="h5"><br>--<br>View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Caused-by-java-lang-NullPointerException-at-org-drools-persistence-jta-JtaTransactionManager-rollbac-tp2602190p2602190.html?by-user=t&by-user=t" rel="nofollow" link="external" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Caused-by-java-lang-NullPointerException-at-org-drools-persistence-jta-JtaTransactionManager-rollbac-tp2602190p2602190.html</a><br>
Sent from the Drools - User mailing list archive at Nabble.com.<br>_______________________________________________<br>rules-users mailing list<br></div></div><a href="http://user/SendEmail.jtp?type=node&node=2602731&i=1&by-user=t" rel="nofollow" link="external" target="_blank">[hidden email]</a><div class="im">
<br><a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a></div></span><p></p></div><p class="MsoNormal"> </p>
</div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________ <br>rules-users mailing list <br><a href="http://user/SendEmail.jtp?type=node&node=2602731&i=2&by-user=t" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br>
</p><div class="im"><a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br><br></div><p></p><div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" noshade style="color:#CCCCCC" align="center"></div><div><div><p class="MsoNormal"><b><span style="font-size:9.0pt;color:#444444">If you reply to this email, your message will be added to the discussion below:</span></b></p>
</div><p class="MsoNormal"><span style="font-size:9.0pt;color:#444444"><a href="http://drools-java-rules-engine.46999.n3.nabble.com/Caused-by-java-lang-NullPointerException-at-org-drools-persistence-jta-JtaTransactionManager-rollbac-tp2602190p2602731.html?by-user=t" rel="nofollow" link="external" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Caused-by-java-lang-NullPointerException-at-org-drools-persistence-jta-JtaTransactionManager-rollbac-tp2602190p2602731.html</a> </span></p>
</div><div style="margin-top:4.8pt"><p class="MsoNormal"><span style="font-size:8.5pt;color:#666666">
<br></span></p><hr align="left" width="300">
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Caused-by-java-lang-NullPointerException-at-org-drools-persistence-jta-JtaTransactionManager-rollbac-tp2602190p2602869.html" target="_blank">RE: Caused by: java.lang.NullPointerException at org.drools.persistence.jta.JtaTransactionManager.rollback(JtaTransactionManager.java:181)</a><div class="im">
<br>
Sent from the <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Drools-User-f47000.html" target="_blank">Drools - User mailing list archive</a> at Nabble.com.<br></div><p></p></div></div><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>
<br></blockquote></div><br></div>