Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Jeremy B. <jb...@us...> - 2003-05-10 18:07:54
|
User: jboynes
Date: 03/05/10 11:07:53
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Support for PostgreSQL serial columns with no driver dependencies
Simplified initialization
Revision Changes Path
No revision
No revision
1.39.2.17 +280 -270 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.16
retrieving revision 1.39.2.17
diff -u -r1.39.2.16 -r1.39.2.17
--- standardjbosscmp-jdbc.xml 7 May 2003 05:43:44 -0000 1.39.2.16
+++ standardjbosscmp-jdbc.xml 10 May 2003 18:07:52 -0000 1.39.2.17
@@ -7,14 +7,14 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.16 2003/05/07 05:43:44 jboynes Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.17 2003/05/10 18:07:52 jboynes Exp $ -->
<jbosscmp-jdbc>
-
+
<defaults>
<datasource>java:/DefaultDS</datasource>
<datasource-mapping>@default.type.mapping@</datasource-mapping>
-
+
<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
@@ -123,8 +123,8 @@
<type-mapping>
<name>Firebird</name>
- <!-- For use with the Firebirdsql jca-jdbc driver.
- A version after Beta 1 is strongly recommended,
+ <!-- For use with the Firebirdsql jca-jdbc driver.
+ A version after Beta 1 is strongly recommended,
this may involve building from cvs -->
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
@@ -369,7 +369,7 @@
<name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar
- | or you will suffer
+ | or you will suffer
-->
<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>
@@ -384,35 +384,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -510,35 +510,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -644,35 +644,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substr(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>instr(?2, ?1, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -846,6 +846,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 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>
@@ -856,36 +857,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>(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-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -968,6 +969,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 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>
@@ -978,36 +980,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>(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-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(CAST(?1 AS double precision))</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>CHAR</jdbc-type>
@@ -1087,7 +1089,7 @@
<type-mapping>
<name>Hypersonic SQL</name>
- <row-locking-template/>
+ <row-locking-template/>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template/>
<auto-increment-template>?1 IDENTITY</auto-increment-template>
@@ -1101,35 +1103,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 || ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>SUBSTRING(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lcase(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>LENGTH(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>LOCATE(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>ABS(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>SQRT(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>ucase(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
@@ -1224,7 +1226,7 @@
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
@@ -1372,35 +1374,35 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>concat(?1, ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1 FROM ?2 FOR ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>length(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>locate(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<mapping>
<java-type>java.lang.Float</java-type>
@@ -1446,7 +1448,7 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
<!--
- | This type is problematical because mysql does not have any
+ | This type is problematical because mysql does not have any
| date/time types that store milliseconds. You should avoid it.
-->
</mapping>
@@ -1507,36 +1509,36 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>len(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>charindex(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
+ </function-mapping>
+
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
@@ -1618,8 +1620,8 @@
</mapping>
</type-mapping>
- <type-mapping>
- <name>MS SQLSERVER2000</name>
+ <type-mapping>
+ <name>MS SQLSERVER2000</name>
<row-locking-template>SELECT ?1 FROM ?2 with (rowlock) WHERE ?3</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>
@@ -1634,131 +1636,131 @@
<function-mapping>
<function-name>concat</function-name>
<function-sql>(?1 + ?2)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>substring</function-name>
<function-sql>substring(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>lcase</function-name>
<function-sql>lower(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>length</function-name>
<function-sql>len(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>locate</function-name>
<function-sql>charindex(?1, ?2, ?3)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>abs</function-name>
<function-sql>abs(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>sqrt</function-name>
<function-sql>sqrt(?1)</function-sql>
- </function-mapping>
+ </function-mapping>
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
- </function-mapping>
-
- <mapping>
- <java-type>java.lang.Integer</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</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.Short</java-type>
- <jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</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.math.BigDecimal</java-type>
- <jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(256)</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.lang.Object</java-type>
- <jdbc-type>LONGVARBINARY</jdbc-type>
- <sql-type>IMAGE</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
- </mapping>
-
- <mapping>
+ </function-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.Character</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR</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.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>BIGINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(256)</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.lang.Object</java-type>
+ <jdbc-type>LONGVARBINARY</jdbc-type>
+ <sql-type>IMAGE</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <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>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.sql.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.sql.Time</java-type>
- <jdbc-type>TIME</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.util.Date</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Boolean</java-type>
- <jdbc-type>BIT</jdbc-type>
- <sql-type>BIT</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>FLOAT</sql-type>
- </mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BIT</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>FLOAT</sql-type>
+ </mapping>
</type-mapping>
-
+
<type-mapping>
<name>DB2/400</name>
<row-locking-template/>
@@ -2003,9 +2005,9 @@
</mapping>
</type-mapping>
-
- <type-mapping>
- <name>InformixDB</name>
+
+ <type-mapping>
+ <name>InformixDB</name>
<row-locking-template>select ?1 from ?2 where ?3 for update</row-locking-template>
<pk-constraint-template>PRIMARY KEY (?2) CONSTRAINT ?1</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT FOREIGN KEY (?3) REFERENCES ?4 (?5) CONSTRAINT ?2</fk-constraint-template>
@@ -2016,96 +2018,96 @@
<true-mapping>1</true-mapping>
<false-mapping>0</false-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>VARCHAR(255,0)</sql-type>
- </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>SMALLINT</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Integer</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Long</java-type>
- <jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Float</java-type>
- <jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Double</java-type>
- <jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.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.util.Date</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME YEAR TO FRACTION(3)</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>DATETIME YEAR TO FRACTION(3)</sql-type>
- </mapping>
-
- <mapping>
- <java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>BYTE</sql-type>
- </mapping>
- </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>VARCHAR(255,0)</sql-type>
+ </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>SMALLINT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>INTEGER</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>NUMERIC(18,0)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>FLOAT</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.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.util.Date</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME YEAR TO FRACTION(3)</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>DATETIME YEAR TO FRACTION(3)</sql-type>
+ </mapping>
+
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BYTE</sql-type>
+ </mapping>
+ </type-mapping>
</type-mappings>
@@ -2162,6 +2164,14 @@
class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCInformixCreateCommand">
<!-- uncomment to use with SERIAL8 column
<attribute name="method">getSerial8</attribute>
+ -->
+ </entity-command>
+
+ <!-- retrieves the currval of the the sequence associated with a PostgreSQL SERIAL column -->
+ <entity-command name="postgresql-fetch-seq"
+ class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCPostgreSQLCreateCommand">
+ <!-- uncomment to change the name of the sequence; default is ${table}_${pkColumn}_seq
+ <attribute name="sequence"></attribute>
-->
</entity-command>
|
