Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Joachim V. d. A. <tri...@us...> - 2004-03-23 17:03:37
|
User: triathlon98
Date: 04/03/23 08:53:10
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Firebird/interbase mapping improvements
- correct alias-max-length
- make sure alter-table inserts default values in new fields
Revision Changes Path
No revision
No revision
1.39.2.42 +17 -20 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.41
retrieving revision 1.39.2.42
diff -u -r1.39.2.41 -r1.39.2.42
--- standardjbosscmp-jdbc.xml 6 Feb 2004 15:04:09 -0000 1.39.2.41
+++ standardjbosscmp-jdbc.xml 23 Mar 2004 16:53:09 -0000 1.39.2.42
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.41 2004/02/06 15:04:09 loubyansky Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.42 2004/03/23 16:53:09 triathlon98 Exp $ -->
<jbosscmp-jdbc>
@@ -393,15 +393,12 @@
<type-mapping>
<name>Firebird</name>
- <!-- For use with the Firebirdsql jca-jdbc driver.
- A version after Beta 1 is strongly recommended,
- this may involve building from cvs -->
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -414,37 +411,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -486,7 +483,7 @@
<fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
- <alias-max-length>32</alias-max-length>
+ <alias-max-length>31</alias-max-length>
<subquery-supported>true</subquery-supported>
<true-mapping>1</true-mapping>
<false-mapping>0</false-mapping>
@@ -499,37 +496,37 @@
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>SMALLINT</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>SMALLINT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INTEGER default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMERIC(18,0)</sql-type>
+ <sql-type>NUMERIC(18,0) default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE PRECISION</sql-type>
+ <sql-type>DOUBLE PRECISION default 0</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
|
