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

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

  User: dsundstrom
  Date: 03/06/08 12:01:45

  Modified:    src/etc/conf/default 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
  1.58      +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.57
  retrieving revision 1.58
  diff -u -r1.57 -r1.58
  --- standardjbosscmp-jdbc.xml	8 Jun 2003 02:07:11 -0000	1.57
  +++ standardjbosscmp-jdbc.xml	8 Jun 2003 19:01:45 -0000	1.58
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.57 2003/06/08 02:07:11 dsundstrom Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.58 2003/06/08 19:01:45 dsundstrom Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -1492,7 +1492,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>