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

[Sash K]

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
[http://community.jboss.org/message/560451#560451]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

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