User: mulder
Date: 00/10/20 07:17:18
Modified: src/resources/org/jboss/ejb/plugins/jaws/metadata
standardjaws.xml
Log:
Add Oracle 8 support. Put the verified settings (Oracle, Sybase so far)
at the top of the file. Minor tweak to Oracle 7 settings (optimize
column size for longs).
Revision Changes Path
1.8 +140 -72
jboss/src/resources/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml
Index: standardjaws.xml
===================================================================
RCS file:
/products/cvs/ejboss/jboss/src/resources/org/jboss/ejb/plugins/jaws/metadata/standardjaws.xml,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- standardjaws.xml 2000/10/19 20:01:22 1.7
+++ standardjaws.xml 2000/10/20 14:17:18 1.8
@@ -13,6 +13,74 @@
<type-mappings>
<type-mapping>
+ <name>Oracle8</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(19)</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>BLOB</sql-type>
+ </mapping>
+ </type-mapping>
+ <type-mapping>
<name>Oracle7</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -37,7 +105,7 @@
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
- <sql-type>NUMBER(38)</sql-type>
+ <sql-type>NUMBER(19)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
@@ -81,6 +149,77 @@
</mapping>
</type-mapping>
<type-mapping>
+ <name>Sybase</name>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BIT</sql-type>
+ </mapping>
+<!-- Current Sybase JDBC drivers (jConnect 5.2) don't support
+ byte or short. Unfortunately they'll be serialized.
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</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>NUMERIC</jdbc-type>
+ <sql-type>NUMERIC(38,0)</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(255)</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>SMALLDATETIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>IMAGE</sql-type>
+ </mapping>
+ </type-mapping>
+ <type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
@@ -578,77 +717,6 @@
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
- </type-mapping>
- <type-mapping>
- <name>Sybase</name>
- <mapping>
- <java-type>java.lang.Boolean</java-type>
- <jdbc-type>BIT</jdbc-type>
- <sql-type>BIT</sql-type>
- </mapping>
-<!-- Current Sybase JDBC drivers (jConnect 5.2) don't support
- byte or short. Unfortunately they'll be serialized.
- <mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</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>NUMERIC</jdbc-type>
- <sql-type>NUMERIC(38,0)</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(255)</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>SMALLDATETIME</sql-type>
- </mapping>
- <mapping>
- <java-type>java.sql.Timestamp</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>DATETIME</sql-type>
- </mapping>
- <mapping>
- <java-type>java.lang.Object</java-type>
- <jdbc-type>JAVA_OBJECT</jdbc-type>
- <sql-type>IMAGE</sql-type>
- </mapping>
</type-mapping>
</type-mappings>
</jaws>
