From: Dain S. <dsu...@us...> - 2002-08-30 04:41:37
|
User: dsundstrom Date: 02/08/29 21:41:36 Modified: src/etc/conf/default Tag: Branch_3_0 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 No revision No revision 1.23.2.16 +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.23.2.15 retrieving revision 1.23.2.16 diff -u -r1.23.2.15 -r1.23.2.16 --- standardjbosscmp-jdbc.xml 14 Jul 2002 20:01:35 -0000 1.23.2.15 +++ standardjbosscmp-jdbc.xml 30 Aug 2002 04:41:36 -0000 1.23.2.16 @@ -1161,7 +1161,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> @@ -1783,7 +1783,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> |