We are using Drools persistence with a StatefulKnowledgeSession. The persistence itself works fine, but I am encountering an IllegalStateException when disposing of the StatefulKnowledgeSession. This happens with either a brand new session
with no facts or one that has had facts added to it. It also happens with sessions that have been restored from the persistent store. The code does no explicit transaction management and relies on Drools to do this under the covers. We are using Drools
5.5.0 Final. How do I dispose of a session correctly?
The
documentation includes Example 3.66, “Configuring JTA DataSource.” My code does not include code like this anywhere. Do I need it? It’s not clear from the example where the PoolingDataSource instance would be used or when this code should be called.
If this configuration is required, can it be done via Spring instead of programmatically?
I’ll provide some supporting information below. I’ve edited these excerpts to redact some private details and eliminate distracting code, but the substance is intact.
Here is the stack trace created by invoking the “dispose” method from a shutdown hook:
java.lang.IllegalStateException: No value for key [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean@732e3e73] bound to thread [Thread-3]
at org.springframework.transaction.support.TransactionSynchronizationManager.unbindResource(TransactionSynchronizationManager.java:209)
at org.drools.container.spring.beans.persistence.DroolsSpringJpaManager.dispose(DroolsSpringJpaManager.java:135)
at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:345)
at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.dispose(CommandBasedStatefulKnowledgeSession.java:241)
at MyClass1.stop
at MyClass2$1.run
at java.lang.Thread.run(Unknown Source)
The code uses Drools-Spring to configure the knowledge base and Java code to initialize the knowledge session. We’re using JPA, the Bitronix transaction manager, and the H2 database, basically as described in the
documentation. Here is the code for creating the session:
ApplicationContext context =
new ClassPathXmlApplicationContext(APPLICATION_CONTEXT_XML);
KnowledgeStoreService kstore = (KnowledgeStoreService) context.getBean("myAppKnowledgeStore");
KnowledgeBase kbase = ...;
// initialized by Spring configuration
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY,
context.getBean("entityManagerFactory"));
env.set(EnvironmentName.TRANSACTION_MANAGER,
context.getBean("txManager"));
StatefulKnowledgeSession ksession = kstore.newStatefulKnowledgeSession(kbase,
null, env);
Here is the relevant portion of the Spring ApplicationContext.xml file:
<bean
id="dataSourceH2"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property
name="driverClassName"
value="org.h2.Driver"
/>
<property
name="url"
value="jdbc:h2:tcp://localhost/~/myApp"
/>
<property
name="username"
value="sa"
/>
<property
name="password"
value=""
/>
</bean>
<bean
id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property
name="dataSource"
ref="dataSourceH2"
/>
<property
name="persistenceUnitName"
value="myAppH2"
/>
</bean>
<bean
id="txManager"
class="org.springframework.orm.jpa.JpaTransactionManager">
<property
name="entityManagerFactory"
ref="entityManagerFactory"
/>
</bean>
<drools:grid-node
id="myAppEngineNode"
/>
<drools:kstore
id="myAppKnowledgeStore"
/>
<drools:kbase
id="myAppEngineKBase"
node="MyAppEngineNode">
<drools:configuration>
<drools:assert-behavior
mode="EQUALITY"
/>
</drools:configuration>
<drools:resources>
<drools:resource
type="DRL"
source="classpath:MyAppInternalRules.drl"
/>
<drools:resource
type="DTABLE"
source="classpath:MyAppRules.xls"
>
<drools:decisiontable-conf
input-type="XLS"
worksheet-name="Sheet 1"
/>
</drools:resource>
<drools:resource
type="DTABLE"
source="classpath:MyAppRules.xls"
>
<drools:decisiontable-conf
input-type="XLS"
worksheet-name="Sheet 2"
/>
</drools:resource>
</drools:resources>
</drools:kbase>
Here is the relevant part of the persistence.xml file:
<persistence-unit
name="myAppH2">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.drools.persistence.info.SessionInfo</class>
<properties>
<property
name="hibernate.dialect"
value="org.hibernate.dialect.H2Dialect"
/>
<property
name="hibernate.max_fetch_depth"
value="3"
/>
<property
name="hibernate.hbm2ddl.auto"
value="UPDATE"
/>
<property
name="hibernate.show_sql"
value="true"
/>
<property
name="hibernate.connection.autocommit"
value="true"
/>
<property
name="hibernate.transaction.manager_lookup_class"
value= "org.hibernate.transaction.BTMTransactionManagerLookup"/>
</properties>
</persistence-unit>
I have a jndi.properties that’s identical to what’s in the
documentation.
I noticed in the documentation (Example 3.65, Configuring JPA) that the persistence-unit block is defined a bit differently. In particular, transaction-type is specified and a jta-data-source are defined, unlike in my file:
<persistence-unit
name="org.drools.persistence.jpa"
transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/BitronixJTADataSource</jta-data-source>
...
</persistence-unit>
I tried defining these as shown, but then the code failed on startup when it tried to create a transaction:
org.drools.container.spring.beans.persistence.DroolsSpringTransactionManager: Unable to begin transaction
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is java.lang.IllegalStateException: A JTA EntityManager
cannot use getTransaction()
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:427)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.drools.container.spring.beans.persistence.DroolsSpringTransactionManager.begin(DroolsSpringTransactionManager.java:48)
at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:190)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommandService(KnowledgeStoreServiceImpl.java:100)
at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.loadStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:83)
at MyClass1.initializeKnowledgeSession
at MyClass1.initializeKnowledgeEngine
at MyClass2.main
Caused by: java.lang.IllegalStateException: A JTA EntityManager cannot use getTransaction()
at org.hibernate.ejb.AbstractEntityManagerImpl.getTransaction(AbstractEntityManagerImpl.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
at com.sun.proxy.$Proxy16.getTransaction(Unknown Source)
at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
... 12 more
Thanks,
Tom