[rules-dev] Drools Flow Persistence

[Chrystall, Greg]

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 at lists.jboss.org [mailto:rules-dev-bounces at 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 at nds.com<mailto:GChrystall at 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 at nds.com<mailto:postmaster at 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 at lists.jboss.org<mailto:rules-dev at 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 at 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
**************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-dev/attachments/20100826/1524ec69/attachment.html