Have you tried the mapping from the 'JBoss CMP Quick Start using JBoss 2.0 and
Oracle'? I am using Oracle, but all of my Entity Beans use BMP.
JBoss CMP Quick Start using JBoss 2.0 and Oracle
http://www.telkel.com/bugzilla/showattachment.cgi?attach_id=14
Here are the mappings from that document:
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>xa.MyConnectionPool</datasource>
<type-mapping>MyOracleTypeMapping</type-mapping>
<type-mappings>
<type-mapping>
<name>MyOracleTypeMapping</name>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</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>INTEGER</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>DOUBLE</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.Boolean</java-type>
<jdbc-type></jdbc-type>
<sql-type>BIT</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.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>INTEGER</sql-type>
</mapping>
</type-mapping>
</type-mappings>
<!-- This section provides optional object-to-relational mapping descriptions -->
<enterprise-beans>
<entity>
<ejb-name>MyMovieBean</ejb-name>
<table-name>MOVIE_TABLE</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>id</field-name>
<column-name>ID</column-name>
<sql-type>INTEGER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>title</field-name>
<column-name>MOVIE_TITLE</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>director</field-name>
<column-name>DIRECTOR</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
</entity>
</enterprise-beans>
</jaws>
- jeremiah
------Original Message------
From: Ingo Bruell <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: August 15, 2000 8:35:37 PM GMT
Subject: [jBoss-User] Oracle
Hi,
is here someone who uses Oracle for persitence storing of
EntityBeans ? Who can me post the correct mapping for Oracle 8.1.5 ?
so long
Ingo Bruell
---
<[EMAIL PROTECTED]>
<ICQ# 40377720>
Oldenburg PGP-Fingerprint: 9DD0 1776 DF4D 5B16 A532 C2A1 4701 EEA2
Germany PGP-Public-Key available at pgpkeys.mit.edu
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
