[jboss-user] [jBPM] - JBPM 3.2.5, MSSQL 2005 - blocking in JBPM_JOB table

Sash K do-not-reply at jboss.com
Thu Sep 9 07:01:47 EDT 2010

Sash K [http://community.jboss.org/people/swishey] created the discussion

"JBPM 3.2.5,MSSQL 2005 - blocking in JBPM_JOB table"

To view the discussion, visit: http://community.jboss.org/message/560451#560451

When running on MSSQL 2005 we are experiencing blocking issues in JBPM_JOB table which essentially stalls processing of jobs for extended period of time. Looks like exclusive lock is held on the job table.  Tried turning off lock escalation, but that had no affect.   The only thing that seems to work is setting transaction isolation level to TRANSACTION_READ_UNCOMMITTED.   Is it safe to to set transaction isolation level to READ_UNCOMMITTED?   Is there another, safer solution to this problem?     Thank you in advance for any insight you can offer!

Reply to this message by going to Community

Start a new discussion in jBPM at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100909/02178bc0/attachment.html 

More information about the jboss-user mailing list