Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Dain S. <dsu...@us...> - 2003-06-08 01:58:37
|
User: dsundstrom
Date: 03/06/07 18:58:35
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Changed SQLServer 2000 rowlock template to use xlock instead of rowlock.
According to the SQL Server docs a rowlock only tells the lock manager to
use a rowlock instead of more corse grained page or table locks. This
does not result in an exclusive lock, just a normal shared lock. The
xlock flag results in a real exclusive lock, which is what we really
wanted.
Revision Changes Path
No revision
No revision
1.39.2.20 +2 -2 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.19
retrieving revision 1.39.2.20
diff -u -r1.39.2.19 -r1.39.2.20
--- standardjbosscmp-jdbc.xml 23 May 2003 15:32:23 -0000 1.39.2.19
+++ standardjbosscmp-jdbc.xml 8 Jun 2003 01:58:35 -0000 1.39.2.20
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.19 2003/05/23 15:32:23 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.20 2003/06/08 01:58:35 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1622,7 +1622,7 @@
<type-mapping>
<name>MS SQLSERVER2000</name>
- <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
+ <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
|
