Menu
▾
▴
jboss-cvs-commits
|
From: Dain S. <dsu...@us...> - 2002-05-14 18:05:56
|
User: dsundstrom
Date: 02/05/14 11:05:56
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed mySQL default java.lang.Object mapping from BLOB to LONGBLOB.
Revision Changes Path
1.27 +6 -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.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- standardjbosscmp-jdbc.xml 10 May 2002 01:31:37 -0000 1.26
+++ standardjbosscmp-jdbc.xml 14 May 2002 18:05:55 -0000 1.27
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.26 2002/05/10 01:31:37 danch Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.27 2002/05/14 18:05:55 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1177,7 +1177,11 @@
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BLOB</sql-type>
+ <sql-type>LONGBLOB</sql-type>
+ <!--
+ | Change this from LONGBLOB to BLOB if you know your
+ | serialized object will be <= 2^16 bytes
+ -->
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
|
|
From: Dain S. <dsu...@us...> - 2002-05-15 03:29:40
|
User: dsundstrom
Date: 02/05/14 20:29:40
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed mySQL default java.lang.Object mapping from BLOB to LONGBLOB.
Revision Changes Path
No revision
No revision
1.23.2.4 +7 -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.3
retrieving revision 1.23.2.4
diff -u -r1.23.2.3 -r1.23.2.4
--- standardjbosscmp-jdbc.xml 10 May 2002 03:55:36 -0000 1.23.2.3
+++ standardjbosscmp-jdbc.xml 15 May 2002 03:29:39 -0000 1.23.2.4
@@ -879,7 +879,7 @@
<sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
-
+
<type-mapping>
<name>Hypersonic SQL</name>
<row-locking-template/>
@@ -1177,7 +1177,11 @@
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BLOB</sql-type>
+ <sql-type>LONGBLOB</sql-type>
+ <!--
+ | Change this from LONGBLOB to BLOB if you know your
+ | serialized object will be <= 2^16 bytes
+ -->
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
|
|
From: Dain S. <dsu...@us...> - 2002-06-06 03:46:36
|
User: dsundstrom
Date: 02/06/05 20:46:36
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed Oracle Locate function mapping. Mapping is now instr(?2, ?1, ?3).
Revision Changes Path
No revision
No revision
1.23.2.6 +4 -4 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.5
retrieving revision 1.23.2.6
diff -u -r1.23.2.5 -r1.23.2.6
--- standardjbosscmp-jdbc.xml 21 May 2002 14:51:41 -0000 1.23.2.5
+++ standardjbosscmp-jdbc.xml 6 Jun 2002 03:46:35 -0000 1.23.2.6
@@ -218,7 +218,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>instr(?1, ?2, ?3)</function-sql>
+ <function-sql>instr(?2, ?1, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
@@ -341,7 +341,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>instr(?1, ?2, ?3)</function-sql>
+ <function-sql>instr(?2, ?1, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
@@ -468,7 +468,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>instr(?1, ?2, ?3)</function-sql>
+ <function-sql>instr(?2, ?1, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-06 05:20:02
|
User: dsundstrom
Date: 02/06/05 22:20:01
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed PostgreSQL locate function mapping. The old version would return 0
if any of the parameters were null. The spec says that the function should
return null if any of the arguments are null.
Revision Changes Path
No revision
No revision
1.23.2.7 +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.6
retrieving revision 1.23.2.7
diff -u -r1.23.2.6 -r1.23.2.7
--- standardjbosscmp-jdbc.xml 6 Jun 2002 03:46:35 -0000 1.23.2.6
+++ standardjbosscmp-jdbc.xml 6 Jun 2002 05:20:00 -0000 1.23.2.7
@@ -669,7 +669,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>(coalesce(nullif(position(?1 in substring(?2 from ?3)), 0) + ?3 -1, 0)) </function-sql>
+ <function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
@@ -788,7 +788,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>(coalesce(nullif(position(?1 in substring(?2 from ?3)), 0) + ?3 -1, 0)) </function-sql>
+ <function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-06 05:28:43
|
User: dsundstrom
Date: 02/06/05 22:28:42
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed PostgreSQL locate function mapping. The old version would return 0
if any of the parameters were null. The spec says that the function should
return null if any of the arguments are null.
Revision Changes Path
1.30 +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.29
retrieving revision 1.30
diff -u -r1.29 -r1.30
--- standardjbosscmp-jdbc.xml 6 Jun 2002 03:31:17 -0000 1.29
+++ standardjbosscmp-jdbc.xml 6 Jun 2002 05:28:42 -0000 1.30
@@ -669,7 +669,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>(coalesce(nullif(position(?1 in substring(?2 from ?3)), 0) + ?3 -1, 0)) </function-sql>
+ <function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
@@ -788,7 +788,7 @@
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
- <function-sql>(coalesce(nullif(position(?1 in substring(?2 from ?3)), 0) + ?3 -1, 0)) </function-sql>
+ <function-sql>(CASE position(?1 in substring(?2 from ?3)) WHEN 0 THEN 0 ELSE position(?1 in substring(?2 from ?3)) + ?3 - 1 END)</function-sql>
</function-mapping>
<function-mapping>
<function-name>abs</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-09 19:09:30
|
User: dsundstrom
Date: 02/06/09 12:09:28
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Added new true-mapping and false-mapping elements to the type mappings.
Most are mapped to 1 and 0 respecively, because I don't know the correct
mappings for all databases. We will have to wait for user imput.
The mapping for Hypersonic is (1=1) and (1=0) because it has problems
parsing the literal values TRUE and FALSE is some where clauses. When
they fix the parser (1.7?) it should be changed back to TRUE and FALSE for
better readability.
Revision Changes Path
1.31 +54 -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.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- standardjbosscmp-jdbc.xml 6 Jun 2002 05:28:42 -0000 1.30
+++ standardjbosscmp-jdbc.xml 9 Jun 2002 19:09:25 -0000 1.31
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.30 2002/06/06 05:28:42 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.31 2002/06/09 19:09:25 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -41,6 +41,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -117,6 +120,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -200,6 +206,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -323,6 +332,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -450,6 +462,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -572,6 +587,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -651,6 +669,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -770,6 +791,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -889,6 +913,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>(1=1)</true-mapping>
+ <false-mapping>(1=0)</false-mapping>
<function-mapping>
<function-name>concat</function-name>
@@ -994,6 +1020,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1055,6 +1084,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1126,6 +1158,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>concat(?1, ?2)</function-sql>
@@ -1244,6 +1279,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
@@ -1363,6 +1401,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
@@ -1496,6 +1537,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1574,6 +1618,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
@@ -1650,6 +1697,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.math.BigDecimal</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
@@ -1732,6 +1782,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
|
|
From: Dain S. <dsu...@us...> - 2002-06-09 19:22:39
|
User: dsundstrom
Date: 02/06/09 12:22:38
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Added new true-mapping and false-mapping elements to the type mappings.
Most are mapped to 1 and 0 respecively, because I don't know the correct
mappings for all databases. We will have to wait for user imput.
The mapping for Hypersonic is (1=1) and (1=0) because it has problems
parsing the literal values TRUE and FALSE is some where clauses. When
they fix the parser (1.7?) it should be changed back to TRUE and FALSE for
better readability.
Revision Changes Path
No revision
No revision
1.23.2.8 +53 -0 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.7
retrieving revision 1.23.2.8
diff -u -r1.23.2.7 -r1.23.2.8
--- standardjbosscmp-jdbc.xml 6 Jun 2002 05:20:00 -0000 1.23.2.7
+++ standardjbosscmp-jdbc.xml 9 Jun 2002 19:22:38 -0000 1.23.2.8
@@ -41,6 +41,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -117,6 +120,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -200,6 +206,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -323,6 +332,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -450,6 +462,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>30</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -572,6 +587,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
@@ -651,6 +669,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -770,6 +791,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
@@ -889,6 +913,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>(1=1)</true-mapping>
+ <false-mapping>(1=0)</false-mapping>
<function-mapping>
<function-name>concat</function-name>
@@ -994,6 +1020,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1055,6 +1084,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1126,6 +1158,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>concat(?1, ?2)</function-sql>
@@ -1244,6 +1279,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
@@ -1363,6 +1401,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
@@ -1496,6 +1537,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1574,6 +1618,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
@@ -1650,6 +1697,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.math.BigDecimal</java-type>
<jdbc-type>LONGVARCHAR</jdbc-type>
@@ -1732,6 +1782,9 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
|
|
From: Dain S. <dsu...@us...> - 2002-06-14 03:39:15
|
User: dsundstrom
Date: 02/06/13 20:39:13
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed mySQL true to 0 and false to 1.
Revision Changes Path
1.32 +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.31
retrieving revision 1.32
diff -u -r1.31 -r1.32
--- standardjbosscmp-jdbc.xml 9 Jun 2002 19:09:25 -0000 1.31
+++ standardjbosscmp-jdbc.xml 14 Jun 2002 03:39:13 -0000 1.32
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.31 2002/06/09 19:09:25 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.32 2002/06/14 03:39:13 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1158,8 +1158,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
- <true-mapping>1</true-mapping>
- <false-mapping>0</false-mapping>
+ <true-mapping>0</true-mapping>
+ <false-mapping>1</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-14 03:41:41
|
User: dsundstrom
Date: 02/06/13 20:41:41
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed mySQL true to 0 and false to 1.
Revision Changes Path
No revision
No revision
1.23.2.9 +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.8
retrieving revision 1.23.2.9
diff -u -r1.23.2.8 -r1.23.2.9
--- standardjbosscmp-jdbc.xml 9 Jun 2002 19:22:38 -0000 1.23.2.8
+++ standardjbosscmp-jdbc.xml 14 Jun 2002 03:41:41 -0000 1.23.2.9
@@ -1158,8 +1158,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
- <true-mapping>1</true-mapping>
- <false-mapping>0</false-mapping>
+ <true-mapping>0</true-mapping>
+ <false-mapping>1</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-16 20:06:43
|
User: dsundstrom
Date: 02/06/16 13:06:42
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed Oracle Character jdbc-type to VARCHAR as Oracle does not support
CHAR jdbc-type is setObject. This should fix Character handling in Oracle.
Changes Oracle java.lang.Object jdbc-type to BLOB to activate new BLOB
handling code. This should fix BLOB handling in Oracle.
Revision Changes Path
1.34 +6 -6 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.33
retrieving revision 1.34
diff -u -r1.33 -r1.34
--- standardjbosscmp-jdbc.xml 16 Jun 2002 06:03:14 -0000 1.33
+++ standardjbosscmp-jdbc.xml 16 Jun 2002 20:06:42 -0000 1.34
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.33 2002/06/16 06:03:14 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.34 2002/06/16 20:06:42 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -284,7 +284,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
@@ -314,7 +314,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
@@ -410,7 +410,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
@@ -444,7 +444,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
@@ -535,7 +535,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
|
|
From: Dain S. <dsu...@us...> - 2002-06-19 14:56:43
|
User: dsundstrom
Date: 02/06/19 07:56:42
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed the mySQL true/false mapping. The correct maping is
TRUE=1 and FALSE=0. Thanks Soltesz Andras.
Revision Changes Path
1.35 +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.34
retrieving revision 1.35
diff -u -r1.34 -r1.35
--- standardjbosscmp-jdbc.xml 16 Jun 2002 20:06:42 -0000 1.34
+++ standardjbosscmp-jdbc.xml 19 Jun 2002 14:56:42 -0000 1.35
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.34 2002/06/16 20:06:42 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.35 2002/06/19 14:56:42 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -1158,8 +1158,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
- <true-mapping>0</true-mapping>
- <false-mapping>1</false-mapping>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-19 14:57:34
|
User: dsundstrom
Date: 02/06/19 07:57:33
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed the mySQL true/false mapping. The correct maping is
TRUE=1 and FALSE=0. Thanks Soltesz Andras.
Revision Changes Path
No revision
No revision
1.23.2.10 +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.9
retrieving revision 1.23.2.10
diff -u -r1.23.2.9 -r1.23.2.10
--- standardjbosscmp-jdbc.xml 14 Jun 2002 03:41:41 -0000 1.23.2.9
+++ standardjbosscmp-jdbc.xml 19 Jun 2002 14:57:33 -0000 1.23.2.10
@@ -1158,8 +1158,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>false</subquery-supported>
- <true-mapping>0</true-mapping>
- <false-mapping>1</false-mapping>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-19 23:57:43
|
User: dsundstrom
Date: 02/06/19 16:57:40
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed Oracle Character jdbc-type to VARCHAR as Oracle does not support
CHAR jdbc-type is setObject. This should fix Character handling in Oracle.
Changes Oracle java.lang.Object jdbc-type to BLOB to activate new BLOB
handling code. This should fix BLOB handling in Oracle.
Revision Changes Path
No revision
No revision
1.23.2.11 +8 -8 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.10
retrieving revision 1.23.2.11
diff -u -r1.23.2.10 -r1.23.2.11
--- standardjbosscmp-jdbc.xml 19 Jun 2002 14:57:33 -0000 1.23.2.10
+++ standardjbosscmp-jdbc.xml 19 Jun 2002 23:57:40 -0000 1.23.2.11
@@ -284,7 +284,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
@@ -314,7 +314,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
@@ -410,7 +410,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
@@ -444,7 +444,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
@@ -535,7 +535,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
@@ -956,8 +956,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
|
|
From: Dain S. <dsu...@us...> - 2002-06-20 17:32:10
|
User: dsundstrom
Date: 02/06/20 10:32:08
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed java.util.Date mapping for all type-mappings. This type has both
date and time informations so we need to use a Timestamp mapping.
Revision Changes Path
1.36 +19 -11 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.35
retrieving revision 1.36
diff -u -r1.35 -r1.36
--- standardjbosscmp-jdbc.xml 19 Jun 2002 14:56:42 -0000 1.35
+++ standardjbosscmp-jdbc.xml 20 Jun 2002 17:32:01 -0000 1.36
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.35 2002/06/19 14:56:42 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.36 2002/06/20 17:32:01 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -438,6 +438,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -563,6 +567,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -1144,8 +1152,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
</type-mapping>
@@ -1377,7 +1385,7 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
<mapping>
@@ -1505,7 +1513,7 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
@@ -1559,8 +1567,8 @@
-->
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1653,8 +1661,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1847,8 +1855,8 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME YEAR TO FRACTION(3)</sql-type>
</mapping>
<mapping>
|
|
From: Dain S. <dsu...@us...> - 2002-06-20 17:35:14
|
User: dsundstrom
Date: 02/06/20 10:35:00
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed java.util.Date mapping for all type-mappings. This type has both
date and time informations so we need to use a Timestamp mapping.
Revision Changes Path
No revision
No revision
1.23.2.12 +19 -11 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.11
retrieving revision 1.23.2.12
diff -u -r1.23.2.11 -r1.23.2.12
--- standardjbosscmp-jdbc.xml 19 Jun 2002 23:57:40 -0000 1.23.2.11
+++ standardjbosscmp-jdbc.xml 20 Jun 2002 17:34:51 -0000 1.23.2.12
@@ -438,6 +438,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -563,6 +567,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -1144,8 +1152,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
</type-mapping>
@@ -1377,7 +1385,7 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
<mapping>
@@ -1505,7 +1513,7 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
@@ -1559,8 +1567,8 @@
-->
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1653,8 +1661,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1847,8 +1855,8 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME YEAR TO FRACTION(3)</sql-type>
</mapping>
<mapping>
|
|
From: Dain S. <dsu...@us...> - 2002-06-25 16:07:37
|
User: dsundstrom
Date: 02/06/25 09:07:35
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed PostgreSQL 7.2 true-mapping to TRUE and false-mapping to FALSE.
Revision Changes Path
1.37 +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.36
retrieving revision 1.37
diff -u -r1.36 -r1.37
--- standardjbosscmp-jdbc.xml 20 Jun 2002 17:32:01 -0000 1.36
+++ standardjbosscmp-jdbc.xml 25 Jun 2002 16:07:35 -0000 1.37
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.36 2002/06/20 17:32:01 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.37 2002/06/25 16:07:35 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -799,8 +799,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
- <true-mapping>1</true-mapping>
- <false-mapping>0</false-mapping>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-25 16:09:22
|
User: dsundstrom
Date: 02/06/25 09:09:22
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed PostgreSQL 7.2 true-mapping to TRUE and false-mapping to FALSE.
Revision Changes Path
No revision
No revision
1.23.2.13 +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.23.2.12
retrieving revision 1.23.2.13
diff -u -r1.23.2.12 -r1.23.2.13
--- standardjbosscmp-jdbc.xml 20 Jun 2002 17:34:51 -0000 1.23.2.12
+++ standardjbosscmp-jdbc.xml 25 Jun 2002 16:09:22 -0000 1.23.2.13
@@ -799,8 +799,8 @@
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
<subquery-supported>true</subquery-supported>
- <true-mapping>1</true-mapping>
- <false-mapping>0</false-mapping>
+ <true-mapping>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
<function-mapping>
<function-name>concat</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-06-27 19:58:52
|
User: dsundstrom
Date: 02/06/27 12:58:50
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed Oracle9i java.lang.Object jdbc-type mapping back to JAVA_OBJECT
because 9i does not support the 8 BLOB hack.
Revision Changes Path
No revision
No revision
1.23.2.14 +1 -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.23.2.13
retrieving revision 1.23.2.14
diff -u -r1.23.2.13 -r1.23.2.14
--- standardjbosscmp-jdbc.xml 25 Jun 2002 16:09:22 -0000 1.23.2.13
+++ standardjbosscmp-jdbc.xml 27 Jun 2002 19:58:50 -0000 1.23.2.14
@@ -314,7 +314,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>BLOB</jdbc-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
|
|
From: Dain S. <dsu...@us...> - 2002-06-27 20:00:25
|
User: dsundstrom
Date: 02/06/27 13:00:23
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed Oracle9i java.lang.Object jdbc-type mapping back to JAVA_OBJECT
because 9i does not support the 8 BLOB hack.
Revision Changes Path
1.38 +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.37
retrieving revision 1.38
diff -u -r1.37 -r1.38
--- standardjbosscmp-jdbc.xml 25 Jun 2002 16:07:35 -0000 1.37
+++ standardjbosscmp-jdbc.xml 27 Jun 2002 20:00:23 -0000 1.38
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.37 2002/06/25 16:07:35 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.38 2002/06/27 20:00:23 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -314,7 +314,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>BLOB</jdbc-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
| Change this from BLOB to RAW(255) if you know your
|
|
From: Ole H. <sp...@us...> - 2002-07-08 21:14:36
|
User: sparre
Date: 02/07/08 14:14:35
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Changed jdbc type for the Interbase/Firebird mappings for
java.lang.Character from CHAR to VARCHAR.
Otherwise, the CMP2.0 engine will supply a Character to
the Firebird driver, which makes it choke with an exception
"Error converting to object".
Revision Changes Path
1.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.38
retrieving revision 1.39
diff -u -r1.38 -r1.39
--- standardjbosscmp-jdbc.xml 27 Jun 2002 20:00:23 -0000 1.38
+++ standardjbosscmp-jdbc.xml 8 Jul 2002 21:14:34 -0000 1.39
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.38 2002/06/27 20:00:23 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39 2002/07/08 21:14:34 sparre Exp $ -->
<jbosscmp-jdbc>
@@ -81,7 +81,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
|
|
From: Ole H. <sp...@us...> - 2002-07-14 20:01:37
|
User: sparre
Date: 02/07/14 13:01:36
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Changed jdbc type for the Interbase/Firebird mappings for
java.lang.Character from CHAR to VARCHAR.
Otherwise, the CMP2.0 engine will supply a Character to
the Firebird driver, which makes it choke with an exception
"Error converting to object".
This is a backport of the same fix in HEAD
Revision Changes Path
No revision
No revision
1.23.2.15 +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.23.2.14
retrieving revision 1.23.2.15
diff -u -r1.23.2.14 -r1.23.2.15
--- standardjbosscmp-jdbc.xml 27 Jun 2002 19:58:50 -0000 1.23.2.14
+++ standardjbosscmp-jdbc.xml 14 Jul 2002 20:01:35 -0000 1.23.2.15
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.14 2002/06/27 19:58:50 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.15 2002/07/14 20:01:35 sparre Exp $ -->
<jbosscmp-jdbc>
@@ -81,7 +81,7 @@
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
+ <jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
|
|
From: David J. <d_j...@us...> - 2002-08-11 04:02:51
|
User: d_jencks
Date: 02/08/10 21:02:50
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added firebird type mapping, using blobs for objects
Revision Changes Path
1.40 +84 -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
retrieving revision 1.40
diff -u -r1.39 -r1.40
--- standardjbosscmp-jdbc.xml 8 Jul 2002 21:14:34 -0000 1.39
+++ standardjbosscmp-jdbc.xml 11 Aug 2002 04:02:50 -0000 1.40
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39 2002/07/08 21:14:34 sparre Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.40 2002/08/11 04:02:50 d_jencks Exp $ -->
<jbosscmp-jdbc>
@@ -32,6 +32,89 @@
</defaults>
<type-mappings>
+ <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 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>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>NUMERIC(18,0)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>FLOAT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <!-- The small default length is due to the 128 byte max index key size -->
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(64)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+
<type-mapping>
<name>InterBase</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
|
|
From: Dain S. <dsu...@us...> - 2002-08-30 03:52:25
|
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>
|
|
From: Dain S. <dsu...@us...> - 2002-08-30 04:16:43
|
User: dsundstrom
Date: 02/08/29 21:16:43
Modified: src/etc/conf/default Tag: Branch_3_2
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.39.2.1 +86 -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
retrieving revision 1.39.2.1
diff -u -r1.39 -r1.39.2.1
--- standardjbosscmp-jdbc.xml 8 Jul 2002 21:14:34 -0000 1.39
+++ standardjbosscmp-jdbc.xml 30 Aug 2002 04:16:43 -0000 1.39.2.1
@@ -33,6 +33,89 @@
<type-mappings>
<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 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>
+ <subquery-supported>true</subquery-supported>
+ <true-mapping>1</true-mapping>
+ <false-mapping>0</false-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>NUMERIC(18,0)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>FLOAT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <!-- The small default length is due to the 128 byte max index key size -->
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(64)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>InterBase</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>
@@ -1161,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>
@@ -1783,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>
|
|
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>
|
×
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