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#4200623 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4200623 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
