ok, I'm really Not an idiot! Really! trust me! I have no idea how I managed to post ejb-jar.xml 3 times in a row.....maybe when I previewed before posting.. lets try that again:
Jboss.xml: | <?xml version="1.0"?> | | <jboss> | <enterprise-beans> | | <entity> | <ejb-name>CustSoldEJB</ejb-name> | <local-jndi-name>ejb/CustSoldLocalHome</local-jndi-name> | </entity> | | <entity> | <ejb-name>CustSalesEJB</ejb-name> | <local-jndi-name>ejb/CustSalesLocalHome</local-jndi-name> | </entity> | | <entity> | <ejb-name>SequenceEJB</ejb-name> | <local-jndi-name>ejb/SequenceLocalHome</local-jndi-name> | </entity> | | <session> | <ejb-name>KeyServerEJB</ejb-name> | <local-jndi-name>ejb/KeyServerLocalHome</local-jndi-name> | <ejb-local-ref> | <ejb-ref-name>ejb/SequenceLocalHome</ejb-ref-name> | <local-jndi-name>ejb/SequenceLocalHome</local-jndi-name> | </ejb-local-ref> | </session> | | | <session> | <ejb-name>ContactsEJB</ejb-name> | <local-jndi-name>ejb/ContactsLocalHome</local-jndi-name> | <ejb-local-ref> | <ejb-ref-name>ejb/KeyServerLocalHome</ejb-ref-name> | <local-jndi-name>ejb/KeyServerLocalHome</local-jndi-name> | </ejb-local-ref> | <resource-ref> | <res-ref-name>jdbc/Standalone</res-ref-name> | <jndi-name>java:/ITmysql</jndi-name> | </resource-ref> | </session> | | <session> | <ejb-name>CustomerEJB</ejb-name> | <jndi-name>ejb/CustomerHome</jndi-name> | <local-jndi-name>ejb/CustomerLocalHome</local-jndi-name> | <ejb-local-ref> | <ejb-ref-name>ejb/CustSalesLocalHome</ejb-ref-name> | <local-jndi-name>ejb/CustSalesLocalHome</local-jndi-name> | </ejb-local-ref> | <ejb-local-ref> | <ejb-ref-name>ejb/CustSoldLocalHome</ejb-ref-name> | <local-jndi-name>ejb/CustSoldLocalHome</local-jndi-name> | </ejb-local-ref> | <ejb-local-ref> | <ejb-ref-name>ejb/ContactsLocalHome</ejb-ref-name> | <local-jndi-name>ejb/ContactsLocalHome</local-jndi-name> | </ejb-local-ref> | </session> | | | | </enterprise-beans> | </jboss> jbosscmp-jdbc | <?xml version="1.0" encoding="UTF-8"?> | | <!DOCTYPE jbosscmp-jdbc PUBLIC | "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" | "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd";> | | <jbosscmp-jdbc> | | <!-- | <defaults> | <datasource>java:/jdbc/CurlDS</datasource> | <datasource-mapping>mySQL</datasource-mapping> | <create-table>false</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | </defaults> | --> | | <enterprise-beans> | <entity> | <ejb-name>CustSalesEJB</ejb-name> | <datasource>java:/CurlDS</datasource> | <datasource-mapping>mySQL</datasource-mapping> | <create-table>false</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <table-name>CUST_SALES</table-name> | <cmp-field><field-name>customerNumber</field-name> <column-name>CUST_NUM</column-name></cmp-field> | <cmp-field><field-name>customerName</field-name> <column-name>CUST_NAME</column-name></cmp-field> | <cmp-field><field-name>address1</field-name> <column-name>CUST_ADDR1</column-name></cmp-field> | <cmp-field><field-name>address2</field-name> <column-name>CUST_ADDR2</column-name></cmp-field> | <cmp-field><field-name>address3</field-name> <column-name>CUST_ADDR3</column-name></cmp-field> | <cmp-field><field-name>address4</field-name> <column-name>CUST_ADDR4</column-name></cmp-field> | <cmp-field><field-name>postalCode</field-name> <column-name>CUST_POSTAL_CODE</column-name></cmp-field> | <cmp-field><field-name>upsCode</field-name> <column-name>UPS_CD</column-name></cmp-field> | <cmp-field><field-name>salesPerson</field-name> <column-name>SALES_PERSON</column-name></cmp-field> | <cmp-field><field-name>customerContact</field-name> <column-name>CUST_CONTACT</column-name></cmp-field> | <cmp-field><field-name>customerPhone</field-name> <column-name>CUST_PHONE</column-name></cmp-field> | <cmp-field><field-name>apPerson</field-name> <column-name>CUST_AP_PERSON</column-name></cmp-field> | <cmp-field><field-name>apNumber</field-name> <column-name>CUST_AP_NUMBER</column-name></cmp-field> | <cmp-field><field-name>custType</field-name> <column-name>CUST_TYPE</column-name></cmp-field> | <cmp-field><field-name>finChangeCode</field-name> <column-name>FIN_CHG_CD</column-name></cmp-field> | <cmp-field><field-name>statementCode</field-name> <column-name>STATEMENT_CD</column-name></cmp-field> | <cmp-field><field-name>taxCode</field-name> <column-name>TAX_CD</column-name></cmp-field> | <cmp-field><field-name>creditLimit</field-name> <column-name>CREDIT_LIMIT</column-name></cmp-field> | <cmp-field><field-name>arBalance</field-name> <column-name>AR_BALANCE</column-name></cmp-field> | <cmp-field><field-name>unallocatedCash</field-name> <column-name>UNALL_CASH</column-name></cmp-field> | <cmp-field><field-name>lastPaymentDate</field-name> <column-name>LAST_PAY_DTE</column-name></cmp-field> | <cmp-field><field-name>lastPaymentAmount</field-name><column-name>LAST_PAY_AMT</column-name></cmp-field> | <cmp-field><field-name>lastBuyDate</field-name> <column-name>LAST_BUY_DTE</column-name></cmp-field> | <cmp-field><field-name>openOrderAmount</field-name> <column-name>OPEN_ORDER_AMT</column-name></cmp-field> | <cmp-field><field-name>highARBalance</field-name> <column-name>HIGH_AR_BAL</column-name></cmp-field> | <cmp-field><field-name>messageCode1</field-name> <column-name>MESSAGE_CD1</column-name></cmp-field> | <cmp-field><field-name>messageCode2</field-name> <column-name>MESSAGE_CD2</column-name></cmp-field> | <cmp-field><field-name>mtdPayments</field-name> <column-name>MTD_PAYMENTS</column-name></cmp-field> | <cmp-field><field-name>termsCode</field-name> <column-name>TERMS_CD</column-name></cmp-field> | <cmp-field><field-name>sicCode</field-name> <column-name>SIC_CD</column-name></cmp-field> | <cmp-field><field-name>newCustomerSwitch</field-name><column-name>NEW_CUST_SW</column-name></cmp-field> | <cmp-field><field-name>shipKey</field-name> <column-name>CUST_SHIPKEY</column-name></cmp-field> | <cmp-field><field-name>recordType</field-name> <column-name>RTYPE</column-name></cmp-field> | </entity> | | <entity> | | <ejb-name>CustSoldEJB</ejb-name> | <datasource>java:/CurlDS</datasource> | <datasource-mapping>mySQL</datasource-mapping> | <create-table>false</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <table-name>CUST_SOLD</table-name> | <cmp-field><field-name>shipNumber</field-name> <column-name>SHIP_NUM</column-name></cmp-field> | <cmp-field><field-name>shipName</field-name> <column-name>SHIP_NAME</column-name></cmp-field> | <cmp-field><field-name>address1</field-name> <column-name>SHIP_ADDR1</column-name></cmp-field> | <cmp-field><field-name>address2</field-name> <column-name>SHIP_ADDR2</column-name></cmp-field> | <cmp-field><field-name>address3</field-name> <column-name>SHIP_ADDR3</column-name></cmp-field> | <cmp-field><field-name>address4</field-name> <column-name>SHIP_ADDR4</column-name></cmp-field> | <cmp-field><field-name>postalCode</field-name> <column-name>SHIP_POSTAL_CODE</column-name></cmp-field> | <cmp-field><field-name>monthToDateQuantity</field-name><column-name>MTD_KGS</column-name></cmp-field> | <cmp-field><field-name>monthToDateSales</field-name><column-name>MTD_SALES_VALUE</column-name></cmp-field> | <cmp-field><field-name>monthToDateCost</field-name> <column-name>MTD_COST_VALUE</column-name></cmp-field> | <cmp-field><field-name>yearToDateQuantity</field-name><column-name>YTD_KGS</column-name></cmp-field> | <cmp-field><field-name>yearToDateSales</field-name> <column-name>YTD_SALES_VALUE</column-name></cmp-field> | <cmp-field><field-name>yearToDateCost</field-name> <column-name>YTD_COST_VALUE</column-name></cmp-field> | <cmp-field><field-name>priorYearQuantity</field-name><column-name>PR_YR_KGS</column-name></cmp-field> | <cmp-field><field-name>priorYearSales</field-name> <column-name>PR_YR_SALES_VALUE</column-name></cmp-field> | <cmp-field><field-name>priorYearCost</field-name> <column-name>PR_YR_COST_VALUE</column-name></cmp-field> | <cmp-field><field-name>prior2ndYearQuantity</field-name><column-name>PR_YR2_KGS</column-name></cmp-field> | <cmp-field><field-name>prior2ndYearSales</field-name><column-name>PR_YR2_SALES_VALUE</column-name></cmp-field> | <cmp-field><field-name>prior2ndYearCost</field-name><column-name>PR_YR2_COST_VALUE</column-name></cmp-field> | <cmp-field><field-name>currentBalance</field-name> <column-name>CURRENT_BAL</column-name></cmp-field> | <cmp-field><field-name>day30Balance</field-name> <column-name>DAY30_BAL</column-name></cmp-field> | <cmp-field><field-name>day60Balance</field-name> <column-name>DAY60_BAL</column-name></cmp-field> | <cmp-field><field-name>day90Balance</field-name> <column-name>DAY90_BAL</column-name></cmp-field> | <cmp-field><field-name>totalPaidInvoices</field-name><column-name>TOT_PD_INVOICES</column-name></cmp-field> | <cmp-field><field-name>totalPaidCurrentInvoices</field-name><column-name>TOT_PD_CUR</column-name></cmp-field> | <cmp-field><field-name>totalPaid30Day</field-name> <column-name>TOT_PD_30DAY</column-name></cmp-field> | <cmp-field><field-name>totalPaid60Day</field-name> <column-name>TOT_PD_60DAY</column-name></cmp-field> | <cmp-field><field-name> totalPaid90Day</field-name> <column-name>TOT_PD_90DAY</column-name></cmp-field> | <cmp-field><field-name>invoicesOutstanding</field-name><column-name>INVCS_OUTSTANDING</column-name></cmp-field> | <cmp-field><field-name>salesKey</field-name><column-name>CUST_SALESKEY</column-name></cmp-field> | <cmp-field><field-name>recordType</field-name><column-name>RTYPE</column-name></cmp-field> | </entity> | | <entity> | <ejb-name>SequenceEJB</ejb-name> | <datasource>java:/ITmysql</datasource> | <datasource-mapping>mySQL</datasource-mapping> | <create-table>false</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <table-name>KeySequence</table-name> | <cmp-field><field-name>sequenceName</field-name><column-name>Key_Name</column-name></cmp-field> | <cmp-field><field-name>value</field-name><column-name>Value</column-name></cmp-field> | </entity> | | </enterprise-beans> | | | </jbosscmp-jdbc> View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829257#3829257 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829257 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
