Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Joachim V. d. A. <tri...@us...> - 2004-07-13 21:29:02
|
User: triathlon98
Date: 04/07/13 14:28:53
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fix for bug # 986420
The SQL query to be used when altering a table is now configurable in standardjbosscmp-jdbc.xml..
Revision Changes Path
No revision
No revision
1.39.2.50 +22 -17 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.49
retrieving revision 1.39.2.50
diff -u -r1.39.2.49 -r1.39.2.50
--- standardjbosscmp-jdbc.xml 12 Jul 2004 21:22:09 -0000 1.39.2.49
+++ standardjbosscmp-jdbc.xml 13 Jul 2004 21:28:53 -0000 1.39.2.50
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.49 2004/07/12 21:22:09 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.50 2004/07/13 21:28:53 triathlon98 Exp $ -->
<jbosscmp-jdbc>
@@ -175,7 +175,7 @@
<type-mapping>
<name>Ingres</name>
- <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 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>
@@ -188,35 +188,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>concat(?1,?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>left(?1,?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>locate(?1,?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
@@ -308,7 +308,8 @@
<sql-type>LONG VARCHAR</sql-type>
</mapping>
</type-mapping>
- <type-mapping>
+
+ <type-mapping>
<name>McKoi</name>
<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>
@@ -660,7 +661,7 @@
<sql-type>BLOB(2000)</sql-type>
</mapping>
</type-mapping>
-
+
<type-mapping>
<name>Oracle9i</name>
<!--
@@ -1083,7 +1084,7 @@
<function-mapping>
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>char_length(?1)</function-sql>
@@ -1424,6 +1425,8 @@
<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>
+ <add-column-template>ALTER TABLE ?1 ADD COLUMN ?2 ?3</add-column-template>
+ <drop-column-template>ALTER TABLE ?1 DROP COLUMN ?2</drop-column-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -1717,6 +1720,7 @@
<fk-constraint-template>ALTER TABLE ?1 ADD INDEX (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 auto_increment</auto-increment-template>
+ <alter-column-template>ALTER TABLE ?1 MODIFY ?2 ?3</alter-column-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -1856,6 +1860,7 @@
<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>
+ <alter-column-template>ALTER TABLE ?1 ALTER COLUMN ?2 ?3</alter-column-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
@@ -2672,11 +2677,11 @@
<!-- reserved words that should not be used as table names -->
<!-- JBoss will escape them by prepending a 'X' -->
<reserved-words>
- <word>alias</word>
+ <word>alias</word>
<word>alter</word>
<word>between</word>
- <word>char</word>
- <word>column</word>
+ <word>char</word>
+ <word>column</word>
<word>commit</word>
<word>create</word>
<word>date</word>
@@ -2701,7 +2706,7 @@
<word>select</word>
<word>set</word>
<word>session</word>
- <word>size</word>
+ <word>size</word>
<word>table</word>
<word>trigger</word>
<word>update</word>
|
