User: mulder
Date: 00/10/20 19:23:20
Modified: src/resources/dbtest/META-INF jaws.xml
Log:
Add DB2 mappings. You can't use "byte" variables, and you shouldn't
use extreme floats or doubles (or the driver dies).
Revision Changes Path
1.7 +71 -0 jbosstest/src/resources/dbtest/META-INF/jaws.xml
Index: jaws.xml
===================================================================
RCS file: /products/cvs/ejboss/jbosstest/src/resources/dbtest/META-INF/jaws.xml,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- jaws.xml 2000/10/20 16:22:53 1.6
+++ jaws.xml 2000/10/21 02:23:19 1.7
@@ -11,6 +11,77 @@
</default-entity>
<type-mappings>
<type-mapping>
+ <name>DB2</name>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
+ </mapping>
+<!-- DB2 does not appear to support columns of type "byte"
+ Regrettably, this means they'll be serialized.
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>CHAR</jdbc-type>
+ <sql-type>CHAR(1) FOR BIT DATA</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</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(254)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BLOB(2000)</sql-type>
+ </mapping>
+ </type-mapping>
+ <type-mapping>
<name>Oracle8</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
