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

[Sash K]

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

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

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

--------------------------------------------------------------
Found a solution that works if you are using mssql 2005 and above. Can allow snapshot on mssql to make it behave more like oracle.  The following two statements should do the trick:
* ALTER DATABASE YOUR_DB_NAME SET ALLOW_SNAPSHOT_ISOLATION ON;
* ALTER DATABASE YOUR_DB_NAME SET READ_COMMITTED_SNAPSHOT ON;
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/567033#567033]

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/20101018/e5cef096/attachment-0001.html