User: vharcq
Date: 01/06/19 02:32:58
Modified: src/resources/org/jboss/ejb/plugins/jaws/deployment
defaultjaws.xml
Log:
Sync defaultjaws.xml with standardjaws.xml (Thanks to Mike Swainston-Rainford).
Revision Changes Path
1.6 +789 -121
jboss/src/resources/org/jboss/ejb/plugins/jaws/deployment/defaultjaws.xml
Index: defaultjaws.xml
===================================================================
RCS file:
/cvsroot/jboss/jboss/src/resources/org/jboss/ejb/plugins/jaws/deployment/defaultjaws.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- defaultjaws.xml 2001/06/19 07:38:22 1.5
+++ defaultjaws.xml 2001/06/19 09:32:58 1.6
@@ -2,23 +2,110 @@
<jaws>
<type-mappings>
<type-mapping-definition>
- <name>PostgreSQL</name>
+ <name>InterBase</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type></jdbc-type>
- <sql-type>BIT</sql-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>SMALLINT</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.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
- <java-type>java.util.Date</java-type>
+ <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.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>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>VARCHAR(2000)</sql-type>
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <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>
@@ -29,41 +116,320 @@
<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>BLOB</jdbc-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>BLOB(2000)</sql-type>
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <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.math.BigDecimal</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>NUMBER(38,15)</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>
+<!-- Change this from BLOB to RAW(255) if you know your
+ serialized object will be <= 255 bytes -->
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <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(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>LONG RAW</sql-type>
+<!-- Change this from LONG RAW to RAW(255) if you know your
+ serialized object will be <= 255 bytes -->
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <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-definition>
+
+ <type-mapping-definition>
+ <name>PostgreSQL</name>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>INT2</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>INT2</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>TIMESTAMP</sql-type>
+ <java-type>java.lang.Short</java-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>INT2</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <sql-type>INT4</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>BIGINT</jdbc-type>
+ <sql-type>INT8</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <sql-type>FLOAT(7)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>FLOAT8</sql-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(256)</sql-type>
+ <sql-type>TEXT</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Long</java-type>
- <jdbc-type>BIGINT</jdbc-type>
- <sql-type>BIGINT</sql-type>
+ <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>OID</sql-type>
+ </mapping>
</type-mapping-definition>
+
<type-mapping-definition>
<name>InstantDB</name>
<mapping>
@@ -83,8 +449,8 @@
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>VARCHAR(5)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
@@ -122,17 +488,18 @@
<sql-type>LONGVARBINARY</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
+ <java-type>java.sql.Timestamp</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
</type-mapping-definition>
+
<type-mapping-definition>
<name>Hypersonic SQL</name>
<mapping>
<java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
@@ -156,8 +523,8 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
@@ -170,7 +537,7 @@
<sql-type>VARCHAR(256)</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
+ <java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
@@ -190,6 +557,7 @@
<sql-type>DOUBLE</sql-type>
</mapping>
</type-mapping-definition>
+
<type-mapping-definition>
<name>PointBase</name>
<mapping>
@@ -242,70 +610,8 @@
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
- </type-mapping-definition>
- <type-mapping-definition>
- <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-definition>
+
<type-mapping-definition>
<name>SOLID</name>
<mapping>
@@ -344,13 +650,13 @@
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
+ <java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type></jdbc-type>
+ <jdbc-type>BIT</jdbc-type>
<sql-type>BIT</sql-type>
</mapping>
<mapping>
@@ -369,6 +675,7 @@
<sql-type>DATE</sql-type>
</mapping>
</type-mapping-definition>
+
<type-mapping-definition>
<name>mySQL</name>
<mapping>
@@ -383,12 +690,12 @@
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type></jdbc-type>
- <sql-type>BIT</sql-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
- <jdbc-type>BLOB</jdbc-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>
<mapping>
@@ -398,11 +705,11 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <jdbc-type>SMALLINT</jdbc-type>
+ <sql-type>SMALLINT</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
+ <java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
@@ -424,14 +731,25 @@
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(256)</sql-type>
+ <sql-type>VARCHAR(255) BINARY</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-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>BIGINT</sql-type>
+ </mapping>
</type-mapping-definition>
+
<type-mapping-definition>
<name>MS SQLSERVER</name>
<mapping>
@@ -460,13 +778,18 @@
<sql-type>DECIMAL(20)</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>IMAGE</jdbc-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
<mapping>
@@ -475,13 +798,23 @@
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
- <java-type>java.sql.TimeStamp</java-type>
+ <java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</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>DATETIME</jdbc-type>
+ <jdbc-type>DATE</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
<mapping>
@@ -495,6 +828,101 @@
<sql-type>FLOAT</sql-type>
</mapping>
</type-mapping-definition>
+
+ <type-mapping-definition>
+ <name>MS SQLSERVER2000</name>
+
+ <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>JAVA_OBJECT</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>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</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>DATE</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-definition>
+
<type-mapping-definition>
<name>DB2/400</name>
<mapping>
@@ -507,11 +935,13 @@
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
</mapping>
+<!-- Apparent DB2/400 doesn't handle Byte type either
<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.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
@@ -530,7 +960,7 @@
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
- <sql-type>SMALLINT</sql-type>
+ <sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
@@ -539,7 +969,7 @@
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
- <jdbc-type>LONG</jdbc-type>
+ <jdbc-type>BIGINT</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
@@ -549,19 +979,257 @@
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
- <jdbc-type>SHORT</jdbc-type>
+ <jdbc-type>SMALLINT</jdbc-type>
<sql-type>SMALLINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>VARCHAR(4096) FOR BIT DATA</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <name>SapDB</name>
+ <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.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>JAVA_OBJECT</jdbc-type>
- <sql-type>VARGRAPHIC(16369)</sql-type>
+ <sql-type>LONG BYTE</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Byte</java-type>
+ <jdbc-type>TINYINT</jdbc-type>
+ <sql-type>CHAR BYTE</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.util.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.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>FIXED(1,0)</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Float</java-type>
+ <jdbc-type>FLOAT</jdbc-type>
+ <sql-type>FLOAT</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.Double</java-type>
+ <jdbc-type>DOUBLE</jdbc-type>
+ <sql-type>DOUBLE PRECISION</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Long</java-type>
+ <jdbc-type>DECIMAL</jdbc-type>
+ <sql-type>DECIMAL(20)</sql-type>
+ </mapping>
+ </type-mapping-definition>
+
+ <type-mapping-definition>
+ <name>Cloudscape</name>
+ <mapping>
+ <java-type>java.math.BigDecimal</java-type>
+ <jdbc-type>LONGVARCHAR</jdbc-type>
+ <sql-type>LONG VARCHAR</sql-type>
+ </mapping>
+ <mapping>
+ <java-type>java.lang.Boolean</java-type>
+ <jdbc-type>BIT</jdbc-type>
+ <sql-type>BOOLEAN</sql-type>
+ </mapping>
+ <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>BIGINT</jdbc-type>
+ <sql-type>LONGINT</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>LONGVARCHAR</jdbc-type>
+ <sql-type>LONG VARCHAR</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.TimeStamp</java-type>
+ <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>LONG VARBINARY</sql-type>
+ </mapping>
</type-mapping-definition>
+
+
+ <type-mapping-definition>
+ <name>InformixDB</name>
+ <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>DATE</jdbc-type>
+ <sql-type>DATE</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-definition>
+
</type-mappings>
</jaws>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
