Re: [rules-dev] Drools Flow Persistence

I am using bitronix but configuring it with spring. At the moment I am getting this when I start more than one ProcessInstance: Caused by: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource What is the recommended way to have multiple long running process executing the workflow at the same time? (I cant find any documentation on this...) Is doing this even supported with Drools Persistence? From: rules-dev-bounces(a)lists.jboss.org [mailto:rules-dev-bounces@lists.jboss.org] On Behalf Of Mauricio Salatino Sent: 25 August 2010 15:45 To: Rules Dev List Subject: Re: [rules-dev] Drools Flow Persistence Are you using bitronix as the docs mention? Can you share the stack trace of the error? Cheers On Wed, Aug 25, 2010 at 11:40 AM, Chrystall, Greg <GChrystall@nds.com<mailto:GChrystall@nds.com>> wrote: Hello, I have a workflow project up and running using Drools Persistence. My workflows will have a number of "long running processes" which I will implement with WorkItemHandlers. I have created a dummy WorkItemHandler that just sleeps for a number of seconds before calling manager.completeWorkItem(workItem.getId(), null); My problem is that in a unit test I am creating a StatefulKnowledgeSession in one thread then calling start process on it in other threads to start multiple processes. I take it this is not supported because it tries to do persistence things without a transaction. How should I be doing this? Also how can I get my long running process to execute outside of a database transaction? Thanks, Greg ________________________________ ************************************************************************************** This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster@nds.com<mailto:postmaster@nds.com> and delete it from your system as well as any copies. The content of e-mails as well as traffic data may be monitored by NDS for employment and security purposes. To protect the environment please do not print this e-mail unless necessary. NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00 ************************************************************************************** _______________________________________________ rules-dev mailing list rules-dev@lists.jboss.org<mailto:rules-dev@lists.jboss.org> https://lists.jboss.org/mailman/listinfo/rules-dev -- - CTO @ http://www.plugtree.com - MyJourney @ http://salaboy.wordpress.com - Co-Founder @ http://www.jbug.com.ar - Salatino "Salaboy" Mauricio - ________________________________ ************************************************************************************** This message is confidential and intended only for the addressee. If you have received this message in error, please immediately notify the postmaster(a)nds.com and delete it from your system as well as any copies. The content of e-mails as well as traffic data may be monitored by NDS for employment and security purposes. To protect the environment please do not print this e-mail unless necessary. NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603 8808 40-00 **************************************************************************************