Menu
▾
▴
jboss-cvs-commits
|
From: Ulf S. <sc...@us...> - 2004-09-02 08:27:16
|
User: schrouf
Date: 04/09/02 01:26:57
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Bugfix: changed InformixDB java.lang.object data type mapping to BLOB
Revision Changes Path
1.83 +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.82
retrieving revision 1.83
diff -u -r1.82 -r1.83
--- standardjbosscmp-jdbc.xml 21 Jul 2004 16:54:08 -0000 1.82
+++ standardjbosscmp-jdbc.xml 2 Sep 2004 08:26:57 -0000 1.83
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.82 2004/07/21 16:54:08 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.83 2004/09/02 08:26:57 schrouf Exp $ -->
<jbosscmp-jdbc>
@@ -2500,8 +2500,8 @@
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BYTE</sql-type>
+ <jdbc-type>BLOB</jdbc-type>
+ <sql-type>BLOB</sql-type>
</mapping>
</type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-09-15 15:49:06
|
User: loubyansky Date: 04/09/15 08:48:58 Modified: src/etc/conf/default standardjbosscmp-jdbc.xml Log: updated to 4.0 doctype and commented datasource-mapping Revision Changes Path 1.84 +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.83 retrieving revision 1.84 diff -u -r1.83 -r1.84 --- standardjbosscmp-jdbc.xml 2 Sep 2004 08:26:57 -0000 1.83 +++ standardjbosscmp-jdbc.xml 15 Sep 2004 15:48:58 -0000 1.84 @@ -1,7 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jbosscmp-jdbc PUBLIC - "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" - "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd"> + "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN" + "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd"> <!-- ===================================================================== --> <!-- --> @@ -9,13 +9,13 @@ <!-- --> <!-- ===================================================================== --> -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.83 2004/09/02 08:26:57 schrouf Exp $ --> +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84 2004/09/15 15:48:58 loubyansky Exp $ --> <jbosscmp-jdbc> <defaults> <datasource>java:/DefaultDS</datasource> - <datasource-mapping>@default.type.mapping@</datasource-mapping> + <!-- optional since 4.0 <datasource-mapping>@default.type.mapping@</datasource-mapping> --> <create-table>true</create-table> <remove-table>false</remove-table> |
|
From: Alexey L. <lou...@us...> - 2004-09-22 09:03:50
|
User: loubyansky
Date: 04/09/22 02:03:39
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added timestamp mapping for pointbase
Revision Changes Path
No revision
No revision
1.39.2.52 +6 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.51
retrieving revision 1.39.2.52
diff -u -r1.39.2.51 -r1.39.2.52
--- standardjbosscmp-jdbc.xml 2 Sep 2004 08:22:40 -0000 1.39.2.51
+++ standardjbosscmp-jdbc.xml 22 Sep 2004 09:03:37 -0000 1.39.2.52
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.51 2004/09/02 08:22:40 schrouf Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.52 2004/09/22 09:03:37 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1629,6 +1629,11 @@
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-09-22 09:04:29
|
User: loubyansky
Date: 04/09/22 02:04:23
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
added timestamp mapping for pointbase
Revision Changes Path
No revision
No revision
1.84.2.1 +6 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.84
retrieving revision 1.84.2.1
diff -u -r1.84 -r1.84.2.1
--- standardjbosscmp-jdbc.xml 15 Sep 2004 15:48:58 -0000 1.84
+++ standardjbosscmp-jdbc.xml 22 Sep 2004 09:04:22 -0000 1.84.2.1
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84 2004/09/15 15:48:58 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.1 2004/09/22 09:04:22 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1628,6 +1628,11 @@
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-09-22 09:05:11
|
User: loubyansky
Date: 04/09/22 02:04:53
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added timestamp mapping for pointbase
Revision Changes Path
1.85 +6 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.84
retrieving revision 1.85
diff -u -r1.84 -r1.85
--- standardjbosscmp-jdbc.xml 15 Sep 2004 15:48:58 -0000 1.84
+++ standardjbosscmp-jdbc.xml 22 Sep 2004 09:04:52 -0000 1.85
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84 2004/09/15 15:48:58 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.85 2004/09/22 09:04:52 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1628,6 +1628,11 @@
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
</type-mapping>
<type-mapping>
|
|
From: Alexey L. <lou...@us...> - 2004-11-02 12:19:37
|
User: loubyansky
Date: 04/11/02 04:19:30
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added pk-sql for jdbc2 pm
Revision Changes Path
No revision
No revision
1.39.2.53 +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.39.2.52
retrieving revision 1.39.2.53
diff -u -r1.39.2.52 -r1.39.2.53
--- standardjbosscmp-jdbc.xml 22 Sep 2004 09:03:37 -0000 1.39.2.52
+++ standardjbosscmp-jdbc.xml 2 Nov 2004 12:19:29 -0000 1.39.2.53
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.52 2004/09/22 09:03:37 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.53 2004/11/02 12:19:29 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -2677,6 +2677,13 @@
<!-- uses JDBC 3.0 getGeneratedKeys() method -->
<entity-command name="get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBC30GeneratedKeysCreateCommand"/>
+
+ <!-- pk-sql for jdbc2 pm -->
+ <entity-command name="jdbc2pm-pk-sql"
+ class="org.jboss.ejb.plugins.cmp.jdbc2.PkSqlCreateCommand">
+ <!-- change to define SQL used to obtain key prior to insert -->
+ <attribute name="pk-sql">SELECT CURRENT_TIMESTAMP</attribute>
+ </entity-command>
</entity-commands>
<!-- reserved words that should not be used as table names -->
|
|
From: Alexey L. <lou...@us...> - 2004-11-03 13:20:57
|
User: loubyansky
Date: 04/11/03 05:20:49
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
added Derby type-mapping
Revision Changes Path
No revision
No revision
1.39.2.54 +124 -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.53
retrieving revision 1.39.2.54
diff -u -r1.39.2.53 -r1.39.2.54
--- standardjbosscmp-jdbc.xml 2 Nov 2004 12:19:29 -0000 1.39.2.53
+++ standardjbosscmp-jdbc.xml 3 Nov 2004 13:20:48 -0000 1.39.2.54
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.53 2004/11/02 12:19:29 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.54 2004/11/03 13:20:48 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -663,6 +663,129 @@
</type-mapping>
<type-mapping>
+ <name>Derby</name>
+ <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>18</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>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substr</function-name>
+ <function-sql>substr(?1, ?2, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(?2, ?1, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>abs</function-name>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+<!-- if someone knows the mapping for byte, please, let us know!
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>SMALLINT</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>REAL</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>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(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>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>BLOB</jdbc-type>
+ <sql-type>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar
|
|
From: Alexey L. <lou...@us...> - 2004-11-03 13:32:23
|
User: loubyansky
Date: 04/11/03 05:32:16
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
added Derby type-mapping
Revision Changes Path
1.86 +124 -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.85
retrieving revision 1.86
diff -u -r1.85 -r1.86
--- standardjbosscmp-jdbc.xml 22 Sep 2004 09:04:52 -0000 1.85
+++ standardjbosscmp-jdbc.xml 3 Nov 2004 13:32:16 -0000 1.86
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.85 2004/09/22 09:04:52 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.86 2004/11/03 13:32:16 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -662,6 +662,129 @@
</type-mapping>
<type-mapping>
+ <name>Derby</name>
+ <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>18</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>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substr</function-name>
+ <function-sql>substr(?1, ?2, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(?2, ?1, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>abs</function-name>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+<!-- if someone knows the mapping for byte, please, let us know!
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>SMALLINT</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>REAL</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>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(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>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>BLOB</jdbc-type>
+ <sql-type>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar
|
|
From: Alexey L. <lou...@us...> - 2004-11-03 13:33:22
|
User: loubyansky
Date: 04/11/03 05:33:16
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
added Derby type-mapping
Revision Changes Path
No revision
No revision
1.84.2.2 +124 -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.84.2.1
retrieving revision 1.84.2.2
diff -u -r1.84.2.1 -r1.84.2.2
--- standardjbosscmp-jdbc.xml 22 Sep 2004 09:04:22 -0000 1.84.2.1
+++ standardjbosscmp-jdbc.xml 3 Nov 2004 13:33:15 -0000 1.84.2.2
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.1 2004/09/22 09:04:22 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.2 2004/11/03 13:33:15 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -662,6 +662,129 @@
</type-mapping>
<type-mapping>
+ <name>Derby</name>
+ <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>18</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>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substr</function-name>
+ <function-sql>substr(?1, ?2, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <function-sql>locate(?2, ?1, ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>abs</function-name>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>DECIMAL</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+<!-- if someone knows the mapping for byte, please, let us know!
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>SMALLINT</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>REAL</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>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(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>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>BLOB</jdbc-type>
+ <sql-type>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar
|
|
From: Ulf S. <sc...@us...> - 2004-11-05 15:58:03
|
User: schrouf
Date: 04/11/05 07:57:56
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Include <auto-increment-template> for InformixDB
Revision Changes Path
No revision
No revision
1.39.2.55 +2 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.54
retrieving revision 1.39.2.55
diff -u -r1.39.2.54 -r1.39.2.55
--- standardjbosscmp-jdbc.xml 3 Nov 2004 13:20:48 -0000 1.39.2.54
+++ standardjbosscmp-jdbc.xml 5 Nov 2004 15:57:55 -0000 1.39.2.55
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.54 2004/11/03 13:20:48 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.55 2004/11/05 15:57:55 schrouf Exp $ -->
<jbosscmp-jdbc>
@@ -2532,6 +2532,7 @@
<row-locking-template>select ?1 from ?2 where ?3 order by ?4 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>
+ <auto-increment-template>?1 serial(1)</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
|
|
From: Ulf S. <sc...@us...> - 2004-11-05 16:03:15
|
User: schrouf
Date: 04/11/05 08:03:07
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Include <auto-increment-template> for InformixDB
Revision Changes Path
1.87 +2 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.86
retrieving revision 1.87
diff -u -r1.86 -r1.87
--- standardjbosscmp-jdbc.xml 3 Nov 2004 13:32:16 -0000 1.86
+++ standardjbosscmp-jdbc.xml 5 Nov 2004 16:03:06 -0000 1.87
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.86 2004/11/03 13:32:16 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.87 2004/11/05 16:03:06 schrouf Exp $ -->
<jbosscmp-jdbc>
@@ -2530,6 +2530,7 @@
<row-locking-template>select ?1 from ?2 where ?3 order by ?4 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>
+ <auto-increment-template>?1 serial(1)</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
<alias-max-length>32</alias-max-length>
|
|
From: Alexey L. <lou...@us...> - 2004-11-12 14:32:08
|
User: loubyansky
Date: 04/11/12 06:32:00
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
ported pk-sql for jdbc2 pm from Branch_3_2
Revision Changes Path
No revision
No revision
1.84.2.3 +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.84.2.2
retrieving revision 1.84.2.3
diff -u -r1.84.2.2 -r1.84.2.3
--- standardjbosscmp-jdbc.xml 3 Nov 2004 13:33:15 -0000 1.84.2.2
+++ standardjbosscmp-jdbc.xml 12 Nov 2004 14:31:59 -0000 1.84.2.3
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.2 2004/11/03 13:33:15 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.3 2004/11/12 14:31:59 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -2798,6 +2798,13 @@
<!-- uses JDBC 3.0 getGeneratedKeys() method -->
<entity-command name="get-generated-keys"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBC30GeneratedKeysCreateCommand"/>
+
+ <!-- pk-sql for jdbc2 pm -->
+ <entity-command name="jdbc2pm-pk-sql"
+ class="org.jboss.ejb.plugins.cmp.jdbc2.PkSqlCreateCommand">
+ <!-- change to define SQL used to obtain key prior to insert -->
+ <attribute name="pk-sql">SELECT CURRENT_TIMESTAMP</attribute>
+ </entity-command>
</entity-commands>
<!-- reserved words that should not be used as table names -->
|
|
From: Scott M S. <st...@us...> - 2004-11-20 04:05:27
|
User: starksm
Date: 04/11/19 20:05:19
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
Applied patch [ 1029240 ] PostgreSQL 8.0 JDBC mapping from Juan Martinez.
Revision Changes Path
No revision
No revision
1.84.2.4 +128 -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.84.2.3
retrieving revision 1.84.2.4
diff -u -r1.84.2.3 -r1.84.2.4
--- standardjbosscmp-jdbc.xml 12 Nov 2004 14:31:59 -0000 1.84.2.3
+++ standardjbosscmp-jdbc.xml 20 Nov 2004 04:05:18 -0000 1.84.2.4
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.3 2004/11/12 14:31:59 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.4 2004/11/20 04:05:18 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -1415,6 +1415,133 @@
</type-mapping>
<type-mapping>
+ <name>PostgreSQL 8.0</name>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
+ <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <auto-increment-template>?1</auto-increment-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>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>concat</function-name>
+ <function-sql>(?1 || ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substring</function-name>
+ <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <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>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BOOLEAN</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INT4</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>INT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>FLOAT</jdbc-type>
+ <sql-type>FLOAT(7)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>FLOAT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR(1)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>TEXT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</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.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>NUMERIC</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>PostgreSQL 7.2</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
|
|
From: Scott M S. <st...@us...> - 2004-11-20 04:07:24
|
User: starksm
Date: 04/11/19 20:07:12
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Applied patch [ 1029240 ] PostgreSQL 8.0 JDBC mapping from Juan Martinez.
Revision Changes Path
1.88 +128 -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.87
retrieving revision 1.88
diff -u -r1.87 -r1.88
--- standardjbosscmp-jdbc.xml 5 Nov 2004 16:03:06 -0000 1.87
+++ standardjbosscmp-jdbc.xml 20 Nov 2004 04:07:12 -0000 1.88
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.87 2004/11/05 16:03:06 schrouf Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.88 2004/11/20 04:07:12 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -1415,6 +1415,133 @@
</type-mapping>
<type-mapping>
+ <name>PostgreSQL 8.0</name>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
+ <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <auto-increment-template>?1</auto-increment-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>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>concat</function-name>
+ <function-sql>(?1 || ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substring</function-name>
+ <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <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>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BOOLEAN</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INT4</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>INT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>FLOAT</jdbc-type>
+ <sql-type>FLOAT(7)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>FLOAT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR(1)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>TEXT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</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.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>NUMERIC</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>PostgreSQL 7.2</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
|
|
From: Noel R. <noe...@us...> - 2005-01-05 10:56:41
|
User: noelrocher
Date: 05/01/05 02:56:31
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Add support for new option <throw-runtime-exceptions> in cmp defaults
Revision Changes Path
No revision
No revision
1.39.2.56 +2 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.55
retrieving revision 1.39.2.56
diff -u -r1.39.2.55 -r1.39.2.56
--- standardjbosscmp-jdbc.xml 5 Nov 2004 15:57:55 -0000 1.39.2.55
+++ standardjbosscmp-jdbc.xml 5 Jan 2005 10:56:30 -0000 1.39.2.56
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.55 2004/11/05 15:57:55 schrouf Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.56 2005/01/05 10:56:30 noelrocher Exp $ -->
<jbosscmp-jdbc>
@@ -42,6 +42,7 @@
<entity-command name="default"/>
<ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler>
+ <throw-runtime-exceptions>false</throw-runtime-exceptions>
</defaults>
<type-mappings>
|
|
From: Noel R. <noe...@us...> - 2005-01-06 12:26:31
|
User: noelrocher
Date: 05/01/06 04:26:25
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
Add support for new option <throw-runtime-exceptions> in cmp defaults
Revision Changes Path
No revision
No revision
1.84.2.5 +2 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.84.2.4
retrieving revision 1.84.2.5
diff -u -r1.84.2.4 -r1.84.2.5
--- standardjbosscmp-jdbc.xml 20 Nov 2004 04:05:18 -0000 1.84.2.4
+++ standardjbosscmp-jdbc.xml 6 Jan 2005 12:26:23 -0000 1.84.2.5
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.4 2004/11/20 04:05:18 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.5 2005/01/06 12:26:23 noelrocher Exp $ -->
<jbosscmp-jdbc>
@@ -42,6 +42,7 @@
<entity-command name="default"/>
<ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler>
+ <throw-runtime-exceptions>false</throw-runtime-exceptions>
</defaults>
<type-mappings>
|
|
From: Noel R. <noe...@us...> - 2005-01-06 14:46:53
|
User: noelrocher
Date: 05/01/06 06:46:47
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Add support for new option <throw-runtime-exceptions> in cmp defaults
Revision Changes Path
1.89 +2 -1 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.88
retrieving revision 1.89
diff -u -r1.88 -r1.89
--- standardjbosscmp-jdbc.xml 20 Nov 2004 04:07:12 -0000 1.88
+++ standardjbosscmp-jdbc.xml 6 Jan 2005 14:46:46 -0000 1.89
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.88 2004/11/20 04:07:12 starksm Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.89 2005/01/06 14:46:46 noelrocher Exp $ -->
<jbosscmp-jdbc>
@@ -42,6 +42,7 @@
<entity-command name="default"/>
<ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler>
+ <throw-runtime-exceptions>false</throw-runtime-exceptions>
</defaults>
<type-mappings>
|
|
From: Scott M S. <st...@us...> - 2005-01-26 01:17:17
|
User: starksm
Date: 05/01/25 17:16:59
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Integrate the Oracle Sequence Create Command (one sequence per table) from Guillaume Compagnon defined in JBAS-810.
Revision Changes Path
1.90 +7 -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.89
retrieving revision 1.90
diff -u -r1.89 -r1.90
--- standardjbosscmp-jdbc.xml 6 Jan 2005 14:46:46 -0000 1.89
+++ standardjbosscmp-jdbc.xml 26 Jan 2005 01:16:30 -0000 1.90
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.89 2005/01/06 14:46:46 noelrocher Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.90 2005/01/26 01:16:30 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -2882,6 +2882,12 @@
<attribute name="sequence">TEST_SEQUENCE</attribute>
</entity-command>
+ <!-- this command makes the use of a specific sequence for each table -->
+ <entity-command name="oracle-table-sequence"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleSequenceCreateCommand">
+ <attribute name="sequence_name">%%t_seq</attribute>
+ </entity-command>
+
<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCHsqldbCreateCommand">
|
|
From: Scott M S. <st...@us...> - 2005-01-26 01:40:52
|
User: starksm
Date: 05/01/25 17:40:27
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Integrate the Oracle Sequence Create Command (one sequence per table) from Guillaume Compagnon defined in JBAS-810.
Revision Changes Path
No revision
No revision
1.39.2.57 +134 -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.56
retrieving revision 1.39.2.57
diff -u -r1.39.2.56 -r1.39.2.57
--- standardjbosscmp-jdbc.xml 5 Jan 2005 10:56:30 -0000 1.39.2.56
+++ standardjbosscmp-jdbc.xml 26 Jan 2005 01:40:22 -0000 1.39.2.57
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.56 2005/01/05 10:56:30 noelrocher Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.57 2005/01/26 01:40:22 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -1417,6 +1417,133 @@
</type-mapping>
<type-mapping>
+ <name>PostgreSQL 8.0</name>
+ <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
+ <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <auto-increment-template>?1</auto-increment-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>TRUE</true-mapping>
+ <false-mapping>FALSE</false-mapping>
+
+ <function-mapping>
+ <function-name>concat</function-name>
+ <function-sql>(?1 || ?2)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>substring</function-name>
+ <function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>lcase</function-name>
+ <function-sql>lower(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>length</function-name>
+ <function-sql>length(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>locate</function-name>
+ <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>
+ <function-sql>abs(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>sqrt</function-name>
+ <function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>ucase</function-name>
+ <function-sql>upper(?1)</function-sql>
+ </function-mapping>
+ <function-mapping>
+ <function-name>count</function-name>
+ <function-sql>count(?1)</function-sql>
+ </function-mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BOOLEAN</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INT4</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>INT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>FLOAT</jdbc-type>
+ <sql-type>FLOAT(7)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>FLOAT8</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR(1)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>TEXT</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</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.math.BigDecimal</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>NUMERIC</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>VARBINARY</jdbc-type>
+ <sql-type>BYTEA</sql-type>
+ </mapping>
+ </type-mapping>
+
+ <type-mapping>
<name>PostgreSQL 7.2</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
@@ -2757,6 +2884,12 @@
<attribute name="sequence">TEST_SEQUENCE</attribute>
</entity-command>
+ <!-- this command makes the use of a specific sequence for each table -->
+ <entity-command name="oracle-table-sequence"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleSequenceCreateCommand">
+ <attribute name="sequence_name">%%t_seq</attribute>
+ </entity-command>
+
<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCHsqldbCreateCommand">
|
|
From: Scott M S. <st...@us...> - 2005-01-26 18:51:46
|
User: starksm
Date: 05/01/26 10:51:39
Modified: src/etc/conf/default Tag: Branch_4_0
standardjbosscmp-jdbc.xml
Log:
Integrate the Oracle Sequence Create Command (one sequence per table) from Guillaume Compagnon defined in JBAS-810.
Revision Changes Path
No revision
No revision
1.84.2.6 +7 -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.84.2.5
retrieving revision 1.84.2.6
diff -u -r1.84.2.5 -r1.84.2.6
--- standardjbosscmp-jdbc.xml 6 Jan 2005 12:26:23 -0000 1.84.2.5
+++ standardjbosscmp-jdbc.xml 26 Jan 2005 18:51:35 -0000 1.84.2.6
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.5 2005/01/06 12:26:23 noelrocher Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.84.2.6 2005/01/26 18:51:35 starksm Exp $ -->
<jbosscmp-jdbc>
@@ -2881,6 +2881,12 @@
<attribute name="sequence">TEST_SEQUENCE</attribute>
</entity-command>
+ <!-- this command makes the use of a specific sequence for each table -->
+ <entity-command name="oracle-table-sequence"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleSequenceCreateCommand">
+ <attribute name="sequence_name">%%t_seq</attribute>
+ </entity-command>
+
<!-- retrieves generated key of the record inserted into hsql db -->
<entity-command name="hsqldb-fetch-key"
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCHsqldbCreateCommand">
|
×
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