Drools Persistence JPA module must use JTA instead of local transaction.<br><br><persistence-unit name="org.drools.persistence.jpa" transaction-type="RESOURCE_LOCAL"><br><br>should change to <br><br>
<persistence-unit name="default" transaction-type="JTA"><br><br>and<br><br>env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );<br><br>your transaction manager should be get from JNDI like <br>
<br>UserTransaction utx = (UserTransaction) ctx.lookup("java:comp/UserTransaction");<br><br>Your JBoss transaction manager component should register the UserTransaction into that JNDO name. (In some JTA implementations the UserTransaction and TransactionManager have the same interfaces). And to make Drools Persistence JPA works, you should put 4 or 5 objects into env, they are: <br>
<br>env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, this.defaultPersistenceSvc.getSessionFactory());<br>env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER, this.defaultPersistenceSvc.getCurrentSession()); // If you don't handle the EntityManager your self, you can omit this line.<br>
env.set(EnvironmentName.TRANSACTION_MANAGER, this.txSvc.getTransactionManager()); // java:comp/env/TransactionManager<br>env.set(EnvironmentName.TRANSACTION, this.txSvc.getTransaction()); // java:comp/UserTransaction<br>
env.set(EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY, this.txSvc.getTransactionSynchronizationRegistry()); // java:comp/env/TransactionSynchronizationRegistry<br>
<br>all the methods called from txSvc fetch objects from according JNDI. In my application all these JNDI objects are config-ed via Tomcat like this (in META-INF/context.xml):<br><br> <Resource name="jdbc/defaultDS" auth="Container" type="javax.sql.XADataSource"<br>
factory="bitronix.tm.resource.ResourceObjectFactory"<br> uniqueName="jdbc/defaultDS" /><br><br> <Resource name="jdbc/droolsTaskDS" auth="Container" type="javax.sql.XADataSource"<br>
factory="bitronix.tm.resource.ResourceObjectFactory"<br> uniqueName="jdbc/droolsTaskDS" /><br> <br> <Resource name="TransactionManager" auth="Container"<br>
type="javax.transaction.TransactionManager"<br> factory="bitronix.tm.BitronixTransactionManagerObjectFactory" /><br> <br> <Resource name="TransactionSynchronizationRegistry" auth="Container"<br>
type="javax.transaction.TransactionSynchronizationRegistry"<br> factory="bitronix.tm.BitronixTransactionSynchronizationRegistryObjectFactory" /><br><br> <Resource name="UserTransaction" auth="Container"<br>
type="javax.transaction.UserTransaction" /><br> <Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory" /><br><br><div class="gmail_quote">On Thu, May 12, 2011 at 11:25 PM, loumimi <span dir="ltr"><<a href="mailto:moundir.jamal-ext@sgcib.com">moundir.jamal-ext@sgcib.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello Ram,<br>
<br>
I'm running a simple J2SE application (a hello world), I'm trying to persist<br>
a simple drools workflow into Oracle DB.<br>
Here's my configuration :<br>
Oracle 10.2.0.4.0<br>
drools-decisiontables-5.0.1.jar<br>
hibernate-core-3.3.0.SP1.jar<br>
...<br>
<br>
persistence.xml :<br>
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><br>
<br>
<persistence<br>
version="1.0"<br>
xsi:schemaLocation=<br>
"<a href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a><br>
<a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a><br>
<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a><br>
<a href="http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/orm_1_0.xsd</a>"<br>
xmlns:orm="<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a>"<br>
xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"<br>
xmlns="<a href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a>"><br>
<br>
<br>
<persistence-unit name="org.drools.persistence.jpa"<br>
<div class="im">transaction-type="RESOURCE_LOCAL"><br>
<provider>org.hibernate.ejb.HibernatePersistence</provider><br>
</div> <class>org.drools.persistence.session.SessionInfo</class><br>
<br>
<class>org.drools.persistence.processinstance.ProcessInstanceInfo</class><br>
<br>
<class>org.drools.persistence.processinstance.ProcessInstanceEventInfo</class><br>
<class>org.drools.persistence.processinstance.WorkItemInfo</class><br>
<div class="im"><br>
<properties><br>
<property name="hibernate.dialect"<br>
</div><div class="im">value="org.hibernate.dialect.Oracle10gDialect"/><br>
<property name="hibernate.connection.driver_class"<br>
value="oracle.jdbc.OracleDriver"/><br>
<property name="hibernate.connection.url"<br>
</div>value="jdbc:oracle:thin:@gfxdevdb01.fr.world.xxxx:1567:CCOD02"/><br>
<property name="hibernate.connection.username" value="xxxx"/><br>
<property name="hibernate.connection.password" value="xxxx"/><br>
<property name="hibernate.connection.autocommit" value="true" /><br>
<div class="im"> <property name="hibernate.max_fetch_depth" value="3"/><br>
</div> <property name="hibernate.hbm2ddl.auto" value="update" /><br>
<div class="im"> <property name="hibernate.show_sql" value="true" /><br>
</div><div class="im"> <property name="hibernate.transaction.manager_lookup_class"<br>
value="org.hibernate.transaction.JBossTransactionManagerLookup" /><br>
</div> </properties><br>
</persistence-unit><br>
</persistence><br>
<br>
<br>
----<br>
orm.xml :<br>
<?xml version="1.0" encoding="UTF-8"?><br>
<entity-mappings xmlns="<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a>"<br>
xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"<br>
<br>
xsi:schemaLocation="<a href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a> orm_1_0.xsd"<br>
version="1.0"><br>
<named-query name="ProcessInstancesWaitingForEvent"><br>
<query><br>
select<br>
processInstanceInfo.processInstanceId<br>
from<br>
ProcessInstanceInfo processInstanceInfo<br>
where<br>
:type in elements(processInstanceInfo.eventTypes)<br>
</query><br>
</named-query><br>
</entity-mappings><br>
<br>
<br>
---<br>
the code :<br>
public static final void main(String[] args) {<br>
try {<br>
<br>
KnowledgeBuilder kbuilder =<br>
KnowledgeBuilderFactory.newKnowledgeBuilder();<br>
kbuilder.add(ResourceFactory.newClassPathResource("ruleflow.rf"),<br>
ResourceType.DRF);<br>
KnowledgeBuilderErrors errors = kbuilder.getErrors();<br>
if (errors.size() > 0) {<br>
for (KnowledgeBuilderError error: errors) {<br>
System.err.println(error);<br>
}<br>
throw new IllegalArgumentException("Could not parse<br>
knowledge.");<br>
}<br>
KnowledgeBase kbase = KnowledgeBaseFactory.newKnowledgeBase();<br>
kbase.addKnowledgePackages(kbuilder.getKnowledgePackages());<br>
<br>
// create the entity manager factory and register it in the<br>
environment<br>
<div class="im"> EntityManagerFactory emf = Persistence.createEntityManagerFactory(<br>
"org.drools.persistence.jpa" );<br>
Environment env = KnowledgeBaseFactory.newEnvironment();<br>
env.set( EnvironmentName.ENTITY_MANAGER_FACTORY, emf );<br>
</div> // env.set( EnvironmentName.TRANSACTION_MANAGER, XXXXXXXXXXX );<br>
// create a new knowledge session that uses JPA to store the runtime<br>
state<br>
<div class="im"> StatefulKnowledgeSession ksession =<br>
JPAKnowledgeService.newStatefulKnowledgeSession( kbase, null, env );<br>
<br>
</div> // invoke methods on your method here<br>
<div class="im"> ksession.startProcess( "com.sample.ruleflow" );<br>
ksession.fireAllRules();<br>
ksession.dispose();<br>
<br>
</div> } catch (Throwable t) {<br>
t.printStackTrace();<br>
}<br>
}<br>
<br>
<br>
I don't know If I miss something<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p2932251.html" target="_blank">http://drools.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p2932251.html</a><br>
</font><div><div></div><div class="h5">Sent from the Drools: User forum mailing list archive at Nabble.com.<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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>唐睿 研发部<br>深圳市中昱达信息技术有限责任公司<br>电话：0755-26966586-804<br>传真：0755-26966586-802<br>手机：86-18688827156<br>网址：<a href="http://www.zyeeda.com/" target="_blank">www.zyeeda.com</a><br>
地址：深圳市罗湖区金塘街48号蔡屋围丽晶大厦南座1206（518010）<br><br>本邮件（包括任何附件）含有专供明确的个人和目的使用的机密信息，并受法律保护。如果您并非指定收件人，请立即删除此邮件及其附件（如有），并勿使用、披露、复制或分发此邮件或据此采取任何行动。<br><br>Copyright
© 2011 ZYEEDA CO., LTD. ALL RIGHTS RESERVED 中昱达公司 版权所有<br>