1 Reply Latest reply on Sep 3, 2002 7:27 PM by dsundstrom

Question about OracleData Source mapping.

jakasjava Sep 3, 2002 1:14 PM

Hi all
I need help in configuring Oracle Data source and some CMP data mapping
The Standardjbosscmp-xml is as follows. I have modified to just have Oracle mappings. <Hope I am correct >
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc>









<jbosscmp-jdbc>

java:/jdbc.epeopleDS
<datasource-mapping>Oracle8</datasource-mapping>

<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<time-out>300</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>
on-load
<page-size>1000</page-size>
<eager-load-group>*</eager-load-group>
</read-ahead>
<list-cache-max>1000</list-cache-max>

<type-mappings>

<type-mapping>
Oracle9i

<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>len(?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>

<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>NUMBER(1)</sql-type>

<java-type>java.lang.Byte</java-type>
<jdbc-type>SMALLINT</jdbc-type>
<sql-type>NUMBER(3)</sql-type>

<java-type>java.lang.Short</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMBER(5)</sql-type>

<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER(10)</sql-type>

<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMBER(19)</sql-type>

<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
<sql-type>NUMBER(38,7)</sql-type>

<java-type>java.math.BigDecimal</java-type>
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>NUMBER(38,15)</sql-type>

<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>NUMBER(38,15)</sql-type>

<java-type>java.lang.Character</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>

<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR2(255)</sql-type>

<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP(3)</sql-type>

<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP(9)</sql-type>

<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>


</type-mapping>

<type-mapping>
Oracle8
<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>len(?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>

<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>NUMBER(1)</sql-type>

<java-type>java.lang.Byte</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMBER(3)</sql-type>

<java-type>java.lang.Short</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMBER(5)</sql-type>

<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER(10)</sql-type>

<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMBER(19)</sql-type>

<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
<sql-type>NUMBER(38,7)</sql-type>

<java-type>java.math.BigDecimal</java-type>
<jdbc-type>DECIMAL</jdbc-type>
<sql-type>NUMBER(38,15)</sql-type>

<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>NUMBER(38,15)</sql-type>

<java-type>java.lang.Character</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>

<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR2(255)</sql-type>


<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
<sql-type>DATE</sql-type>


<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.lang.Object</java-type>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>


</type-mapping>

<type-mapping>
Oracle7
<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>len(?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>

<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>NUMBER(1)</sql-type>

<java-type>java.lang.Byte</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMBER(3)</sql-type>

<java-type>java.lang.Short</java-type>
<jdbc-type>NUMERIC</jdbc-type>
<sql-type>NUMBER(5)</sql-type>

<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER(10)</sql-type>

<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMBER(19)</sql-type>

<java-type>java.lang.Float</java-type>
<jdbc-type>REAL</jdbc-type>
<sql-type>NUMBER(38,7)</sql-type>

<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>NUMBER(38,15)</sql-type>

<java-type>java.lang.Character</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>CHAR</sql-type>

<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR2(255)</sql-type>


<java-type>java.util.Date</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.sql.Time</java-type>
<jdbc-type>TIME</jdbc-type>
<sql-type>DATE</sql-type>


<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>

<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>LONG RAW</sql-type>


</type-mapping>

</type-mappings>
</jbosscmp-jdbc>

I have generated jbosscmp-jdbc.xml as follows
<?xml version="1.0" encoding="UTF-8"?>
<jbosscmp-jdbc><create-table>false</create-table><remove-table>false</remove-table><enterprise-beans><ejb-name>TheTroubleTicket</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTroubleTickets</table-name><cmp-field><field-name>iD</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>status</field-name><column-name>ticketstatus</column-name></cmp-field><cmp-field><field-name>closeReason</field-name><column-name>closereason</column-name></cmp-field><cmp-field><field-name>closedBy</field-name><column-name>closedby</column-name></cmp-field><cmp-field><field-name>createDate</field-name><column-name>ticketcreatedate</column-name></cmp-field><cmp-field><field-name>title</field-name><column-name>tickettitle</column-name></cmp-field><cmp-field><field-name>description</field-name><column-name>ticketproblemdescription</column-name></cmp-field><cmp-field><field-name>closeDate</field-name><column-name>closedate</column-name></cmp-field><cmp-field><field-name>lastModifiedDate</field-name><column-name>ticketlastmodifieddate</column-name></cmp-field><cmp-field><field-name>workspaceLastModifiedDate</field-name><column-name>workspacelastmodifieddate</column-name></cmp-field><cmp-field><field-name>resolutionEditDate</field-name><column-name>resolutioneditdate</column-name></cmp-field><cmp-field><field-name>customerID</field-name><column-name>customerid</column-name></cmp-field><cmp-field><field-name>submitterID</field-name><column-name>submitterid</column-name></cmp-field><cmp-field><field-name>userLevel</field-name><column-name>ticketuserlevel</column-name></cmp-field><cmp-field><field-name>installationID</field-name><column-name>installationid</column-name></cmp-field><cmp-field><field-name>customerLastReadDate</field-name><column-name>customerlastreaddate</column-name></cmp-field><cmp-field><field-name>customerLastTouchDate</field-name><column-name>customerlasttouchdate</column-name></cmp-field><cmp-field><field-name>userRejectAnswer</field-name><column-name>ticketuserrejectanswer</column-name></cmp-field><cmp-field><field-name>acceptTimeoutCount</field-name><column-name>ticketaccepttimeoutcount</column-name></cmp-field><cmp-field><field-name>paymentMethod</field-name><column-name>paymentMethod</column-name></cmp-field><cmp-field><field-name>payerType</field-name><column-name>payertype</column-name></cmp-field><cmp-field><field-name>payerID</field-name><column-name>payerid</column-name></cmp-field><cmp-field><field-name>ramID</field-name><column-name>ticketramid</column-name></cmp-field><cmp-field><field-name>priorityID</field-name><column-name>ticketpriority</column-name></cmp-field><cmp-field><field-name>fileSizeTotal</field-name><column-name>filesizetotal</column-name></cmp-field><cmp-field><field-name>fileCount</field-name><column-name>filecount</column-name></cmp-field><cmp-field><field-name>serviceNetworkID</field-name><column-name>servicenetworkid</column-name></cmp-field><cmp-field><field-name>serviceProfileID</field-name><column-name>serviceprofileid</column-name></cmp-field><cmp-field><field-name>matrixBasicID</field-name><column-name>matrixbasicid</column-name></cmp-field><cmp-field><field-name>currentTier</field-name><column-name>currenttier</column-name></cmp-field><cmp-field><field-name>committedCost</field-name><column-name>committedcost</column-name></cmp-field><cmp-field><field-name>skillIDRaw</field-name><column-name>skillid</column-name></cmp-field><cmp-field><field-name>oSID</field-name><column-name>osid</column-name></cmp-field><cmp-field><field-name>languageID</field-name><column-name>languageid</column-name></cmp-field><cmp-field><field-name>onSite</field-name><column-name>onsite</column-name></cmp-field><cmp-field><field-name>skillLevelOneID</field-name><column-name>skillleveloneid</column-name></cmp-field><cmp-field><field-name>upFrontChargeAuthorized</field-name><column-name>upfrontchargeauthorized</column-name></cmp-field><cmp-field><field-name>externalSourceTicketID</field-name><column-name>externalsourceticketid</column-name></cmp-field><cmp-field><field-name>sourceID</field-name><column-name>sourceid</column-name></cmp-field><cmp-field><field-name>applyGroupBilling</field-name><column-name>applygroupbilling</column-name></cmp-field><cmp-field><field-name>activeMainTCID</field-name><column-name>activemaintcid</column-name></cmp-field><cmp-field><field-name>firstPrimaryTCID</field-name><column-name>firstprimarytcid</column-name></cmp-field><cmp-field><field-name>firstAssignedPrimaryTCID</field-name><column-name>firstassignedprimarytcid</column-name></cmp-field><cmp-field><field-name>responseElapsedTime</field-name><column-name>responseelapsedtime</column-name></cmp-field><cmp-field><field-name>resolutionElapsedTime</field-name><column-name>resolutionelapsedtime</column-name></cmp-field><cmp-field><field-name>transactionTimestamp</field-name><column-name>transactiontimestamp</column-name></cmp-field><cmp-field><field-name>businessOrganizationID</field-name><column-name>businessorganizationid</column-name></cmp-field><ejb-name>TheTicketContract</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTicketContracts</table-name><cmp-field><field-name>iD</field-name><column-name>ticketcontractid</column-name></cmp-field><cmp-field><field-name>level</field-name><column-name>tclevel</column-name></cmp-field><cmp-field><field-name>type</field-name><column-name>tctype</column-name></cmp-field><cmp-field><field-name>controllerType</field-name><column-name>controllertype</column-name></cmp-field><cmp-field><field-name>controllerID</field-name><column-name>controllerid</column-name></cmp-field><cmp-field><field-name>status</field-name><column-name>status</column-name></cmp-field><cmp-field><field-name>closeReason</field-name><column-name>closereason</column-name></cmp-field><cmp-field><field-name>closedBy</field-name><column-name>closedby</column-name></cmp-field><cmp-field><field-name>createDate</field-name><column-name>createdate</column-name></cmp-field><cmp-field><field-name>lastModifiedDate</field-name><column-name>lastmodifieddate</column-name></cmp-field><cmp-field><field-name>closeDate</field-name><column-name>closedate</column-name></cmp-field><cmp-field><field-name>ticketID</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>serviceNetworkID</field-name><column-name>servicenetworkid</column-name></cmp-field><cmp-field><field-name>serviceProfileID</field-name><column-name>serviceprofileid</column-name></cmp-field><cmp-field><field-name>instantiatedTier</field-name><column-name>instantiatedtier</column-name></cmp-field><cmp-field><field-name>matrixBasicID</field-name><column-name>matrixbasicid</column-name></cmp-field><cmp-field><field-name>serviceContractID</field-name><column-name>servicecontractid</column-name></cmp-field><cmp-field><field-name>matchingStartDate</field-name><column-name>matchingstartdate</column-name></cmp-field><cmp-field><field-name>matchingCompleteDate</field-name><column-name>matchingcompletedate</column-name></cmp-field><cmp-field><field-name>matchingExpirationDate</field-name><column-name>matchingexpirationdate</column-name></cmp-field><cmp-field><field-name>matchTimeoutCount</field-name><column-name>matchtimeoutcount</column-name></cmp-field><cmp-field><field-name>matchingElapsedTime</field-name><column-name>matchingelapsedtime</column-name></cmp-field><cmp-field><field-name>isPrimaryProvider</field-name><column-name>isprimaryprovider</column-name></cmp-field><cmp-field><field-name>assigneeID</field-name><column-name>assigneeid</column-name></cmp-field><cmp-field><field-name>assigneeLastReadDate</field-name><column-name>assigneelastreaddate</column-name></cmp-field><cmp-field><field-name>assigneeLastTouchDate</field-name><column-name>assigneelasttouchdate</column-name></cmp-field><cmp-field><field-name>chargeAmount</field-name><column-name>chargeamount</column-name></cmp-field><cmp-field><field-name>paymentType</field-name><column-name>paymentType</column-name></cmp-field><cmp-field><field-name>payerType</field-name><column-name>payerType</column-name></cmp-field><cmp-field><field-name>payerID</field-name><column-name>payerid</column-name></cmp-field><cmp-field><field-name>feedbackLogID</field-name><column-name>feedbacklogid</column-name></cmp-field><cmp-field><field-name>serviceStartDate</field-name><column-name>servicestartdate</column-name></cmp-field><cmp-field><field-name>answerProposeDate</field-name><column-name>answerproposedate</column-name></cmp-field><cmp-field><field-name>answerAcceptanceDate</field-name><column-name>answeracceptancedate</column-name></cmp-field><cmp-field><field-name>serviceDeliveryDate</field-name><column-name>servicedeliverydate</column-name></cmp-field><cmp-field><field-name>deliveryElapsedTime</field-name><column-name>deliveryelapsedtime</column-name></cmp-field><cmp-field><field-name>mainTicketContractID</field-name><column-name>mainticketcontractid</column-name></cmp-field><cmp-field><field-name>primaryTicketContractID</field-name><column-name>primaryticketcontractid</column-name></cmp-field><cmp-field><field-name>crossNetworkLevel</field-name><column-name>crossnetworklevel</column-name></cmp-field><cmp-field><field-name>isSubLevelCrossNetwork</field-name><column-name>issublevelcrossnetwork</column-name></cmp-field><cmp-field><field-name>crossNetworkParentTCID</field-name><column-name>crossnetworkparenttcid</column-name></cmp-field><cmp-field><field-name>crossNetworkMainTCID</field-name><column-name>crossnetworkmaintcid</column-name></cmp-field><cmp-field><field-name>crossNetworkCurrentTier</field-name><column-name>crossnetworkcurrenttier</column-name></cmp-field><cmp-field><field-name>controllerInvitationLabel</field-name><column-name>controllerinvitationlabel</column-name></cmp-field><cmp-field><field-name>invitationType</field-name><column-name>invitationtype</column-name></cmp-field><cmp-field><field-name>emailInvitationAddress</field-name><column-name>emailinvitationaddress</column-name></cmp-field><cmp-field><field-name>emailInvitationID</field-name><column-name>emailinvitationid</column-name></cmp-field><cmp-field><field-name>invitationDate</field-name><column-name>invitationdate</column-name></cmp-field><cmp-field><field-name>invitedBy</field-name><column-name>invitedby</column-name></cmp-field><cmp-field><field-name>isUnderCollaboration</field-name><column-name>isundercollaboration</column-name></cmp-field><cmp-field><field-name>qualificationSetID</field-name><column-name>qualificationsetid</column-name></cmp-field><cmp-field><field-name>installationID</field-name><column-name>installationid</column-name></cmp-field><query-method>
<method-name>findByFlush</method-name>
<method-params>
</method-params>
</query-method><jboss-ql>FROM TicketContractBean AS tc WHERE 1=2</jboss-ql><ejb-name>ThePerson</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblPersons</table-name><cmp-field><field-name>iD</field-name><column-name>personid</column-name></cmp-field><cmp-field><field-name>personStatusRaw</field-name><column-name>personstatusid</column-name></cmp-field><cmp-field><field-name>firstNameRaw</field-name><column-name>personfirstname</column-name></cmp-field><cmp-field><field-name>middleNameRaw</field-name><column-name>personmiddlename</column-name></cmp-field><cmp-field><field-name>lastNameRaw</field-name><column-name>personlastname</column-name></cmp-field><cmp-field><field-name>emailAddressRaw</field-name><column-name>personemail</column-name></cmp-field><cmp-field><field-name>passwordRaw</field-name><column-name>personpassword</column-name></cmp-field><cmp-field><field-name>loginNameRaw</field-name><column-name>personusername</column-name></cmp-field><cmp-field><field-name>personCreatedDateRaw</field-name><column-name>personcreateddate</column-name></cmp-field><cmp-field><field-name>homePhoneRaw</field-name><column-name>personhomephone</column-name></cmp-field><cmp-field><field-name>officePhoneRaw</field-name><column-name>personofficephone</column-name></cmp-field><cmp-field><field-name>faxRaw</field-name><column-name>personfax</column-name></cmp-field><cmp-field><field-name>marketSourceRaw</field-name><column-name>personmarketsource</column-name></cmp-field><cmp-field><field-name>address1Raw</field-name><column-name>personaddress1</column-name></cmp-field><cmp-field><field-name>address2Raw</field-name><column-name>personaddress2</column-name></cmp-field><cmp-field><field-name>cityRaw</field-name><column-name>personcity</column-name></cmp-field><cmp-field><field-name>stateRaw</field-name><column-name>personstate</column-name></cmp-field><cmp-field><field-name>zIPRaw</field-name><column-name>personzip</column-name></cmp-field><cmp-field><field-name>countryIDRaw</field-name><column-name>personcountryid</column-name></cmp-field><cmp-field><field-name>lastLoginDate</field-name><column-name>personlastlogindate</column-name></cmp-field><cmp-field><field-name>lastPWModifiedDateRaw</field-name><column-name>personlastpwmodifieddate</column-name></cmp-field><cmp-field><field-name>timeLocale</field-name><column-name>persontimelocale</column-name></cmp-field><cmp-field><field-name>hintRaw</field-name><column-name>personhint</column-name></cmp-field><cmp-field><field-name>cookieSalt</field-name><column-name>personcookiesalt</column-name></cmp-field><cmp-field><field-name>emailVerifySalt</field-name><column-name>personemailverifysalt</column-name></cmp-field><cmp-field><field-name>passwordPepperRaw</field-name><column-name>personpasswordpepper</column-name></cmp-field><cmp-field><field-name>newsletterSubscription</field-name><column-name>personnewslettersubscription</column-name></cmp-field><cmp-field><field-name>ageVerified</field-name><column-name>personageverified</column-name></cmp-field><cmp-field><field-name>displayNameRaw</field-name><column-name>persondisplayname</column-name></cmp-field><cmp-field><field-name>emailIsLogin</field-name><column-name>personemailislogin</column-name></cmp-field><cmp-field><field-name>title</field-name><column-name>persontitle</column-name></cmp-field><cmp-field><field-name>changePassword</field-name><column-name>personchangepassword</column-name></cmp-field><cmp-field><field-name>homePhoneExtension</field-name><column-name>personhomephoneextension</column-name></cmp-field><cmp-field><field-name>officePhoneExtension</field-name><column-name>personofficephoneextension</column-name></cmp-field><cmp-field><field-name>techRating</field-name><column-name>techrating</column-name></cmp-field><cmp-field><field-name>techQuestionsAnswered</field-name><column-name>techquestionsanswered</column-name></cmp-field><cmp-field><field-name>certifications</field-name><column-name>techcertifications</column-name></cmp-field><cmp-field><field-name>techWebSite</field-name><column-name>techwebsite</column-name></cmp-field><cmp-field><field-name>techExperience</field-name><column-name>techexperience</column-name></cmp-field><cmp-field><field-name>techSpecialSkills</field-name><column-name>techspecialskills</column-name></cmp-field><cmp-field><field-name>techLegacyQuestions</field-name><column-name>techlegacyquestions</column-name></cmp-field><cmp-field><field-name>techNewsletterSubscription</field-name><column-name>technewslettersubscription</column-name></cmp-field><cmp-field><field-name>techBirthDate</field-name><column-name>techbirthdate</column-name></cmp-field><cmp-field><field-name>techCompanyNameRaw</field-name><column-name>techcompanyname</column-name></cmp-field><cmp-field><field-name>employeeID</field-name><column-name>personemployeeid</column-name></cmp-field><cmp-field><field-name>aestheticGroup</field-name><column-name>personastheticgroup</column-name></cmp-field><cmp-field><field-name>installationIDRaw</field-name><column-name>installationid</column-name></cmp-field><cmp-field><field-name>sSOEntityID</field-name><column-name>ssoentityid</column-name></cmp-field><cmp-field><field-name>permissionGroupID</field-name><column-name>permissiongroupid</column-name></cmp-field><cmp-field><field-name>permissionSetID</field-name><column-name>permissionsetid</column-name></cmp-field><ejb-name>TheTicketLogEntry</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTicketLogEntries2</table-name><cmp-field><field-name>iD</field-name><column-name>ticketlogentryid</column-name></cmp-field><cmp-field><field-name>type</field-name><column-name>ticketlogentrytype</column-name></cmp-field><cmp-field><field-name>personID</field-name><column-name>personid</column-name></cmp-field><cmp-field><field-name>ticketID</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>referenceRequestID</field-name><column-name>referencerequestid</column-name></cmp-field><cmp-field><field-name>timestamp</field-name><column-name>ticketlogentrytimestamp</column-name></cmp-field><cmp-field><field-name>startingTicketState</field-name><column-name>ticketlogentrystartstate</column-name></cmp-field><cmp-field><field-name>endingTicketState</field-name><column-name>ticketlogentryendstate</column-name></cmp-field><cmp-field><field-name>text</field-name><column-name>ticketlogentrytext</column-name></cmp-field><cmp-field><field-name>personType</field-name><column-name>persontype</column-name></cmp-field><cmp-field><field-name>visibility</field-name><column-name>visibility</column-name></cmp-field><cmp-field><field-name>entityType</field-name><column-name>entityType</column-name></cmp-field><cmp-field><field-name>contractID</field-name><column-name>ticketcontractid</column-name></cmp-field><query-method>
<method-name>findByTicketID</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method><jboss-ql>FROM TicketLogEntryBean AS tle WHERE tle.ticketID = ?1 ORDERBY tle.iD</jboss-ql><ejb-name>TheTicketLogEntryWriter</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTicketLogEntries2</table-name><cmp-field><field-name>iD</field-name><column-name>ticketlogentryid</column-name></cmp-field><cmp-field><field-name>type</field-name><column-name>ticketlogentrytype</column-name></cmp-field><cmp-field><field-name>personID</field-name><column-name>personid</column-name></cmp-field><cmp-field><field-name>ticketID</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>referenceRequestID</field-name><column-name>referencerequestid</column-name></cmp-field><cmp-field><field-name>timestamp</field-name><column-name>ticketlogentrytimestamp</column-name></cmp-field><cmp-field><field-name>startingTicketState</field-name><column-name>ticketlogentrystartstate</column-name></cmp-field><cmp-field><field-name>endingTicketState</field-name><column-name>ticketlogentryendstate</column-name></cmp-field><cmp-field><field-name>text</field-name><column-name>ticketlogentrytext</column-name></cmp-field><cmp-field><field-name>personType</field-name><column-name>persontype</column-name></cmp-field><cmp-field><field-name>visibility</field-name><column-name>visibility</column-name></cmp-field><cmp-field><field-name>entityType</field-name><column-name>entityType</column-name></cmp-field><cmp-field><field-name>contractID</field-name><column-name>ticketcontractid</column-name></cmp-field><ejb-name>TheNWTimer</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTimers</table-name><cmp-field><field-name>iD</field-name><column-name>timerid</column-name></cmp-field><cmp-field><field-name>status</field-name><column-name>timerstatus</column-name></cmp-field><cmp-field><field-name>ticketID</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>clusterID</field-name><column-name>clusterid</column-name></cmp-field><cmp-field><field-name>type</field-name><column-name>timertype</column-name></cmp-field><cmp-field><field-name>creationTime</field-name><column-name>timercreatedate</column-name></cmp-field><cmp-field><field-name>timeoutTime</field-name><column-name>timertimeoutdate</column-name></cmp-field><cmp-field><field-name>ticketContractID</field-name><column-name>ticketcontractid</column-name></cmp-field><ejb-name>TheTicketPayment</ejb-name>java:/jdbc.epeopleDS<datasource-mapping/><table-name>tblTicketPayments</table-name><cmp-field><field-name>iD</field-name><column-name>ticketpaymentid</column-name></cmp-field><cmp-field><field-name>ticketID</field-name><column-name>ticketid</column-name></cmp-field><cmp-field><field-name>ticketContractID</field-name><column-name>ticketcontractid</column-name></cmp-field><cmp-field><field-name>assigneeID</field-name><column-name>assigneeid</column-name></cmp-field><cmp-field><field-name>payeeID</field-name><column-name>payeeid</column-name></cmp-field><cmp-field><field-name>payeeType</field-name><column-name>payeetype</column-name></cmp-field><cmp-field><field-name>payerID</field-name><column-name>payerid</column-name></cmp-field><cmp-field><field-name>payerType</field-name><column-name>payertype</column-name></cmp-field><cmp-field><field-name>transactionType</field-name><column-name>transactiontype</column-name></cmp-field><cmp-field><field-name>tier</field-name><column-name>tier</column-name></cmp-field><cmp-field><field-name>amount</field-name><column-name>amount</column-name></cmp-field><cmp-field><field-name>statusRaw</field-name><column-name>status</column-name></cmp-field><cmp-field><field-name>totalCharge</field-name><column-name>totalcharge</column-name></cmp-field><cmp-field><field-name>createDate</field-name><column-name>createdate</column-name></cmp-field><cmp-field><field-name>lastModifiedDate</field-name><column-name>lastmodifieddate</column-name></cmp-field><ejb-name>TheCreditCard</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_CreditCard</table-name><cmp-field><field-name>iD</field-name><column-name>id</column-name></cmp-field><cmp-field><field-name>cardNo</field-name><column-name>card_no</column-name></cmp-field><cmp-field><field-name>expiryMonth</field-name><column-name>expiry_month</column-name></cmp-field><cmp-field><field-name>expiryYear</field-name><column-name>expiry_year</column-name></cmp-field><cmp-field><field-name>cardType</field-name><column-name>card_type</column-name></cmp-field><cmp-field><field-name>userID</field-name><column-name>user_id</column-name></cmp-field><cmp-field><field-name>onFile</field-name><column-name>onfile</column-name></cmp-field><cmp-field><field-name>status</field-name><column-name>status</column-name></cmp-field><cmp-field><field-name>counterCol</field-name><column-name>countercol</column-name></cmp-field><cmp-field><field-name>firstName</field-name><column-name>first_name</column-name></cmp-field><cmp-field><field-name>lastName</field-name><column-name>last_name</column-name></cmp-field><cmp-field><field-name>billAddrID</field-name><column-name>billaddr_id</column-name></cmp-field><cmp-field><field-name>shipAddrID</field-name><column-name>shipaddr_id</column-name></cmp-field><cmp-field><field-name>emailID</field-name><column-name>email_id</column-name></cmp-field><cmp-field><field-name>phoneNo</field-name><column-name>phone_no</column-name></cmp-field><cmp-field><field-name>entryDate</field-name><column-name>entry_date</column-name></cmp-field><ejb-name>TheAddress</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_Address</table-name><cmp-field><field-name>iD</field-name><column-name>id</column-name></cmp-field><cmp-field><field-name>line1</field-name><column-name>line1</column-name></cmp-field><cmp-field><field-name>line2</field-name><column-name>line2</column-name></cmp-field><cmp-field><field-name>city</field-name><column-name>city</column-name></cmp-field><cmp-field><field-name>state</field-name><column-name>state</column-name></cmp-field><cmp-field><field-name>zipCode</field-name><column-name>zipcode</column-name></cmp-field><cmp-field><field-name>country</field-name><column-name>country</column-name></cmp-field><ejb-name>TheGroupTransactionHistory</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_Group_Trans_History</table-name><cmp-field><field-name>iD</field-name><column-name>id</column-name></cmp-field><cmp-field><field-name>groupID</field-name><column-name>group_id</column-name></cmp-field><cmp-field><field-name>transType</field-name><column-name>trans_type</column-name></cmp-field><cmp-field><field-name>requestID</field-name><column-name>request_id</column-name></cmp-field><cmp-field><field-name>totAmount</field-name><column-name>tot_amount</column-name></cmp-field><cmp-field><field-name>transFlag</field-name><column-name>trans_flag</column-name></cmp-field><cmp-field><field-name>transMsg</field-name><column-name>trans_msg</column-name></cmp-field><cmp-field><field-name>authAuthCode</field-name><column-name>auth_auth_code</column-name></cmp-field><cmp-field><field-name>transDate</field-name><column-name>trans_date</column-name></cmp-field><ejb-name>TheTransactionHistory</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_Transaction_History</table-name><cmp-field><field-name>iD</field-name><column-name>id</column-name></cmp-field><cmp-field><field-name>serviceTicketID</field-name><column-name>serviceticket_id</column-name></cmp-field><cmp-field><field-name>serviceTypeID</field-name><column-name>servicetype_id</column-name></cmp-field><cmp-field><field-name>cardID</field-name><column-name>card_id</column-name></cmp-field><cmp-field><field-name>couponID</field-name><column-name>coupon_id</column-name></cmp-field><cmp-field><field-name>userGID</field-name><column-name>usergid</column-name></cmp-field><cmp-field><field-name>transType</field-name><column-name>trans_type</column-name></cmp-field><cmp-field><field-name>requestID</field-name><column-name>request_id</column-name></cmp-field><cmp-field><field-name>amount</field-name><column-name>amount</column-name></cmp-field><cmp-field><field-name>transFlag</field-name><column-name>trans_flag</column-name></cmp-field><cmp-field><field-name>transMsg</field-name><column-name>trans_msg</column-name></cmp-field><cmp-field><field-name>transDate</field-name><column-name>trans_date</column-name></cmp-field><ejb-name>TheTransactionPayee</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_Transaction_Payee</table-name><cmp-field><field-name>iD</field-name><column-name>id</column-name></cmp-field><cmp-field><field-name>serviceTicketID</field-name><column-name>serviceticket_id</column-name></cmp-field><cmp-field><field-name>serviceTypeID</field-name><column-name>servicetype_id</column-name></cmp-field><cmp-field><field-name>chargeType</field-name><column-name>charge_type</column-name></cmp-field><cmp-field><field-name>providerID</field-name><column-name>provider_id</column-name></cmp-field><cmp-field><field-name>groupID</field-name><column-name>group_id</column-name></cmp-field><cmp-field><field-name>amount</field-name><column-name>amount</column-name></cmp-field><cmp-field><field-name>payFlag</field-name><column-name>pay_flag</column-name></cmp-field><cmp-field><field-name>payDate</field-name><column-name>pay_date</column-name></cmp-field><cmp-field><field-name>tierNumber</field-name><column-name>tier_number</column-name></cmp-field><cmp-field><field-name>payType</field-name><column-name>pay_type</column-name></cmp-field><cmp-field><field-name>totalAmount</field-name><column-name>total_amount</column-name></cmp-field><cmp-field><field-name>migratedFlag</field-name><column-name>migrated_flag</column-name></cmp-field><cmp-field><field-name>ticketContractID</field-name><column-name>ticketcontractid</column-name></cmp-field><ejb-name>TheTransactionRecord</ejb-name>java:/jdbc.epeopleTPSDS<datasource-mapping/><table-name>nw_Transaction</table-name><cmp-field><field-name>serviceTicketID</field-name><column-name>serviceticket_id</column-name></cmp-field><cmp-field><field-name>serviceTypeID</field-name><column-name>servicetype_id</column-name></cmp-field><cmp-field><field-name>userID</field-name><column-name>user_id</column-name></cmp-field><cmp-field><field-name>amount</field-name><column-name>amount</column-name></cmp-field><cmp-field><field-name>authAmount</field-name><column-name>auth_amount</column-name></cmp-field><cmp-field><field-name>couponAmount</field-name><column-name>coupon_amount</column-name></cmp-field><cmp-field><field-name>authAuthCode</field-name><column-name>auth_auth_code</column-name></cmp-field><cmp-field><field-name>productCode</field-name><column-name>product_code</column-name></cmp-field><cmp-field><field-name>productName</field-name><column-name>product_name</column-name></cmp-field><cmp-field><field-name>merchantProdSKU</field-name><column-name>merchant_prodSKU</column-name></cmp-field><cmp-field><field-name>quantity</field-name><column-name>quantity</column-name></cmp-field><cmp-field><field-name>status</field-name><column-name>status</column-name></cmp-field><cmp-field><field-name>branded</field-name><column-name>branded</column-name></cmp-field><cmp-field><field-name>brandingFee</field-name><column-name>brandingfee</column-name></cmp-field><cmp-field><field-name>serviceContractID</field-name><column-name>servicecontractid</column-name></cmp-field><cmp-field><field-name>merchantDescriptor</field-name><column-name>merchant_descriptor</column-name></cmp-field><cmp-field><field-name>merchantPhoneNumber</field-name><column-name>merchant_phonenumber</column-name></cmp-field><cmp-field><field-name>cardID</field-name><column-name>card_id</column-name></cmp-field><cmp-field><field-name>userGID</field-name><column-name>usergid</column-name></cmp-field><cmp-field><field-name>lastTransDate</field-name><column-name>last_trans_date</column-name></cmp-field></enterprise-beans></jbosscmp-jdbc>

While deploying the application I get the following message

09:16:07,211 WARN [ServiceController] Problem starting service jboss.j2ee:servi
ce=EJB,jndiName=epeople/ticketpayment
org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml : datasourc
e-mapping jdbc.epeopleDS not found
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDB
CEntityMetaData.java:372)
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:237)
at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXm
lFileLoader.java:75)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaDat
a(JDBCStoreManager.java:677)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBC
StoreManager.java:389)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
r.java:339)

but in jndiview i can see jdbc.epeopleDS being bound.
Can any one help with this asap... pls....

thanks
sudhi

1. Re: Question about OracleData Source mapping.

dsundstrom Sep 3, 2002 7:27 PM (in response to jakasjava)

I can't say for sure, but that error message indicates that you have a datasouce-mapping element that contains "jdbc.epeopleDS", which is not the name of your datasource. Why are the datasouce-mapping elements empty? This may be causing your error.
Actions