User: mulder
Date: 00/10/20 09:22:54
Modified: src/resources/dbtest/META-INF jaws.xml
Log:
Updated PostgreSQL mappings. Just don't use a "long" that's out of
range!
Revision Changes Path
1.6 +42 -40 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.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- jaws.xml 2000/10/20 14:19:01 1.5
+++ jaws.xml 2000/10/20 16:22:53 1.6
@@ -76,6 +76,8 @@
<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>
<type-mapping>
@@ -144,6 +146,8 @@
<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>
<type-mapping>
@@ -216,75 +220,73 @@
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>IMAGE</sql-type>
</mapping>
-<!--
- <mapping>
- <java-type></java-type>
- <jdbc-type></jdbc-type>
- <sql-type></sql-type>
- </mapping>
--->
</type-mapping>
<type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
- <jdbc-type>BIT</jdbc-type>
- <sql-type>BOOL</sql-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.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.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</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(7)</sql-type>
+ </mapping>
+ <mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
- <sql-type>DOUBLE</sql-type>
+ <sql-type>FLOAT8</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.Object</java-type>
- <jdbc-type>BLOB</jdbc-type>
- <sql-type>BLOB</sql-type>
- </mapping>
- <mapping>
- <java-type>java.sql.TimeStamp</java-type>
- <jdbc-type>TIMESTAMP</jdbc-type>
- <sql-type>TIMESTAMP</sql-type>
+ <sql-type>CHAR(1)</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Integer</java-type>
- <jdbc-type>INTEGER</jdbc-type>
- <sql-type>INTEGER</sql-type>
+ <java-type>java.lang.String</java-type>
+ <jdbc-type>VARCHAR</jdbc-type>
+ <sql-type>TEXT</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Byte</java-type>
- <jdbc-type>TINYINT</jdbc-type>
- <sql-type>TINYINT</sql-type>
+ <java-type>java.sql.Date</java-type>
+ <jdbc-type>DATE</jdbc-type>
+ <sql-type>DATE</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Float</java-type>
- <jdbc-type>FLOAT</jdbc-type>
- <sql-type>FLOAT</sql-type>
+ <java-type>java.sql.Time</java-type>
+ <jdbc-type>TIME</jdbc-type>
+ <sql-type>TIME</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.String</java-type>
- <jdbc-type>VARCHAR</jdbc-type>
- <sql-type>VARCHAR(256)</sql-type>
+ <java-type>java.sql.Timestamp</java-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
- <java-type>java.lang.Long</java-type>
- <jdbc-type>BIGINT</jdbc-type>
- <sql-type>BIGINT</sql-type>
+ <java-type>java.lang.Object</java-type>
+ <jdbc-type>JAVA_OBJECT</jdbc-type>
+ <sql-type>OID</sql-type>
</mapping>
</type-mapping>
<type-mapping>
