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: CLOSED UPSTREAM
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: 2025-02-10 03:20 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2025-02-10 03:20:53 UTC
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.
Comment 6 Red Hat Bugzilla 2025-02-10 03:20:53 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.
Note You need to log in before you can comment on or make changes to this bug.