Author: jeff.yuchang Date: 2012-08-19 10:04:52 -0400 (Sun, 19 Aug 2012) New Revision: 1589 Modified: branches/RiftSaw-2.3.x/distribution/src/main/release/conf/datasource/bpel-sqlserver-ds.xml Log: RIFTSAW-504: Set the transaction level for the sqlserver in order to remove the deadlock issue. Modified: branches/RiftSaw-2.3.x/distribution/src/main/release/conf/datasource/bpel-sqlserver-ds.xml =================================================================== --- branches/RiftSaw-2.3.x/distribution/src/main/release/conf/datasource/bpel-sqlserver-ds.xml 2012-08-13 04:37:52 UTC (rev 1588) +++ branches/RiftSaw-2.3.x/distribution/src/main/release/conf/datasource/bpel-sqlserver-ds.xml 2012-08-19 14:04:52 UTC (rev 1589) @@ -7,7 +7,9 @@ <driver-class>@driver@</driver-class> <user-name>@username@</user-name> <password>@password@</password> - + <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> + <new-connection-sql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT;</new-connection-sql> + <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>MS SQLSERVER2000</type-mapping>