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

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

  User: dsundstrom
  Date: 03/06/08 12:04:05

  Modified:    src/etc/conf/default Tag: Branch_3_0
                        standardjbosscmp-jdbc.xml
  Log:
  Changed SQL Server 7 rowlock to updlock.  The updlock flag is simmilar to
  oracle for update, in that it is not an exclusive lock, but works as long
  as all readers use updlock.
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.23.2.28 +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.23.2.27
  retrieving revision 1.23.2.28
  diff -u -r1.23.2.27 -r1.23.2.28
  --- standardjbosscmp-jdbc.xml	8 Jun 2003 02:02:03 -0000	1.23.2.27
  +++ standardjbosscmp-jdbc.xml	8 Jun 2003 19:04:05 -0000	1.23.2.28
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.27 2003/06/08 02:02:03 dsundstrom Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.28 2003/06/08 19:04:05 dsundstrom Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -1398,7 +1398,7 @@
   
         <type-mapping>
            <name>MS SQLSERVER</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 with (updlock) 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>