Menu
▾
▴
jboss-cvs-commits
|
From: Alexey L. <lou...@us...> - 2004-02-05 14:40:39
|
User: loubyansky
Date: 04/02/05 06:38:04
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
fixed [ 891036 ] Sybase type-mapping alias-max-length too high
Revision Changes Path
No revision
No revision
1.39.2.39 +2 -2 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.38
retrieving revision 1.39.2.39
diff -u -r1.39.2.38 -r1.39.2.39
--- standardjbosscmp-jdbc.xml 12 Jan 2004 15:37:30 -0000 1.39.2.38
+++ standardjbosscmp-jdbc.xml 5 Feb 2004 14:38:03 -0000 1.39.2.39
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.38 2004/01/12 15:37:30 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.39 2004/02/05 14:38:03 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1076,7 +1076,7 @@
<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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-02-05 14:41:46
|
User: loubyansky
Date: 04/02/05 06:39:09
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
fixed [ 891036 ] Sybase type-mapping alias-max-length too high
Revision Changes Path
1.71 +2 -2 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.70
retrieving revision 1.71
diff -u -r1.70 -r1.71
--- standardjbosscmp-jdbc.xml 12 Jan 2004 15:42:41 -0000 1.70
+++ standardjbosscmp-jdbc.xml 5 Feb 2004 14:39:09 -0000 1.71
@@ -1076,7 +1076,7 @@
<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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
|
|
From: Scott M S. <st...@us...> - 2004-02-06 01:42:22
|
User: starksm
Date: 04/02/05 17:39:46
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Update the pk-constraint-template and fk-constraint-template for FirstSQL/J
Revision Changes Path
No revision
No revision
1.39.2.40 +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.39.2.39
retrieving revision 1.39.2.40
diff -u -r1.39.2.39 -r1.39.2.40
--- standardjbosscmp-jdbc.xml 5 Feb 2004 14:38:03 -0000 1.39.2.39
+++ standardjbosscmp-jdbc.xml 6 Feb 2004 01:39:45 -0000 1.39.2.40
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.39 2004/02/05 14:38:03 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.40 2004/02/06 01:39:45 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -47,8 +47,8 @@
<type-mapping>
<name>FirstSQL/J</name>
<row-locking-template/>
- <pk-constraint-template>PRIMARY KEY (?1)</pk-constraint-template>
- <fk-constraint-template>FOREIGN KEY (?1) REFERENCES ?2 (?3)</fk-constraint-template>
+ <pk-constraint-template>PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>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>
|
|
From: Scott M S. <st...@us...> - 2004-02-06 01:42:38
|
User: starksm
Date: 04/02/05 17:40:03
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Update the pk-constraint-template and fk-constraint-template for FirstSQL/J
Revision Changes Path
1.72 +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.71
retrieving revision 1.72
diff -u -r1.71 -r1.72
--- standardjbosscmp-jdbc.xml 5 Feb 2004 14:39:09 -0000 1.71
+++ standardjbosscmp-jdbc.xml 6 Feb 2004 01:40:02 -0000 1.72
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.71 2004/02/05 14:39:09 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.72 2004/02/06 01:40:02 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -46,8 +46,8 @@
<type-mapping>
<name>FirstSQL/J</name>
<row-locking-template/>
- <pk-constraint-template>PRIMARY KEY (?1)</pk-constraint-template>
- <fk-constraint-template>FOREIGN KEY (?1) REFERENCES ?2 (?3)</fk-constraint-template>
+ <pk-constraint-template>PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>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>
|
|
From: Alexey L. <lou...@us...> - 2004-02-06 15:06:51
|
User: loubyansky
Date: 04/02/06 07:04:10
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
applied [ 891591 ] Sybase java.util.Date mapping missing
Revision Changes Path
No revision
No revision
1.39.2.41 +6 -1 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.40
retrieving revision 1.39.2.41
diff -u -r1.39.2.40 -r1.39.2.41
--- standardjbosscmp-jdbc.xml 6 Feb 2004 01:39:45 -0000 1.39.2.40
+++ standardjbosscmp-jdbc.xml 6 Feb 2004 15:04:09 -0000 1.39.2.41
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.40 2004/02/06 01:39:45 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.41 2004/02/06 15:04:09 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1139,6 +1139,11 @@
<sql-type>VARCHAR(255)</sql-type>
</mapping>
<mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATETIME</sql-type>
|
|
From: Alexey L. <lou...@us...> - 2004-02-06 15:08:41
|
User: loubyansky
Date: 04/02/06 07:06:00
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
applied [ 891591 ] Sybase java.util.Date mapping missing
Revision Changes Path
1.73 +6 -1 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.72
retrieving revision 1.73
diff -u -r1.72 -r1.73
--- standardjbosscmp-jdbc.xml 6 Feb 2004 01:40:02 -0000 1.72
+++ standardjbosscmp-jdbc.xml 6 Feb 2004 15:06:00 -0000 1.73
@@ -1139,6 +1139,11 @@
<sql-type>VARCHAR(255)</sql-type>
</mapping>
<mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATETIME</sql-type>
|
|
From: Joachim V. d. A. <tri...@us...> - 2004-03-23 17:03:37
|
User: triathlon98
Date: 04/03/23 08:53:10
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Firebird/interbase mapping improvements
- correct alias-max-length
- make sure alter-table inserts default values in new fields
Revision Changes Path
No revision
No revision
1.39.2.42 +17 -20 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.41
retrieving revision 1.39.2.42
diff -u -r1.39.2.41 -r1.39.2.42
--- standardjbosscmp-jdbc.xml 6 Feb 2004 15:04:09 -0000 1.39.2.41
+++ standardjbosscmp-jdbc.xml 23 Mar 2004 16:53:09 -0000 1.39.2.42
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.41 2004/02/06 15:04:09 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.42 2004/03/23 16:53:09 triathlon98 Exp $ -->
<jbosscmp-jdbc>
@@ -393,15 +393,12 @@
<type-mapping>
<name>Firebird</name>
- <!-- 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 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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -414,37 +411,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -486,7 +483,7 @@
<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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -499,37 +496,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
|
|
From: Joachim V. d. A. <tri...@us...> - 2004-03-23 17:08:34
|
User: triathlon98
Date: 04/03/23 08:58:08
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Firebird/interbase mapping improvements
- correct alias-max-length
- make sure alter-table inserts default values in new fields
Revision Changes Path
1.74 +31 -33 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.73
retrieving revision 1.74
diff -u -r1.73 -r1.74
--- standardjbosscmp-jdbc.xml 6 Feb 2004 15:06:00 -0000 1.73
+++ standardjbosscmp-jdbc.xml 23 Mar 2004 16:58:07 -0000 1.74
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.73 2004/02/06 15:06:00 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.74 2004/03/23 16:58:07 triathlon98 Exp $ -->
<jbosscmp-jdbc>
@@ -40,6 +40,7 @@
</unknown-pk>
<entity-command name="default"/>
+
</defaults>
<type-mappings>
@@ -173,7 +174,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>
@@ -186,35 +187,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>
@@ -392,15 +393,12 @@
<type-mapping>
<name>Firebird</name>
- <!-- 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 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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -413,37 +411,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -485,7 +483,7 @@
<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>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -498,37 +496,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -578,7 +576,6 @@
<function-name>count</function-name>
<function-sql>count(?1)</function-sql>
</function-mapping>
-
<function-mapping>
<function-name>locate</function-name>
<function-sql>locate(CAST(?1 as VARCHAR(254)),
@@ -660,7 +657,7 @@
<java-type>java.lang.Object</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>BLOB(2000)</sql-type>
- </mapping>
+ </mapping>
</type-mapping>
<type-mapping>
@@ -1084,7 +1081,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>
@@ -2386,6 +2383,7 @@
</mapping>
</type-mapping>
+
<type-mapping>
<name>InformixDB</name>
<row-locking-template>select ?1 from ?2 where ?3 order by ?4 for update</row-locking-template>
@@ -2690,7 +2688,7 @@
<word>number</word>
<word>integer</word>
<word>varchar</word>
- <word>char</word>
+ <word>char</word>
<word>user</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Alexey L. <lou...@us...> - 2004-03-25 22:05:22
|
User: loubyansky
Date: 04/03/25 13:54:33
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added java.util.Date mapping for PointBase.
Revision Changes Path
1.75 +6 -1 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.74
retrieving revision 1.75
diff -u -r1.74 -r1.75
--- standardjbosscmp-jdbc.xml 23 Mar 2004 16:58:07 -0000 1.74
+++ standardjbosscmp-jdbc.xml 25 Mar 2004 21:54:30 -0000 1.75
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.74 2004/03/23 16:58:07 triathlon98 Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.75 2004/03/25 21:54:30 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1619,6 +1619,11 @@
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-03-25 22:08:44
|
User: loubyansky
Date: 04/03/25 13:57:56
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added java.util.Date mapping for PointBase.
Revision Changes Path
No revision
No revision
1.39.2.43 +6 -1 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.42
retrieving revision 1.39.2.43
diff -u -r1.39.2.42 -r1.39.2.43
--- standardjbosscmp-jdbc.xml 23 Mar 2004 16:53:09 -0000 1.39.2.42
+++ standardjbosscmp-jdbc.xml 25 Mar 2004 21:57:56 -0000 1.39.2.43
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.42 2004/03/23 16:53:09 triathlon98 Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.43 2004/03/25 21:57:56 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1619,6 +1619,11 @@
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-04-05 12:20:26
|
User: loubyansky
Date: 04/04/05 05:07:50
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
set the default ql-compiler
Revision Changes Path
No revision
No revision
1.39.2.44 +2 -2 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.43
retrieving revision 1.39.2.44
diff -u -r1.39.2.43 -r1.39.2.44
--- standardjbosscmp-jdbc.xml 25 Mar 2004 21:57:56 -0000 1.39.2.43
+++ standardjbosscmp-jdbc.xml 5 Apr 2004 12:07:49 -0000 1.39.2.44
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.43 2004/03/25 21:57:56 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.44 2004/04/05 12:07:49 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -40,7 +40,7 @@
</unknown-pk>
<entity-command name="default"/>
-
+ <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler>
</defaults>
<type-mappings>
|
|
From: Alexey L. <lou...@us...> - 2004-04-05 12:56:34
|
User: loubyansky
Date: 04/04/05 05:43:58
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
set default ql-compiler
Revision Changes Path
1.76 +2 -2 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.75
retrieving revision 1.76
diff -u -r1.75 -r1.76
--- standardjbosscmp-jdbc.xml 25 Mar 2004 21:54:30 -0000 1.75
+++ standardjbosscmp-jdbc.xml 5 Apr 2004 12:43:57 -0000 1.76
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.75 2004/03/25 21:54:30 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.76 2004/04/05 12:43:57 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -40,7 +40,7 @@
</unknown-pk>
<entity-command name="default"/>
-
+ <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler>
</defaults>
<type-mappings>
|
|
From: Alexey L. <lou...@us...> - 2004-04-16 13:01:10
|
User: loubyansky
Date: 04/04/16 06:01:04
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
fixed the default java.lang.Short mapping for Oracle9i
Revision Changes Path
No revision
No revision
1.39.2.45 +3 -2 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.44
retrieving revision 1.39.2.45
diff -u -r1.39.2.44 -r1.39.2.45
--- standardjbosscmp-jdbc.xml 5 Apr 2004 12:07:49 -0000 1.39.2.44
+++ standardjbosscmp-jdbc.xml 16 Apr 2004 13:01:03 -0000 1.39.2.45
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.44 2004/04/05 12:07:49 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.45 2004/04/16 13:01:03 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -725,7 +725,8 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>SMALLINT</jdbc-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <!-- <jdbc-type>SMALLINT</jdbc-type> this resulted in a ClassCastException -->
<sql-type>NUMBER(5)</sql-type>
</mapping>
<mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-04-16 13:02:58
|
User: loubyansky
Date: 04/04/16 06:02:47
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
fixed the default java.lang.Short mapping for Oracle9i
Revision Changes Path
1.77 +3 -2 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.76
retrieving revision 1.77
diff -u -r1.76 -r1.77
--- standardjbosscmp-jdbc.xml 5 Apr 2004 12:43:57 -0000 1.76
+++ standardjbosscmp-jdbc.xml 16 Apr 2004 13:02:47 -0000 1.77
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.76 2004/04/05 12:43:57 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.77 2004/04/16 13:02:47 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -725,7 +725,8 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>SMALLINT</jdbc-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <!-- <jdbc-type>SMALLINT</jdbc-type> this resulted in a ClassCastException -->
<sql-type>NUMBER(5)</sql-type>
</mapping>
<mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-04-20 18:20:55
|
User: loubyansky
Date: 04/04/20 11:20:47
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added row-locking template for pointbase
Revision Changes Path
No revision
No revision
1.39.2.46 +2 -2 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.45
retrieving revision 1.39.2.46
diff -u -r1.39.2.45 -r1.39.2.46
--- standardjbosscmp-jdbc.xml 16 Apr 2004 13:01:03 -0000 1.39.2.45
+++ standardjbosscmp-jdbc.xml 20 Apr 2004 18:20:40 -0000 1.39.2.46
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.45 2004/04/16 13:01:03 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.46 2004/04/20 18:20:40 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1547,7 +1547,7 @@
<type-mapping>
<name>PointBase</name>
- <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>
|
|
From: Alexey L. <lou...@us...> - 2004-04-20 18:33:29
|
User: loubyansky
Date: 04/04/20 11:33:22
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added row-locking template for pointbase
Revision Changes Path
1.78 +2 -2 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.77
retrieving revision 1.78
diff -u -r1.77 -r1.78
--- standardjbosscmp-jdbc.xml 16 Apr 2004 13:02:47 -0000 1.77
+++ standardjbosscmp-jdbc.xml 20 Apr 2004 18:33:22 -0000 1.78
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.77 2004/04/16 13:02:47 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.78 2004/04/20 18:33:22 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1547,7 +1547,7 @@
<type-mapping>
<name>PointBase</name>
- <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>
|
|
From: Heiko W.R. <pi...@us...> - 2004-06-12 07:58:47
|
User: pilhuhn
Date: 04/06/12 00:58:41
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Add some more reserved words and sort the list.
Revision Changes Path
1.79 +30 -21 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.78
retrieving revision 1.79
diff -u -r1.78 -r1.79
--- standardjbosscmp-jdbc.xml 20 Apr 2004 18:33:22 -0000 1.78
+++ standardjbosscmp-jdbc.xml 12 Jun 2004 07:58:40 -0000 1.79
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.78 2004/04/20 18:33:22 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.79 2004/06/12 07:58:40 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2668,33 +2668,42 @@
<!-- reserved words that should not be used as table names -->
<!-- JBoss will escape them by prepending a 'X' -->
<reserved-words>
- <word>create</word>
- <word>table</word>
+ <word>alias</word>
<word>alter</word>
- <word>on</word>
- <word>column</word>
- <word>index</word>
- <word>set</word>
- <word>select</word>
- <word>update</word>
- <word>delete</word>
- <word>from</word>
- <word>view</word>
- <word>trigger</word>
+ <word>between</word>
+ <word>char</word>
+ <word>column</word>
<word>commit</word>
- <word>rollback</word>
+ <word>create</word>
+ <word>date</word>
+ <word>default</word>
+ <word>delete</word>
<word>drop</word>
+ <word>file</word>
+ <word>from</word>
<word>grant</word>
- <word>revoke</word>
<word>group</word>
- <word>between</word>
+ <word>index</word>
+ <word>integer</word>
<word>join</word>
- <word>unique</word>
- <word>primary</word>
<word>number</word>
- <word>integer</word>
- <word>varchar</word>
- <word>char</word>
+ <word>on</word>
+ <word>order</word>
+ <word>primary</word>
+ <word>public</word>
+ <word>revoke</word>
+ <word>rollback</word>
+ <word>row</word>
+ <word>select</word>
+ <word>set</word>
+ <word>session</word>
+ <word>size</word>
+ <word>table</word>
+ <word>trigger</word>
+ <word>update</word>
+ <word>unique</word>
<word>user</word>
+ <word>varchar</word>
+ <word>view</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Heiko W.R. <pi...@us...> - 2004-06-12 07:59:23
|
User: pilhuhn
Date: 04/06/12 00:59:17
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add some more reserved words and sort the list.
Revision Changes Path
No revision
No revision
1.39.2.47 +30 -21 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.46
retrieving revision 1.39.2.47
diff -u -r1.39.2.46 -r1.39.2.47
--- standardjbosscmp-jdbc.xml 20 Apr 2004 18:20:40 -0000 1.39.2.46
+++ standardjbosscmp-jdbc.xml 12 Jun 2004 07:59:16 -0000 1.39.2.47
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.46 2004/04/20 18:20:40 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.47 2004/06/12 07:59:16 pilhuhn Exp $ -->
<jbosscmp-jdbc>
@@ -2668,33 +2668,42 @@
<!-- reserved words that should not be used as table names -->
<!-- JBoss will escape them by prepending a 'X' -->
<reserved-words>
- <word>create</word>
- <word>table</word>
+ <word>alias</word>
<word>alter</word>
- <word>on</word>
- <word>column</word>
- <word>index</word>
- <word>set</word>
- <word>select</word>
- <word>update</word>
- <word>delete</word>
- <word>from</word>
- <word>view</word>
- <word>trigger</word>
+ <word>between</word>
+ <word>char</word>
+ <word>column</word>
<word>commit</word>
- <word>rollback</word>
+ <word>create</word>
+ <word>date</word>
+ <word>default</word>
+ <word>delete</word>
<word>drop</word>
+ <word>file</word>
+ <word>from</word>
<word>grant</word>
- <word>revoke</word>
<word>group</word>
- <word>between</word>
+ <word>index</word>
+ <word>integer</word>
<word>join</word>
- <word>unique</word>
- <word>primary</word>
<word>number</word>
- <word>integer</word>
- <word>varchar</word>
- <word>char</word>
+ <word>on</word>
+ <word>order</word>
+ <word>primary</word>
+ <word>public</word>
+ <word>revoke</word>
+ <word>rollback</word>
+ <word>row</word>
+ <word>select</word>
+ <word>set</word>
+ <word>session</word>
+ <word>size</word>
+ <word>table</word>
+ <word>trigger</word>
+ <word>update</word>
+ <word>unique</word>
<word>user</word>
+ <word>varchar</word>
+ <word>view</word>
</reserved-words>
</jbosscmp-jdbc>
|
|
From: Alexey L. <lou...@us...> - 2004-06-24 12:22:06
|
User: loubyansky
Date: 04/06/24 05:21:59
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added clean-read-ahead-on-load
Revision Changes Path
No revision
No revision
1.39.2.48 +2 -1 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.47
retrieving revision 1.39.2.48
diff -u -r1.39.2.47 -r1.39.2.48
--- standardjbosscmp-jdbc.xml 12 Jun 2004 07:59:16 -0000 1.39.2.47
+++ standardjbosscmp-jdbc.xml 24 Jun 2004 12:21:58 -0000 1.39.2.48
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.47 2004/06/12 07:59:16 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.48 2004/06/24 12:21:58 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -31,6 +31,7 @@
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
+ <clean-read-ahead-on-load>false</clean-read-ahead-on-load>
<unknown-pk>
<key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
|
|
From: Alexey L. <lou...@us...> - 2004-06-24 12:57:28
|
User: loubyansky
Date: 04/06/24 05:57:23
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added clean-read-ahead-on-load
Revision Changes Path
1.80 +2 -1 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.79
retrieving revision 1.80
diff -u -r1.79 -r1.80
--- standardjbosscmp-jdbc.xml 12 Jun 2004 07:58:40 -0000 1.79
+++ standardjbosscmp-jdbc.xml 24 Jun 2004 12:57:22 -0000 1.80
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.79 2004/06/12 07:58:40 pilhuhn Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.80 2004/06/24 12:57:22 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -31,6 +31,7 @@
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
+ <clean-read-ahead-on-load>false</clean-read-ahead-on-load>
<unknown-pk>
<key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
|
|
From: Alexey L. <lou...@us...> - 2004-07-12 21:22:16
|
User: loubyansky
Date: 04/07/12 14:22:10
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
fixed fk constraint template for mySQL
Revision Changes Path
No revision
No revision
1.39.2.49 +6 -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.39.2.48
retrieving revision 1.39.2.49
diff -u -r1.39.2.48 -r1.39.2.49
--- standardjbosscmp-jdbc.xml 24 Jun 2004 12:21:58 -0000 1.39.2.48
+++ standardjbosscmp-jdbc.xml 12 Jul 2004 21:22:09 -0000 1.39.2.49
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.48 2004/06/24 12:21:58 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.49 2004/07/12 21:22:09 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1711,8 +1711,11 @@
<name>mySQL</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>
- <!-- 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>
+ <!-- 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>
+ -->
+ <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>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
|
|
From: Alexey L. <lou...@us...> - 2004-07-12 21:24:18
|
User: loubyansky
Date: 04/07/12 14:24:11
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
fixed fk constraint template for mySQL
Revision Changes Path
1.81 +5 -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.80
retrieving revision 1.81
diff -u -r1.80 -r1.81
--- standardjbosscmp-jdbc.xml 24 Jun 2004 12:57:22 -0000 1.80
+++ standardjbosscmp-jdbc.xml 12 Jul 2004 21:24:11 -0000 1.81
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.80 2004/06/24 12:57:22 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.81 2004/07/12 21:24:11 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1711,8 +1711,10 @@
<name>mySQL</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>
- <!-- 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>
+ <!-- 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>
+ -->
+ <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>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
|
|
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>
|
|
From: Alexey L. <lou...@us...> - 2004-07-21 16:54:15
|
User: loubyansky
Date: 04/07/21 09:54:08
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added new templates from Branch_3_2
Revision Changes Path
1.82 +5 -1 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.81
retrieving revision 1.82
diff -u -r1.81 -r1.82
--- standardjbosscmp-jdbc.xml 12 Jul 2004 21:24:11 -0000 1.81
+++ standardjbosscmp-jdbc.xml 21 Jul 2004 16:54:08 -0000 1.82
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.81 2004/07/12 21:24:11 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.82 2004/07/21 16:54:08 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1424,6 +1424,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>
@@ -1716,6 +1718,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>
@@ -1855,6 +1858,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>
|
|
From: Ulf S. <sc...@us...> - 2004-09-02 08:22:50
|
User: schrouf
Date: 04/09/02 01:22:42
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Bugfix: changed InformixDB java.lang.object data type mapping to BLOB
Revision Changes Path
No revision
No revision
1.39.2.51 +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.39.2.50
retrieving revision 1.39.2.51
diff -u -r1.39.2.50 -r1.39.2.51
--- standardjbosscmp-jdbc.xml 13 Jul 2004 21:28:53 -0000 1.39.2.50
+++ standardjbosscmp-jdbc.xml 2 Sep 2004 08:22:40 -0000 1.39.2.51
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.50 2004/07/13 21:28:53 triathlon98 Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.51 2004/09/02 08:22:40 schrouf Exp $ -->
<jbosscmp-jdbc>
@@ -2502,8 +2502,8 @@
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BYTE</sql-type>
+ <jdbc-type>BLOB</jdbc-type>
+ <sql-type>BLOB</sql-type>
</mapping>
</type-mapping>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X