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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

  User: loubyansky
  Date: 03/12/12 10:57:15

  Modified:    src/etc/conf/default Tag: Branch_3_2
                        standardjbosscmp-jdbc.xml
  Log:
  updated row-locking-template's with ORDER BY parameter
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.39.2.36 +15 -15    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.35
  retrieving revision 1.39.2.36
  diff -u -r1.39.2.35 -r1.39.2.36
  --- standardjbosscmp-jdbc.xml	8 Dec 2003 16:32:18 -0000	1.39.2.35
  +++ standardjbosscmp-jdbc.xml	12 Dec 2003 18:57:15 -0000	1.39.2.36
  @@ -9,7 +9,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.35 2003/12/08 16:32:18 pilhuhn Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.36 2003/12/12 18:57:15 loubyansky Exp $ -->
   
   <jbosscmp-jdbc>
   
  @@ -174,7 +174,7 @@
   
         <type-mapping>
            <name>Ingres</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>    
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>    
            <pk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 PRIMARY KEY (?3)</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>
  @@ -309,7 +309,7 @@
         </type-mapping>
        <type-mapping>
         <name>McKoi</name>
  -      <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +      <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -396,7 +396,7 @@
            <!-- For use with the Firebirdsql jca-jdbc driver.
                 A version after Beta 1 is strongly recommended,
                 this may involve building from cvs -->
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -481,7 +481,7 @@
   
         <type-mapping>
            <name>InterBase</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -656,7 +656,7 @@
            | Make sure that you have the Oracle 9i version of classes12.jar
            | or you will suffer
            -->
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -786,7 +786,7 @@
   
         <type-mapping>
            <name>Oracle8</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -924,7 +924,7 @@
   
         <type-mapping>
            <name>Oracle7</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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>
  @@ -1149,7 +1149,7 @@
   
         <type-mapping>
            <name>PostgreSQL</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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</auto-increment-template>
  @@ -1276,7 +1276,7 @@
   
         <type-mapping>
            <name>PostgreSQL 7.2</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</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</auto-increment-template>
  @@ -1687,7 +1687,7 @@
   
         <type-mapping>
            <name>mySQL</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
            <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
            <!-- does not work for compound keys <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template> -->
            <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
  @@ -1827,7 +1827,7 @@
   
         <type-mapping>
            <name>MS SQLSERVER</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 with (updlock) WHERE ?3 ORDER BY ?4</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>
  @@ -1958,7 +1958,7 @@
   
         <type-mapping>
            <name>MS SQLSERVER2000</name>
  -         <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 with (xlock) WHERE ?3 ORDER BY ?4</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>
  @@ -2191,7 +2191,7 @@
            <name>SapDB</name>
            <!-- SapDB 7.3 might require '... UPDATE OF ?1' in the row-locking-template -->
            <!-- as is works with SapDB 7.4 -->
  -         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
  +         <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
            <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
            <fk-constraint-template>ALTER TABLE ?1 ADD FOREIGN KEY ?2 (?3) REFERENCES ?4 (?5)</fk-constraint-template>
            <alias-header-prefix>t</alias-header-prefix>
  @@ -2371,7 +2371,7 @@
   
         <type-mapping>
            <name>InformixDB</name>
  -         <row-locking-template>select ?1 from ?2 where ?3 for update</row-locking-template>
  +         <row-locking-template>select ?1 from ?2 where ?3 order by ?4 for update</row-locking-template>
            <pk-constraint-template>PRIMARY KEY (?2) CONSTRAINT ?1</pk-constraint-template>
            <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT FOREIGN KEY (?3) REFERENCES ?4 (?5) CONSTRAINT ?2</fk-constraint-template>
            <alias-header-prefix>t</alias-header-prefix>