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

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

  User: dsundstrom
  Date: 02/08/29 20:52:25

  Modified:    src/etc/conf/default standardjbosscmp-jdbc.xml
  Log:
  Fixed bug [ 597047 ] MySQL constraint template lacks index.
  Fixed bug [ 567645 ] Informix row-locking-template is not set.
  
  Revision  Changes    Path
  1.41      +3 -3      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.40
  retrieving revision 1.41
  diff -u -r1.40 -r1.41
  --- standardjbosscmp-jdbc.xml	11 Aug 2002 04:02:50 -0000	1.40
  +++ standardjbosscmp-jdbc.xml	30 Aug 2002 03:52:24 -0000	1.41
  @@ -7,7 +7,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.40 2002/08/11 04:02:50 d_jencks Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.41 2002/08/30 03:52:24 dsundstrom Exp $ -->
   
   <jbosscmp-jdbc>
      
  @@ -1244,7 +1244,7 @@
            <name>mySQL</name>
            <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 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>
  +         <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
            <alias-header-prefix>t</alias-header-prefix>
            <alias-header-suffix>_</alias-header-suffix>
            <alias-max-length>32</alias-max-length>
  @@ -1866,7 +1866,7 @@
         
         <type-mapping> 
            <name>InformixDB</name> 
  -         <row-locking-template/>
  +         <row-locking-template>select ?1 from ?2 where ?3 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>