Menu
▾
▴
jboss-cvs-commits
|
From: Dain S. <dsu...@us...> - 2002-09-03 14:52:25
|
User: dsundstrom
Date: 02/09/03 07:52:21
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Added mckoi type mapping. Thanks David Good!
Changed mySQL String mapping from VARCHAR(255) to VARCHAR(250) which should
make strings easier to use in custom pk classes.
Revision Changes Path
1.42 +80 -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.41
retrieving revision 1.42
diff -u -r1.41 -r1.42
--- standardjbosscmp-jdbc.xml 30 Aug 2002 03:52:24 -0000 1.41
+++ standardjbosscmp-jdbc.xml 3 Sep 2002 14:52:20 -0000 1.42
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.41 2002/08/30 03:52:24 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.42 2002/09/03 14:52:20 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -30,7 +30,84 @@
</read-ahead>
<list-cache-max>1000</list-cache-max>
</defaults>
-
+
+ <type-mapping>
+ <name>mckoi</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>
+ <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>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</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>BIGINT</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</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <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>JAVA_OBJECT</sql-type>
+ </mapping>
+ </type-mapping>
+
<type-mappings>
<type-mapping>
<name>Firebird</name>
@@ -1342,7 +1419,7 @@
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(255) BINARY</sql-type>
+ <sql-type>VARCHAR(250) BINARY</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
|
|
From: Dain S. <dsu...@us...> - 2002-09-03 15:01:56
|
User: dsundstrom
Date: 02/09/03 08:01:56
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Added mckoi type mapping. Thanks David Good!
Changed mySQL String mapping from VARCHAR(255) to VARCHAR(250) which should
make strings easier to use in custom pk classes.
Revision Changes Path
No revision
No revision
1.39.2.2 +80 -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.1
retrieving revision 1.39.2.2
diff -u -r1.39.2.1 -r1.39.2.2
--- standardjbosscmp-jdbc.xml 30 Aug 2002 04:16:43 -0000 1.39.2.1
+++ standardjbosscmp-jdbc.xml 3 Sep 2002 15:01:55 -0000 1.39.2.2
@@ -30,7 +30,84 @@
</read-ahead>
<list-cache-max>1000</list-cache-max>
</defaults>
-
+
+ <type-mapping>
+ <name>mckoi</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>
+ <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>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</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>BIGINT</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</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</sql-type>
+ </mapping>
+ <mapping>
+ <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>JAVA_OBJECT</sql-type>
+ </mapping>
+ </type-mapping>
+
<type-mappings>
<type-mapping>
<name>Firebird</name>
@@ -1342,7 +1419,7 @@
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(255) BINARY</sql-type>
+ <sql-type>VARCHAR(250) BINARY</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
|
|
From: Alexey L. <lou...@us...> - 2002-09-04 06:10:28
|
User: loubyansky
Date: 02/09/03 23:10:27
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added unknown-pk elements with default values in defaults
Revision Changes Path
1.43 +8 -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.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- standardjbosscmp-jdbc.xml 3 Sep 2002 14:52:20 -0000 1.42
+++ standardjbosscmp-jdbc.xml 4 Sep 2002 06:10:26 -0000 1.43
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.42 2002/09/03 14:52:20 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.43 2002/09/04 06:10:26 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -29,6 +29,13 @@
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
+
+ <unknown-pk>
+ <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
+ <unknown-pk-class>java.lang.String</unknown-pk-class>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(32)</sql-type>
+ </unknown-pk>
</defaults>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2002-09-13 17:56:41
|
User: loubyansky
Date: 02/09/13 10:56:40
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
- added new elements to declare entity commands;
- added auto-increment sql template.
Revision Changes Path
1.44 +18 -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.43
retrieving revision 1.44
diff -u -r1.43 -r1.44
--- standardjbosscmp-jdbc.xml 4 Sep 2002 06:10:26 -0000 1.43
+++ standardjbosscmp-jdbc.xml 13 Sep 2002 17:56:39 -0000 1.44
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.43 2002/09/04 06:10:26 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.44 2002/09/13 17:56:39 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -36,6 +36,14 @@
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(32)</sql-type>
</unknown-pk>
+
+ <create-entity-command>default_create_command</create-entity-command>
+ <entity-commands>
+ <entity-command>
+ <command-name>default_create_command</command-name>
+ <command-class>org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand</command-class>
+ </entity-command>
+ </entity-commands>
</defaults>
<type-mapping>
@@ -1329,6 +1337,7 @@
<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 INDEX ind_?3 (?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>
<alias-max-length>32</alias-max-length>
@@ -1443,6 +1452,14 @@
<jdbc-type>TIME</jdbc-type>
<sql-type>BIGINT</sql-type>
</mapping>
+
+ <entity-commands>
+ <entity-command>
+ <command-name>auto_increment</command-name>
+ <command-class>org.jboss.ejb.plugins.cmp.jdbc.mysql.MySQLCreateEntityCommand</command-class>
+ </entity-command>
+ </entity-commands>
+
</type-mapping>
<type-mapping>
|
|
From: Dain S. <dsu...@us...> - 2002-09-16 20:31:35
|
User: dsundstrom
Date: 02/09/16 13:31:34
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed bug [ 605041 ] Mapping of EJB-QL 'length' for Oracle.
Thanks Timo Warns!
Revision Changes Path
1.45 +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.44
retrieving revision 1.45
diff -u -r1.44 -r1.45
--- standardjbosscmp-jdbc.xml 13 Sep 2002 17:56:39 -0000 1.44
+++ standardjbosscmp-jdbc.xml 16 Sep 2002 20:31:33 -0000 1.45
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.44 2002/09/13 17:56:39 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.45 2002/09/16 20:31:33 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -398,7 +398,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -524,7 +524,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -658,7 +658,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-09-16 20:34:00
|
User: dsundstrom
Date: 02/09/16 13:33:59
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fixed bug [ 605041 ] Mapping of EJB-QL 'length' for Oracle.
Thanks Timo Warns!
Revision Changes Path
No revision
No revision
1.39.2.3 +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.39.2.2
retrieving revision 1.39.2.3
diff -u -r1.39.2.2 -r1.39.2.3
--- standardjbosscmp-jdbc.xml 3 Sep 2002 15:01:55 -0000 1.39.2.2
+++ standardjbosscmp-jdbc.xml 16 Sep 2002 20:33:58 -0000 1.39.2.3
@@ -383,7 +383,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -509,7 +509,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -643,7 +643,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-09-16 20:35:36
|
User: dsundstrom
Date: 02/09/16 13:35:36
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed bug [ 605041 ] Mapping of EJB-QL 'length' for Oracle.
Thanks Timo Warns!
Revision Changes Path
No revision
No revision
1.23.2.18 +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.17
retrieving revision 1.23.2.18
diff -u -r1.23.2.17 -r1.23.2.18
--- standardjbosscmp-jdbc.xml 3 Sep 2002 15:16:16 -0000 1.23.2.17
+++ standardjbosscmp-jdbc.xml 16 Sep 2002 20:35:36 -0000 1.23.2.18
@@ -300,7 +300,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -426,7 +426,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
@@ -560,7 +560,7 @@
</function-mapping>
<function-mapping>
<function-name>length</function-name>
- <function-sql>len(?1)</function-sql>
+ <function-sql>length(?1)</function-sql>
</function-mapping>
<function-mapping>
<function-name>locate</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-09-18 03:05:51
|
User: dsundstrom
Date: 02/09/17 20:05:51
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fixed sqrt mapping for postgres.
Revision Changes Path
No revision
No revision
1.23.2.19 +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.18
retrieving revision 1.23.2.19
diff -u -r1.23.2.18 -r1.23.2.19
--- standardjbosscmp-jdbc.xml 16 Sep 2002 20:35:36 -0000 1.23.2.18
+++ standardjbosscmp-jdbc.xml 18 Sep 2002 03:05:50 -0000 1.23.2.19
@@ -783,7 +783,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
@@ -905,7 +905,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
|
|
From: Alexey L. <lou...@us...> - 2002-09-19 16:36:27
|
User: loubyansky
Date: 02/09/19 09:36:26
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
changed entity-command stuff
Revision Changes Path
1.46 +31 -15 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.45
retrieving revision 1.46
diff -u -r1.45 -r1.46
--- standardjbosscmp-jdbc.xml 16 Sep 2002 20:31:33 -0000 1.45
+++ standardjbosscmp-jdbc.xml 19 Sep 2002 16:36:25 -0000 1.46
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.45 2002/09/16 20:31:33 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.46 2002/09/19 16:36:25 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -37,13 +37,8 @@
<sql-type>VARCHAR(32)</sql-type>
</unknown-pk>
- <create-entity-command>default_create_command</create-entity-command>
- <entity-commands>
- <entity-command>
- <command-name>default_create_command</command-name>
- <command-class>org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand</command-class>
- </entity-command>
- </entity-commands>
+ <entity-command name="default"/>
+
</defaults>
<type-mapping>
@@ -1453,13 +1448,6 @@
<sql-type>BIGINT</sql-type>
</mapping>
- <entity-commands>
- <entity-command>
- <command-name>auto_increment</command-name>
- <command-class>org.jboss.ejb.plugins.cmp.jdbc.mysql.MySQLCreateEntityCommand</command-class>
- </entity-command>
- </entity-commands>
-
</type-mapping>
<type-mapping>
@@ -2069,4 +2057,32 @@
</type-mapping>
</type-mappings>
+
+ <entity-commands>
+ <!-- default command; doesn't support unknown-pk -->
+ <entity-command name="default"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand"/>
+
+ <!-- fetches next key value with the specified sql statement -->
+ <entity-command name="pk-sql"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCPkSqlCreateCommand">
+ <attribute name="pk-sql">SELECT CURRENT_TIMESTAMP</attribute>
+ </entity-command>
+
+ <!-- this command requires auto-increment element for unknown-pk -->
+ <entity-command name="mysql-get-generated-keys"
+ class="org.jboss.ejb.plugins.cmp.jdbc.mysql.MySQLCreateEntityCommand"/>
+
+ <!-- uses key generator to fetch the next key value -->
+ <entity-command name="key-generator"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCKeyGeneratorCreateCommand">
+ <attribute name="key-generator-factory">UUIDKeyGeneratorFactory</attribute>
+ </entity-command>
+
+<!-- JDK1.4
+ <entity-command name="get-generated-keys"
+ class="org.jboss.ejb.plugins.cmp.jdbc.jdbc3.JDBCGetGeneratedKeysCreateCommand"/>
+-->
+ </entity-commands>
+
</jbosscmp-jdbc>
|
|
From: Dain S. <dsu...@us...> - 2002-09-21 18:12:21
|
User: dsundstrom
Date: 02/09/21 11:12:21
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed sqrt mapping for postgres.
Revision Changes Path
1.47 +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.46
retrieving revision 1.47
diff -u -r1.46 -r1.47
--- standardjbosscmp-jdbc.xml 19 Sep 2002 16:36:25 -0000 1.46
+++ standardjbosscmp-jdbc.xml 21 Sep 2002 18:12:20 -0000 1.47
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.46 2002/09/19 16:36:25 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.47 2002/09/21 18:12:20 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -876,7 +876,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
@@ -998,7 +998,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
|
|
From: Dain S. <dsu...@us...> - 2002-09-21 23:38:09
|
User: dsundstrom
Date: 02/09/21 16:38:08
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fixed sqrt mapping for postgres.
Revision Changes Path
No revision
No revision
1.39.2.4 +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.3
retrieving revision 1.39.2.4
diff -u -r1.39.2.3 -r1.39.2.4
--- standardjbosscmp-jdbc.xml 16 Sep 2002 20:33:58 -0000 1.39.2.3
+++ standardjbosscmp-jdbc.xml 21 Sep 2002 23:38:08 -0000 1.39.2.4
@@ -866,7 +866,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
@@ -988,7 +988,7 @@
</function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
- <function-sql>sqrt(?1)</function-sql>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
</function-mapping>
<function-mapping>
<function-name>ucase</function-name>
|
|
From: Alexey L. <lou...@us...> - 2002-09-24 15:23:59
|
User: loubyansky
Date: 02/09/24 08:23:58
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Renamed MySQLCreateEntityCommand.java to JDBCMySQLCreateCommand.java
Revision Changes Path
1.48 +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.47
retrieving revision 1.48
diff -u -r1.47 -r1.48
--- standardjbosscmp-jdbc.xml 21 Sep 2002 18:12:20 -0000 1.47
+++ standardjbosscmp-jdbc.xml 24 Sep 2002 15:23:56 -0000 1.48
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.47 2002/09/21 18:12:20 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.48 2002/09/24 15:23:56 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -2071,7 +2071,7 @@
<!-- this command requires auto-increment element for unknown-pk -->
<entity-command name="mysql-get-generated-keys"
- class="org.jboss.ejb.plugins.cmp.jdbc.mysql.MySQLCreateEntityCommand"/>
+ class="org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand"/>
<!-- uses key generator to fetch the next key value -->
<entity-command name="key-generator"
|
|
From: Alexey L. <lou...@us...> - 2002-09-24 16:07:39
|
User: loubyansky
Date: 02/09/24 09:07:36
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
porting standardjbosscmp-jdbc.xml (support for unknown-pk and entity-commands) from HEAD to Branch_3_2
Revision Changes Path
No revision
No revision
1.39.2.5 +40 -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.39.2.4
retrieving revision 1.39.2.5
diff -u -r1.39.2.4 -r1.39.2.5
--- standardjbosscmp-jdbc.xml 21 Sep 2002 23:38:08 -0000 1.39.2.4
+++ standardjbosscmp-jdbc.xml 24 Sep 2002 16:07:35 -0000 1.39.2.5
@@ -29,6 +29,16 @@
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>
+
+ <unknown-pk>
+ <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory>
+ <unknown-pk-class>java.lang.String</unknown-pk-class>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(32)</sql-type>
+ </unknown-pk>
+
+ <entity-command name="default"/>
+
</defaults>
<type-mapping>
@@ -1322,6 +1332,7 @@
<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 INDEX ind_?3 (?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>
<alias-max-length>32</alias-max-length>
@@ -1436,6 +1447,7 @@
<jdbc-type>TIME</jdbc-type>
<sql-type>BIGINT</sql-type>
</mapping>
+
</type-mapping>
<type-mapping>
@@ -2045,4 +2057,32 @@
</type-mapping>
</type-mappings>
+
+ <entity-commands>
+ <!-- default command; doesn't support unknown-pk -->
+ <entity-command name="default"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand"/>
+
+ <!-- fetches next key value with the specified sql statement -->
+ <entity-command name="pk-sql"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCPkSqlCreateCommand">
+ <attribute name="pk-sql">SELECT CURRENT_TIMESTAMP</attribute>
+ </entity-command>
+
+ <!-- this command requires auto-increment element for unknown-pk -->
+ <entity-command name="mysql-get-generated-keys"
+ class="org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand"/>
+
+ <!-- uses key generator to fetch the next key value -->
+ <entity-command name="key-generator"
+ class="org.jboss.ejb.plugins.cmp.jdbc.JDBCKeyGeneratorCreateCommand">
+ <attribute name="key-generator-factory">UUIDKeyGeneratorFactory</attribute>
+ </entity-command>
+
+<!-- JDK1.4
+ <entity-command name="get-generated-keys"
+ class="org.jboss.ejb.plugins.cmp.jdbc.jdbc3.JDBCGetGeneratedKeysCreateCommand"/>
+-->
+ </entity-commands>
+
</jbosscmp-jdbc>
|
|
From: Sacha L. <sla...@us...> - 2002-10-01 21:39:54
|
User: slaboure
Date: 02/10/01 14:39:53
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
McKoi: type-mappingS tag badly placed + added true/false mapping
Revision Changes Path
1.49 +6 -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.48
retrieving revision 1.49
diff -u -r1.48 -r1.49
--- standardjbosscmp-jdbc.xml 24 Sep 2002 15:23:56 -0000 1.48
+++ standardjbosscmp-jdbc.xml 1 Oct 2002 21:39:52 -0000 1.49
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.48 2002/09/24 15:23:56 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.49 2002/10/01 21:39:52 slaboure Exp $ -->
<jbosscmp-jdbc>
@@ -41,8 +41,9 @@
</defaults>
- <type-mapping>
- <name>mckoi</name>
+ <type-mappings>
+ <type-mapping>
+ <name>McKoi</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>
@@ -50,6 +51,8 @@
<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>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -118,7 +121,6 @@
</mapping>
</type-mapping>
- <type-mappings>
<type-mapping>
<name>Firebird</name>
<!-- For use with the Firebirdsql jca-jdbc driver.
|
|
From: Sacha L. <sla...@us...> - 2002-10-01 21:41:06
|
User: slaboure
Date: 02/10/01 14:41:05
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
McKoi: type-mappingS tag badly placed + added true/false mapping
Revision Changes Path
No revision
No revision
1.23.2.20 +6 -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.19
retrieving revision 1.23.2.20
diff -u -r1.23.2.19 -r1.23.2.20
--- standardjbosscmp-jdbc.xml 18 Sep 2002 03:05:50 -0000 1.23.2.19
+++ standardjbosscmp-jdbc.xml 1 Oct 2002 21:41:05 -0000 1.23.2.20
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.19 2002/09/18 03:05:50 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.20 2002/10/01 21:41:05 slaboure Exp $ -->
<jbosscmp-jdbc>
@@ -31,8 +31,9 @@
<list-cache-max>1000</list-cache-max>
</defaults>
- <type-mapping>
- <name>mckoi</name>
+ <type-mappings>
+ <type-mapping>
+ <name>McKoi</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>
@@ -40,6 +41,8 @@
<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>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -108,7 +111,6 @@
</mapping>
</type-mapping>
- <type-mappings>
<type-mapping>
<name>InterBase</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
|
|
From: Sacha L. <sla...@us...> - 2002-10-01 21:42:13
|
User: slaboure
Date: 02/10/01 14:42:12
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
McKoi: type-mappingS tag badly placed + added true/false mapping
Revision Changes Path
No revision
No revision
1.39.2.6 +7 -5 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.5
retrieving revision 1.39.2.6
diff -u -r1.39.2.5 -r1.39.2.6
--- standardjbosscmp-jdbc.xml 24 Sep 2002 16:07:35 -0000 1.39.2.5
+++ standardjbosscmp-jdbc.xml 1 Oct 2002 21:42:12 -0000 1.39.2.6
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.5 2002/09/24 16:07:35 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.6 2002/10/01 21:42:12 slaboure Exp $ -->
<jbosscmp-jdbc>
@@ -41,8 +41,9 @@
</defaults>
- <type-mapping>
- <name>mckoi</name>
+ <type-mappings>
+ <type-mapping>
+ <name>McKoi</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>
@@ -50,6 +51,8 @@
<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>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -116,9 +119,8 @@
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>JAVA_OBJECT</sql-type>
</mapping>
- </type-mapping>
+ </type-mapping>
- <type-mappings>
<type-mapping>
<name>Firebird</name>
<!-- For use with the Firebirdsql jca-jdbc driver.
|
|
From: Stephen C. <sc...@us...> - 2002-10-03 06:38:41
|
User: scoy
Date: 02/10/02 23:38:40
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Added hsqldb mappings for java.sql.Date, java.sql.Time, java.math.BigDecimal and java.lang.Object.
Revision Changes Path
No revision
No revision
1.23.2.21 +22 -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.20
retrieving revision 1.23.2.21
diff -u -r1.23.2.20 -r1.23.2.21
--- standardjbosscmp-jdbc.xml 1 Oct 2002 21:41:05 -0000 1.23.2.20
+++ standardjbosscmp-jdbc.xml 3 Oct 2002 06:38:40 -0000 1.23.2.21
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.20 2002/10/01 21:41:05 slaboure Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.21 2002/10/03 06:38:40 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1077,6 +1077,16 @@
<sql-type>VARCHAR(256)</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>
@@ -1095,6 +1105,17 @@
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>VARBINARY</sql-type>
</mapping>
</type-mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-03 06:40:06
|
User: scoy
Date: 02/10/02 23:40:05
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Added hsqldb mappings for java.sql.Date, java.sql.Time, java.math.BigDecimal and java.lang.Object.
Revision Changes Path
No revision
No revision
1.39.2.7 +22 -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.6
retrieving revision 1.39.2.7
diff -u -r1.39.2.6 -r1.39.2.7
--- standardjbosscmp-jdbc.xml 1 Oct 2002 21:42:12 -0000 1.39.2.6
+++ standardjbosscmp-jdbc.xml 3 Oct 2002 06:40:05 -0000 1.39.2.7
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.6 2002/10/01 21:42:12 slaboure Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.7 2002/10/03 06:40:05 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1170,6 +1170,16 @@
<sql-type>VARCHAR(256)</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>
@@ -1188,6 +1198,17 @@
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>VARBINARY</sql-type>
</mapping>
</type-mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-23 13:31:00
|
User: scoy
Date: 02/10/23 06:30:59
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Added hsqldb mappings for java.sql.Date, java.sql.Time, java.math.BigDecimal and java.lang.Object.
Revision Changes Path
1.50 +19 -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.49
retrieving revision 1.50
diff -u -r1.49 -r1.50
--- standardjbosscmp-jdbc.xml 1 Oct 2002 21:39:52 -0000 1.49
+++ standardjbosscmp-jdbc.xml 23 Oct 2002 13:30:58 -0000 1.50
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.49 2002/10/01 21:39:52 slaboure Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.50 2002/10/23 13:30:58 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1151,8 +1151,9 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OBJECT</sql-type>
+ <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>VARBINARY</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
@@ -1170,6 +1171,16 @@
<sql-type>VARCHAR(256)</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>
@@ -1188,6 +1199,11 @@
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
</mapping>
</type-mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 02:30:28
|
User: scoy
Date: 02/10/30 18:30:27
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Refined mappings for Oracle 9i, Postgres and mysql by running against the cmp2 test suite.
In particular, mapping java.lang.Object to JAVA_OBJECT is almost always completely wrong.
Revision Changes Path
No revision
No revision
1.23.2.22 +41 -24 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.21
retrieving revision 1.23.2.22
diff -u -r1.23.2.21 -r1.23.2.22
--- standardjbosscmp-jdbc.xml 3 Oct 2002 06:38:40 -0000 1.23.2.21
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 02:30:26 -0000 1.23.2.22
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.21 2002/10/03 06:38:40 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.22 2002/10/31 02:30:26 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -393,11 +393,11 @@
</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
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -530,8 +530,8 @@
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
- | Change this from BLOB to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -656,11 +656,12 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>LONG RAW</sql-type>
<!--
- | Change this from LONG RAW to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from LONG RAW to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
+ | Oracle only permits one LONG type per table
-->
</mapping>
</type-mapping>
@@ -864,8 +865,8 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OID</sql-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -986,7 +987,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>VARBINARY</jdbc-type>
<sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -1058,8 +1059,9 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OBJECT</sql-type>
+ <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>VARBINARY</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
@@ -1111,12 +1113,6 @@
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>DECIMAL</sql-type>
</mapping>
- <mapping>
- <java-type>java.lang.Object</java-type>
- <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
- <jdbc-type>VARBINARY</jdbc-type>
- <sql-type>VARBINARY</sql-type>
- </mapping>
</type-mapping>
<type-mapping>
@@ -1318,8 +1314,13 @@
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>LONGBLOB</sql-type>
<!--
| Change this from LONGBLOB to BLOB if you know your
@@ -1340,6 +1341,10 @@
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
+ <!--
+ | This type is problematical because mysql does not have any
+ | date/time types that store milliseconds. You should avoid it.
+ -->
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1365,6 +1370,10 @@
<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1374,7 +1383,7 @@
<mapping>
<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
- <sql-type>BIGINT</sql-type>
+ <sql-type>TIME</sql-type>
</mapping>
</type-mapping>
@@ -1469,9 +1478,13 @@
<sql-type>TINYINT</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1594,9 +1607,13 @@
</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 05:27:43
|
User: scoy
Date: 02/10/30 21:27:42
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Refined mappings for Oracle 9i, Postgres and mysql by running against the cmp2 test suite.
In particular, mapping java.lang.Object to JAVA_OBJECT is almost always completely wrong.
Revision Changes Path
No revision
No revision
1.39.2.8 +41 -25 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.7
retrieving revision 1.39.2.8
diff -u -r1.39.2.7 -r1.39.2.8
--- standardjbosscmp-jdbc.xml 3 Oct 2002 06:40:05 -0000 1.39.2.7
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 05:27:42 -0000 1.39.2.8
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.7 2002/10/03 06:40:05 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.8 2002/10/31 05:27:42 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -486,11 +486,11 @@
</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
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -623,8 +623,8 @@
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
- | Change this from BLOB to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -749,11 +749,12 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>LONG RAW</sql-type>
<!--
- | Change this from LONG RAW to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from LONG RAW to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
+ | Oracle only permits one LONG type per table
-->
</mapping>
</type-mapping>
@@ -957,8 +958,8 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OID</sql-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -1079,7 +1080,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>VARBINARY</jdbc-type>
<sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -1151,8 +1152,9 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OBJECT</sql-type>
+ <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>VARBINARY</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
@@ -1204,12 +1206,6 @@
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>DECIMAL</sql-type>
</mapping>
- <mapping>
- <java-type>java.lang.Object</java-type>
- <!-- hsqldb only supports directly serializable objects for sql type OBJECT -->
- <jdbc-type>VARBINARY</jdbc-type>
- <sql-type>VARBINARY</sql-type>
- </mapping>
</type-mapping>
<type-mapping>
@@ -1412,8 +1408,13 @@
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>LONGBLOB</sql-type>
<!--
| Change this from LONGBLOB to BLOB if you know your
@@ -1434,6 +1435,10 @@
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
+ <!--
+ | This type is problematical because mysql does not have any
+ | date/time types that store milliseconds. You should avoid it.
+ -->
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1459,6 +1464,10 @@
<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1468,9 +1477,8 @@
<mapping>
<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
- <sql-type>BIGINT</sql-type>
+ <sql-type>TIME</sql-type>
</mapping>
-
</type-mapping>
<type-mapping>
@@ -1564,9 +1572,13 @@
<sql-type>TINYINT</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1689,9 +1701,13 @@
</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 06:37:47
|
User: scoy
Date: 02/10/30 22:37:46
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Refined mappings for Oracle 9i, Postgres and mysql by running against the cmp2 test suite.
In particular, mapping java.lang.Object to JAVA_OBJECT is almost always completely wrong.
Revision Changes Path
1.51 +38 -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.50
retrieving revision 1.51
diff -u -r1.50 -r1.51
--- standardjbosscmp-jdbc.xml 23 Oct 2002 13:30:58 -0000 1.50
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 06:37:46 -0000 1.51
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.50 2002/10/23 13:30:58 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.51 2002/10/31 06:37:46 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -486,11 +486,11 @@
</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
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -623,8 +623,8 @@
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
<!--
- | Change this from BLOB to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from BLOB to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
-->
</mapping>
</type-mapping>
@@ -749,11 +749,12 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
<sql-type>LONG RAW</sql-type>
<!--
- | Change this from LONG RAW to RAW(255) if you know your
- | serialized object will be <= 255 bytes
+ | Change this from LONG RAW to RAW(n) if you know your
+ | serialized object will be <= n bytes and n <= 2000
+ | Oracle only permits one LONG type per table
-->
</mapping>
</type-mapping>
@@ -957,8 +958,8 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>OID</sql-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -1079,7 +1080,7 @@
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>VARBINARY</jdbc-type>
<sql-type>BYTEA</sql-type>
</mapping>
</type-mapping>
@@ -1407,8 +1408,13 @@
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <jdbc-type>BLOB</jdbc-type>
<sql-type>LONGBLOB</sql-type>
<!--
| Change this from LONGBLOB to BLOB if you know your
@@ -1429,6 +1435,10 @@
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
+ <!--
+ | This type is problematical because mysql does not have any
+ | date/time types that store milliseconds. You should avoid it.
+ -->
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1454,6 +1464,10 @@
<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1463,9 +1477,8 @@
<mapping>
<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
- <sql-type>BIGINT</sql-type>
+ <sql-type>TIME</sql-type>
</mapping>
-
</type-mapping>
<type-mapping>
@@ -1559,9 +1572,13 @@
<sql-type>TINYINT</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Date</java-type>
@@ -1684,9 +1701,13 @@
</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>TIMESTAMP</sql-type>
+ <sql-type>DATETIME</sql-type>
</mapping>
<mapping>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 23:38:05
|
User: scoy
Date: 02/10/31 15:38:02
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fix for bug 619969 "SQL Server substring syntax is wrong".
Revision Changes Path
1.52 +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.51
retrieving revision 1.52
diff -u -r1.51 -r1.52
--- standardjbosscmp-jdbc.xml 31 Oct 2002 06:37:46 -0000 1.51
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 23:38:01 -0000 1.52
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.51 2002/10/31 06:37:46 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.52 2002/10/31 23:38:01 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1499,7 +1499,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
@@ -1625,7 +1625,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 23:39:15
|
User: scoy
Date: 02/10/31 15:39:14
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Fix for bug 619969 "SQL Server substring syntax is wrong".
Revision Changes Path
No revision
No revision
1.39.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.39.2.8
retrieving revision 1.39.2.9
diff -u -r1.39.2.8 -r1.39.2.9
--- standardjbosscmp-jdbc.xml 31 Oct 2002 05:27:42 -0000 1.39.2.8
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 23:39:14 -0000 1.39.2.9
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.8 2002/10/31 05:27:42 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.9 2002/10/31 23:39:14 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1499,7 +1499,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
@@ -1625,7 +1625,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
|
|
From: Stephen C. <sc...@us...> - 2002-10-31 23:40:18
|
User: scoy
Date: 02/10/31 15:40:17
Modified: src/etc/conf/default Tag: Branch_3_0
standardjbosscmp-jdbc.xml
Log:
Fix for bug 619969 "SQL Server substring syntax is wrong".
Revision Changes Path
No revision
No revision
1.23.2.23 +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.22
retrieving revision 1.23.2.23
diff -u -r1.23.2.22 -r1.23.2.23
--- standardjbosscmp-jdbc.xml 31 Oct 2002 02:30:26 -0000 1.23.2.22
+++ standardjbosscmp-jdbc.xml 31 Oct 2002 23:40:16 -0000 1.23.2.23
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.22 2002/10/31 02:30:26 scoy Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.23.2.23 2002/10/31 23:40:16 scoy Exp $ -->
<jbosscmp-jdbc>
@@ -1405,7 +1405,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
@@ -1531,7 +1531,7 @@
</function-mapping>
<function-mapping>
<function-name>substring</function-name>
- <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ <function-sql>substring(?1, ?2, ?3)</function-sql>
</function-mapping>
<function-mapping>
<function-name>lcase</function-name>
|
×
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