|
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>
|