Bug 862306 - Update jbpm.esb/jbpm-ds.xml configuration for MSSQL databases.
Summary: Update jbpm.esb/jbpm-ds.xml configuration for MSSQL databases.
Keywords:
Status: VERIFIED
Alias: None
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Tooling
Version: 5.3.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER1
: 5.3.1
Assignee: Julian Coleman
QA Contact: Marek Baluch
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-10-02 15:10 UTC by Marek Baluch
Modified: 2018-03-29 21:49 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Release Note
Doc Text:
Issues arose from using jBPM with MS SQL Server 2005. When using these together, jBPM would experience deadlocks. This has been addressed through a revision of the mssql-ds.xml file. As a result, these deadlocks no longer occur.
Clone Of:
Environment:
Last Closed:
Type: Task
Embargoed:

Attachments (Terms of Use)

Description Marek Baluch 2012-10-02 15:10:57 UTC 
Description of problem:

Customers have been experiencing jBPM deadlocks. Please see https://bugzilla.redhat.com/show_bug.cgi?id=802756.

Suggested fix for that issue is the following configuration of the jBPM datasource.

- Add <new-connection-sql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT;</new-connection-sql> to jbpm.esb/jbpm-ds.xml

<datasources>
    <local-tx-datasource>
        <jndi-name>JbpmDS</jndi-name>
        <connection-url>jdbc:sqlserver://xxxx.redhat.com:1433;DatabaseName=yourdatabase</connection-url>
        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
        <user-name>xxxx</user-name>
        <password>xxxx</password>
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <new-connection-sql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT;</new-connection-sql>
        <min-pool-size>15</min-pool-size>
        <max-pool-size>50</max-pool-size>
        <metadata>
            <type-mapping>MS SQLSERVER2000</type-mapping>
        </metadata>
    </local-tx-datasource>
</datasources>
Comment 1 Julian Coleman 2012-10-30 16:42:38 UTC 
Resolved with revision 11565 of:
  soa-p/src/main/resources/soa-p/schema-tool/mssql2008/template/mssql-ds.xml

Commit message:
  BZ-862306
  Add "SET TRANSACTION ISOLATION LEVEL SNAPSHOT" to fix jBPM deadlocks on
  SQL Server.
Comment 2 Marek Baluch 2012-11-19 08:43:27 UTC 
Verified on 5.3.1.ER1.
Note You need to log in before you can comment on or make changes to this bug.