In the actual Oracle databse the coulumn names are county_nbr and district_nbr. The orion-ejb-jar.xml shown below should translate the cmp-field-mapping name to the persistence-name. I placed this file next to the ejb-jar.xml file in the META-INF folder.
<?xml version = '1.0' encoding = 'windows-1252'?> <!DOCTYPE orion-ejb-jar PUBLIC "-//Evermind//DTD Enterprise JavaBeans 1.1 runtime//EN" "http://xmlns.oracle.com/ias/dtds/orion-ejb-jar.dtd";> <orion-ejb-jar> <enterprise-beans> <session-deployment name="SessionEJB"/> <entity-deployment name="District" data-source="jdbc/PlutoDS" table="PLUTO.DISTRICT"> <primkey-mapping> <cmp-field-mapping> <cmp-field-mapping name="countyNbr" persistence-name="COUNTY_NBR" persistence-type="CHAR(2)"/> <cmp-field-mapping name="districtNbr" persistence-name="DISTRICT_NBR" persistence-type="CHAR(2)"/> </cmp-field-mapping> </primkey-mapping> <cmp-field-mapping name="countyNbr" persistence-name="COUNTY_NBR" persistence-type="CHAR(2)"/> <cmp-field-mapping name="districtNbr" persistence-name="DISTRICT_NBR" persistence-type="CHAR(2)"/> <cmp-field-mapping name="districtName" persistence-name="DISTRICT_NAME" persistence-type="VARCHAR2(50)"/> <cmp-field-mapping name="districtAddr" persistence-name="DISTRICT_ADDR" persistence-type="VARCHAR2(50)"/> <cmp-field-mapping name="districtCity" persistence-name="DISTRICT_CITY" persistence-type="VARCHAR2(50)"/> <cmp-field-mapping name="districtState" persistence-name="DISTRICT_STATE" persistence-type="CHAR(2)"/> <cmp-field-mapping name="districtZipCode" persistence-name="DISTRICT_ZIP_CODE" persistence-type="CHAR(9)"/> <cmp-field-mapping name="districtAreaCode" persistence-name="DISTRICT_AREA_CODE" persistence-type="CHAR(3)"/> <cmp-field-mapping name="districtPhNbr" persistence-name="DISTRICT_PH_NBR" persistence-type="CHAR(7)"/> <cmp-field-mapping name="ficaId" persistence-name="FICA_ID" persistence-type="NUMBER(9)"/> <cmp-field-mapping name="unempInsId" persistence-name="UNEMP_INS_ID" persistence-type="NUMBER(9)"/> <cmp-field-mapping name="stateEmprId" persistence-name="STATE_EMPR_ID" persistence-type="NUMBER(5)"/> <cmp-field-mapping name="hideShowMgmtCodeFlag" persistence-name="HIDE_SHOW_MGMT_CODE_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="validateSacsAcctFlag" persistence-name="VALIDATE_SACS_ACCT_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="altFicaEmprPct" persistence-name="ALT_FICA_EMPR_PCT" persistence-type="NUMBER(11,6)"/> <cmp-field-mapping name="altFicaEmpPct" persistence-name="ALT_FICA_EMP_PCT" persistence-type="NUMBER(11,6)"/> <cmp-field-mapping name="altFicaVendorNbr" persistence-name="ALT_FICA_VENDOR_NBR" persistence-type="NUMBER(5)"/> <cmp-field-mapping name="workerCompRate" persistence-name="WORKER_COMP_RATE" persistence-type="NUMBER(11,6)"/> <cmp-field-mapping name="workHoursPerMonth" persistence-name="WORK_HOURS_PER_MONTH" persistence-type="NUMBER(11,2)"/> <cmp-field-mapping name="encumbNewFiscalYearFlag" persistence-name="ENCUMB_NEW_FISCAL_YEAR_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="accrualFlag" persistence-name="ACCRUAL_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="updateUserid" persistence-name="UPDATE_USERID" persistence-type="CHAR(10)"/> <cmp-field-mapping name="updateTimestamp" persistence-name="UPDATE_TIMESTAMP" persistence-type="DATE"/> <cmp-field-mapping name="taxpayerIdNbr" persistence-name="TAXPAYER_ID_NBR" persistence-type="NUMBER(9)"/> <cmp-field-mapping name="contact1099PhAreaCode" persistence-name="CONTACT_1099_PH_AREA_CODE" persistence-type="CHAR(3)"/> <cmp-field-mapping name="contact1099PhNbr" persistence-name="CONTACT_1099_PH_NBR" persistence-type="CHAR(7)"/> <cmp-field-mapping name="contactW2PhAreaCode" persistence-name="CONTACT_W2_PH_AREA_CODE" persistence-type="CHAR(3)"/> <cmp-field-mapping name="contactW2PhNbr" persistence-name="CONTACT_W2_PH_NBR" persistence-type="CHAR(7)"/> <cmp-field-mapping name="useDistrict1099TinFlag" persistence-name="USE_DISTRICT_1099_TIN_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="useDistrictW2TinFlag" persistence-name="USE_DISTRICT_W2_TIN_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="finTrnsfrApprovalReqdFlag" persistence-name="FIN_TRNSFR_APPROVAL_REQD_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="budResApprovalReqdFlag" persistence-name="BUD_RES_APPROVAL_REQD_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="reportEmprPaidFlag" persistence-name="REPORT_EMPR_PAID_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="reportLeaveBalanceFlag" persistence-name="REPORT_LEAVE_BALANCE_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="apBeginAccrualOption" persistence-name="AP_BEGIN_ACCRUAL_OPTION" persistence-type="CHAR(1)"/> <cmp-field-mapping name="validateFund01Flag" persistence-name="VALIDATE_FUND_01_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="sacsDistrictType" persistence-name="SACS_DISTRICT_TYPE" persistence-type="CHAR(1)"/> <cmp-field-mapping name="logActivityFlag" persistence-name="LOG_ACTIVITY_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="payRateDecimalFlag" persistence-name="PAY_RATE_DECIMAL_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="hwSpouseLinkAllowedFlag" persistence-name="HW_SPOUSE_LINK_ALLOWED_FLAG" persistence-type="CHAR(1)"/> <cmp-field-mapping name="depreciationMethod" persistence-name="DEPRECIATION_METHOD" persistence-type="CHAR(1)"/> <cmp-field-mapping name="districtPhNbrExt" persistence-name="DISTRICT_PH_NBR_EXT" persistence-type="CHAR(5)"/> <cmp-field-mapping name="contact1099PhNbrExt" persistence-name="CONTACT_1099_PH_NBR_EXT" persistence-type="CHAR(5)"/> <cmp-field-mapping name="contactW2PhNbrExt" persistence-name="CONTACT_W2_PH_NBR_EXT" persistence-type="CHAR(5)"/> <cmp-field-mapping name="sdiAccountNbr" persistence-name="SDI_ACCOUNT_NBR" persistence-type="CHAR(8)"/> </entity-deployment> </enterprise-beans> </orion-ejb-jar> View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3884753#3884753 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3884753 ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
