9:35 a.m.
Here my jboss.xml is
| <jboss>
| <enterprise-beans>
| <entity>
| <ejb-name>RaContactInfo</ejb-name>
| <entity-descriptor>
| <persistence>
| <persistence-use>
| <type-identifier>Jboss_CMP_JDBC</type-identifier>
| <type-version>6.0</type-version>
| <type-storage>META-INF/jbosscmp-jdbc.xml</type-storage>
| </persistence-use>
| </persistence>
| </entity-descriptor>
| <jndi-name>clh/ram/RaContactInfo</jndi-name>
| <local-jndi-name>clh/ram/RaContactInfoLocal</local-jndi-name>
| </entity>
| </enterprise-beans>
| </jboss>
|
My jbosscmp-jdbc.xml
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!DOCTYPE jbosscmp-jdbc PUBLIC
| "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN"
| "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd">
|
|
|
| <!-- ===================================================================== -->
| <!-- -->
| <!-- Standard JBossCMP-JDBC Configuration -->
| <!-- -->
| <!-- ===================================================================== -->
|
| <!-- $Id: jbosscmp-jdbc.xml,v 1.17 2008/04/10 11:22:15 swgen Exp $ -->
|
| <jbosscmp-jdbc>
|
| <defaults>
| <datasource>java:/RAM_DS</datasource>
| <datasource-mapping>Oracle8</datasource-mapping>
|
| <create-table>false</create-table>
| <remove-table>false</remove-table>
| <read-only>false</read-only>
| <read-time-out>300</read-time-out>
| <pk-constraint>true</pk-constraint>
| <fk-constraint>false</fk-constraint>
| <row-locking>false</row-locking>
|
<preferred-relation-mapping>foreign-key</preferred-relation-mapping>
| <read-ahead>
| <strategy>on-load</strategy>
| <page-size>1000</page-size>
| <eager-load-group>*</eager-load-group>
| </read-ahead>
| <list-cache-max>1000</list-cache-max>
| </defaults>
| <type-mapping>
| <name>Oracle8</name>
| <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR
UPDATE</row-locking-template>
| <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY
(?2)</pk-constraint-template>
| <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY
(?3) REFERENCES ?4 (?5)</fk-constraint-template>
| <alias-header-prefix>t</alias-header-prefix>
| <alias-header-suffix>_</alias-header-suffix>
| <alias-max-length>30</alias-max-length>
| <subquery-supported>true</subquery-supported>
| <true-mapping>1</true-mapping>
| <false-mapping>0</false-mapping>
|
| <function-mapping>
| <function-name>concat</function-name>
| <function-sql>(?1 || ?2)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>substring</function-name>
| <function-sql>substr(?1, ?2, ?3)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>lcase</function-name>
| <function-sql>lower(?1)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>length</function-name>
| <function-sql>length(?1)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>locate</function-name>
| <function-sql>instr(?2, ?1, ?3)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>abs</function-name>
| <function-sql>abs(?1)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>sqrt</function-name>
| <function-sql>sqrt(?1)</function-sql>
| </function-mapping>
| <function-mapping>
| <function-name>ucase</function-name>
| <function-sql>upper(?1)</function-sql>
| </function-mapping>
|
| <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>
| <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>
| <!--
| | Note that you lose granularity here
| | Use a numeric type and store milliseconds if you really need it
| -->
| <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>BLOB</jdbc-type>
| <sql-type>BLOB</sql-type>
| <!--
| | Change this from BLOB to RAW(n) if you know your
| | serialized object will be <= n bytes and n <= 2000
| -->
| </mapping>
| <enterprise-beans>
| <entity>
| <ejb-name>RaContactInfo</ejb-name>
| <table-name>RA_CONTACT_INFO</table-name>
| <cmp-field>
| <field-name>contactInfoId</field-name>
| <column-name>CONTACT_INFO_ID</column-name>
| </cmp-field>
|
| <cmp-field>
| <field-name>contactInfoName</field-name>
| <column-name>CONTACT_INFO_NAME</column-name>
| </cmp-field>
|
| <cmp-field>
| <field-name>roamingMngtAddrId</field-name>
| <column-name>ROAMING_MNGT_ADDR_ID</column-name>
| </cmp-field>
|
| <cmp-field>
| <field-name>interPmnInvoiceAddrId</field-name>
| <column-name>INTER_PMN_INVOICE_ADDR_ID</column-name>
| </cmp-field>
|
| <cmp-field>
| <field-name>custCareAddrId</field-name>
| <column-name>CUST_CARE_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>mktAddrId</field-name>
| <column-name>MKT_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>simAddrId</field-name>
| <column-name>SIM_ADDR_ID</column-name>
| <cmp-field>
| <cmp-field>
| <field-name>fraudMngtAddrId</field-name>
| </cmp-field>
| <cmp-field>
| <field-name>dataInterchangeAddrId</field-name>
| <column-name>DATA_INTERCHANGE_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>pmnAddrId</field-name>
| <column-name>PMN_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>tadigTestingAddrId</field-name>
| <column-name>TADIG_TESTING_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>iregTestingAddrId</field-name>
| <column-name>IREG_TESTING_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>mapSignallingAddrId</field-name>
| <column-name>MAP_SIGNALLING_ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>agreementMngt_AddrId</field-name>
| <column-name>AGREEMENT_MNGT__ADDR_ID</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>status</field-name>
| <column-name>STATUS</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>remarks</field-name>
| <column-name>REMARKS</column-name>
| </cmp-field>
| <cmp-field>
| <field-name>internationalRoamingAddrId</field-name>
| <column-name>INTERNATIONAL_ROAMING_ADDR_ID</column-name>
| </cmp-field>
| </cmp-field>
|
| </entity>
| </enterprise-beans>
| </jbosscmp-jdbc>
|
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200623#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...