[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

[Dain S. <dsu...@us...>]

  User: dsundstrom
  Date: 03/06/07 19:07:11

  Modified:    src/etc/conf/default 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
  1.57      +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.56
  retrieving revision 1.57
  diff -u -r1.56 -r1.57
  --- standardjbosscmp-jdbc.xml	19 Mar 2003 16:43:25 -0000	1.56
  +++ standardjbosscmp-jdbc.xml	8 Jun 2003 02:07:11 -0000	1.57
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.56 2003/03/19 16:43:25 mnewcomb Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.57 2003/06/08 02:07:11 dsundstrom Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -1618,7 +1618,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>
            <alias-header-prefix>t</alias-header-prefix>