User: mulder
Date: 00/10/19 12:56:34
Modified: src/resources/dbtest/META-INF ejb-jar.xml jaws.xml
Log:
- Add a variable of type Time
- Add checks for min/max values for numeric types. Many DBs cannot
accurately represent floats, doubles, or longs. This is not
considered to be a failure, since it's a limitation of the DB not
the jBoss configuration or JAWS mapping.
- Change "Oracle" mapping to "Oracle 7". There's an "Oracle 8" mapping
forthcoming. In 7, you can only have one serialized Java object
per table, since they map to DB type long. In 8, we may be able to
get around that.
Revision Changes Path
1.2 +4 -2 jbosstest/src/resources/dbtest/META-INF/ejb-jar.xml
Index: ejb-jar.xml
===================================================================
RCS file: /products/cvs/ejboss/jbosstest/src/resources/dbtest/META-INF/ejb-jar.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- ejb-jar.xml 2000/10/09 18:07:13 1.1
+++ ejb-jar.xml 2000/10/19 19:56:33 1.2
@@ -56,13 +56,15 @@
</cmp-field>
<cmp-field>
- <field-name>aTimestamp</field-name>
+ <field-name>aTime</field-name>
</cmp-field>
<cmp-field>
+ <field-name>aTimestamp</field-name>
+ </cmp-field>
+ <cmp-field>
<field-name>anObject</field-name>
</cmp-field>
-
<cmp-field>
<field-name>aList</field-name>
</cmp-field>
1.4 +68 -64 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.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- jaws.xml 2000/10/18 21:07:17 1.3
+++ jaws.xml 2000/10/19 19:56:34 1.4
@@ -6,12 +6,79 @@
<!-- Replace this with the type-mapping you want to use (choose one below) -->
<type-mapping>Hypersonic SQL</type-mapping>
-
<default-entity>
<remove-table>true</remove-table>
</default-entity>
<type-mappings>
<type-mapping>
+ <name>Oracle7</name>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>NUMBER(1)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>NUMBER(3)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>NUMERIC</jdbc-type>
+ <sql-type>NUMBER(5)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Integer</java-type>
+ <jdbc-type>INTEGER</jdbc-type>
+ <sql-type>NUMBER(10)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>NUMBER(38)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>REAL</jdbc-type>
+ <sql-type>NUMBER(38,7)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>NUMBER(38,15)</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(255)</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>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>LONG RAW</sql-type>
+ </mapping>
+ </type-mapping>
+ <type-mapping>
<name>Sybase</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -329,69 +396,6 @@
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
- </mapping>
- </type-mapping>
- <type-mapping>
- <name>Oracle</name>
- <mapping>
- <java-type>java.lang.Long</java-type>
- <jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMBER</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.Character</java-type>
- <jdbc-type>CHAR</jdbc-type>
- <sql-type>CHAR</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Short</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>NUMBER</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.Double</java-type>
- <jdbc-type>DOUBLE</jdbc-type>
- <sql-type>NUMBER</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>NUMBER</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Boolean</java-type>
- <jdbc-type>BIT</jdbc-type>
- <sql-type>NUMBER</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Float</java-type>
- <jdbc-type>FLOAT</jdbc-type>
- <sql-type>NUMBER</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>JAVA_OBJECT</sql-type>
- </mapping>
- <mapping>
- <java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Integer</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>NUMBER</sql-type>
</mapping>
</type-mapping>
<type-mapping>
