2 Replies Latest reply on Nov 11, 2005 1:04 AM by chrisbitmead

ClassCastException: JDBCCMP1xFieldBridge

chrisbitmead Nov 10, 2005 11:05 PM

I'm trying to port an app from an old Borland app server to JBoss 4.0.3SP1 (aka "latest and greatest"), and I am getting the following stack trace...

I've been looking at the config files and classes a million times and can't figure out what the problem is. I'm attaching some of the config files...

14:55:34,897 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=SpAgreementYear,service=EJB
java.lang.ClassCastException: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP1xFieldBridge
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.initializeForeignKeyFields(JDBCCMRFieldBridge.java:1729)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMRFieldBridge.resolveRelationship(JDBCCMRFieldBridge.java:367)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.resolveRelationships(JDBCEntityBridge.java:282)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.resolveRelationships(JDBCStoreManager.java:445)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:372)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:428)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy51.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:395)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:428)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy23.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:627)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy24.start(Unknown Source)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:979)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy9.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:428)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
at org.jboss.Main.boot(Main.java:187)
at org.jboss.Main$1.run(Main.java:438)
at java.lang.Thread.run(Thread.java:595)

ObjectName: jboss.j2ee:jndiName=SpAgreementYear,service=EJB
State: FAILED
Reason: java.lang.ClassCastException: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP1xFieldBridge

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.j2ee:jndiName=SpAgreementYear,service=EJB
State: FAILED
Reason: java.lang.ClassCastException: org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP1xFieldBridge

ObjectName: jboss.jca:service=DataSourceBinding,name=npc
State: NOTYETINSTALLED
Depends On Me:
jboss.mq:service=PersistenceManager

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC
"-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN"
"http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
<jbosscmp-jdbc>

java:/jdbc/npc
<datasource-mapping>Oracle8</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>

<enterprise-beans>

<ejb-name>StateProgramManager</ejb-name>
<table-name>STATE_PROGRAM_MANAGER</table-name>
<cmp-field>
<field-name>programManagerId</field-name>
<column-name>PROGRAM_MANAGER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>programManagerName</field-name>
<column-name>PROGRAM_MANAGER_NAME</column-name>
</cmp-field>
<cmp-field>
<field-name>programManagerPassword</field-name>
<column-name>PROGRAM_MANAGER_PASSWORD</column-name>
</cmp-field>
<cmp-field>
<field-name>emailAddress</field-name>
<column-name>EMAIL_ADDRESS</column-name>
</cmp-field>

<ejb-name>Agreement</ejb-name>
<table-name>AGREEMENT</table-name>
<cmp-field>
<field-name>agreementId</field-name>
<column-name>AGREEMENT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>agreementPeriodFrom</field-name>
<column-name>AGREEMENT_PERIOD_FROM</column-name>
</cmp-field>
<cmp-field>
<field-name>agreementPeriodTo</field-name>
<column-name>AGREEMENT_PERIOD_TO</column-name>
</cmp-field>
<cmp-field>
<field-name>programManagerId</field-name>
<column-name>PROGRAM_MANAGER_ID</column-name>
</cmp-field>

<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
agreement_seq
</entity-command>

<ejb-name>ServiceProvider</ejb-name>
<table-name>SERVICE_PROVIDER</table-name>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>programManagerId</field-name>
<column-name>PROGRAM_MANAGER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>spName</field-name>
<column-name>SP_NAME</column-name>
</cmp-field>
<cmp-field>
<field-name>spmSpId</field-name>
<column-name>SPM_SP_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>streetAddress</field-name>
<column-name>STREET_ADDRESS</column-name>
</cmp-field>
<cmp-field>
<field-name>locality</field-name>
<column-name>LOCALITY</column-name>
</cmp-field>
<cmp-field>
<field-name>postcode</field-name>
<column-name>POSTCODE</column-name>
</cmp-field>
<cmp-field>
<field-name>state</field-name>
<column-name>STATE</column-name>
</cmp-field>
<cmp-field>
<field-name>sla</field-name>
<column-name>SLA_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>emailAddress</field-name>
<column-name>EMAIL_ADDRESS</column-name>
</cmp-field>
<cmp-field>
<field-name>postalStreetAddress</field-name>
<column-name>POSTAL_STREET_ADDRESS</column-name>
</cmp-field>
<cmp-field>
<field-name>postalLocality</field-name>
<column-name>POSTAL_LOCALITY</column-name>
</cmp-field>
<cmp-field>
<field-name>postalPostcode</field-name>
<column-name>POSTAL_POSTCODE</column-name>
</cmp-field>
<cmp-field>
<field-name>postalState</field-name>
<column-name>POSTAL_STATE</column-name>
</cmp-field>
<cmp-field>
<field-name>notes</field-name>
<column-name>NOTES</column-name>
</cmp-field>

<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
service_provider_seq
</entity-command>

<ejb-name>ClspRatio</ejb-name>
<table-name>CLSP_RATIO</table-name>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>financialYear</field-name>
<column-name>FINANCIAL_YEAR</column-name>
</cmp-field>
<cmp-field>
<field-name>clspRatio</field-name>
<column-name>CLSP_RATIO</column-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
<column-name>STATUS</column-name>
</cmp-field>

<ejb-name>SpAgreementSubmission</ejb-name>
<table-name>SP_AGREEMENT_SUBMISSION</table-name>
<cmp-field>
<field-name>submissionId</field-name>
<column-name>SUBMISSION_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>agreementId</field-name>
<column-name>AGREEMENT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>submissionTypeId</field-name>
<column-name>SUBMISSION_TYPE_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>extentionDate</field-name>
<column-name>EXTENSION_DATE</column-name>
</cmp-field>
<cmp-field>
<field-name>receiptDate</field-name>
<column-name>RECEIPT_DATE</column-name>
</cmp-field>
<cmp-field>
<field-name>approvalDate</field-name>
<column-name>APPROVAL_DATE</column-name>
</cmp-field>
<cmp-field>
<field-name>rejectionDate</field-name>
<column-name>REJECTION_DATE</column-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
<column-name>STATUS</column-name>
</cmp-field>
<cmp-field>
<field-name>notes</field-name>
<column-name>NOTES</column-name>
</cmp-field>
<cmp-field>
<field-name>year</field-name>
<column-name>YEAR_NUMBER</column-name>
</cmp-field>
<cmp-field>
<field-name>totalClspIncome</field-name>
<column-name>TOTAL_CLSP_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>totalClspExpense</field-name>
<column-name>TOTAL_CLSP_EXPENSE</column-name>
</cmp-field>
<cmp-field>
<field-name>totalSurplusDeficit</field-name>
<column-name>TOTAL_SURPLUS_DEFICIT</column-name>
</cmp-field>
<cmp-field>
<field-name>totalOtherIncome</field-name>
<column-name>TOTAL_OTHER_INCOME</column-name>
</cmp-field>

<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
submission_seq
</entity-command>

<ejb-name>OtherIncomeDetail</ejb-name>
<table-name>OTHER_INCOME_DETAIL</table-name>
<cmp-field>
<field-name>detailId</field-name>
<column-name>DETAIL_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>fundingCategory</field-name>
<column-name>FUNDING_CATEGORY</column-name>
</cmp-field>
<cmp-field>
<field-name>spFundingCategoryId</field-name>
<column-name>SP_FUNDING_CATEGORY_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>recordedInClsisInd</field-name>
<column-name>RECORDED_IN_CLSIS_IND</column-name>
</cmp-field>
<cmp-field>
<field-name>parentDetailId</field-name>
<column-name>PARENT_DETAIL_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>spAgreementSubmission</field-name>
<column-name>SUBMISSION_ID</column-name>
</cmp-field>

<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
other_income_detail_seq
</entity-command>

<ejb-name>TargetsReportDetail</ejb-name>
<table-name>TARGETS_REPORT_DETAIL</table-name>
<cmp-field>
<field-name>targetsId</field-name>
<column-name>TARGETS_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>submissionId</field-name>
<column-name>SUBMISSION_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>faceToFaceAdvice</field-name>
<column-name>FACE_TO_FACE_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>telephoneAdvice</field-name>
<column-name>TELEPHONE_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>mailAdvice</field-name>
<column-name>MAIL_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>emailAdvice</field-name>
<column-name>EMAIL_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>ttyAdvice</field-name>
<column-name>TTY_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>videoAdvice</field-name>
<column-name>VIDEO_ADVICE</column-name>
</cmp-field>
<cmp-field>
<field-name>ongoingCases</field-name>
<column-name>ONGOING_CASES</column-name>
</cmp-field>
<cmp-field>
<field-name>closedCases</field-name>
<column-name>CLOSED_CASES</column-name>
</cmp-field>
<cmp-field>
<field-name>cleProjects</field-name>
<column-name>CLE_PROJECTS</column-name>
</cmp-field>
<cmp-field>
<field-name>lawReformPolicyProjects</field-name>
<column-name>LAW_REFORM_POLICY_PROJECTS</column-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
<column-name>STATUS</column-name>
</cmp-field>

<ejb-name>FinancialReportDetail</ejb-name>
<table-name>FINANCIAL_REPORT_DETAIL</table-name>
<cmp-field>
<field-name>reportId</field-name>
<column-name>REPORT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>fundingCategory</field-name>
<column-name>FUNDING_CATEGORY</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>commonwealthIncome</field-name>
<column-name>COMMONWEALTH_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>stateIncome</field-name>
<column-name>STATE_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>interestIncome</field-name>
<column-name>INTEREST_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>membershipIncome</field-name>
<column-name>MEMBERSHIP_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>cleIncome</field-name>
<column-name>CLE_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>costsRecoveredRetained</field-name>
<column-name>COSTS_RECOVERED_RETAINED</column-name>
</cmp-field>
<cmp-field>
<field-name>fundraisingDonation</field-name>
<column-name>FUNDRAISING_DONATION</column-name>
</cmp-field>
<cmp-field>
<field-name>sundryIncome</field-name>
<column-name>SUNDRY_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>approvedCapExpIncome</field-name>
<column-name>APPROVED_CAP_EXP_INCOME</column-name>
</cmp-field>
<cmp-field>
<field-name>onCosts</field-name>
<column-name>ON_COSTS</column-name>
</cmp-field>
<cmp-field>
<field-name>repairsMaintenance</field-name>
<column-name>REPAIRS_MAINTENANCE</column-name>
</cmp-field>
<cmp-field>
<field-name>otherPremisesCosts</field-name>
<column-name>OTHER_PREMISES_COSTS</column-name>
</cmp-field>
<cmp-field>
<field-name>staffTraining</field-name>
<column-name>STAFF_TRAINING</column-name>
</cmp-field>
<cmp-field>
<field-name>staffRecruitment</field-name>
<column-name>STAFF_RECRUITMENT</column-name>
</cmp-field>
<cmp-field>
<field-name>officeOverheads</field-name>
<column-name>OFFICE_OVERHEADS</column-name>
</cmp-field>
<cmp-field>
<field-name>financeAccountingFees</field-name>
<column-name>FINANCE_ACCOUNTING_FEES</column-name>
</cmp-field>
<cmp-field>
<field-name>libraryResourcesSubscription</field-name>
<column-name>LIBRARY_RESOURCES_SUBSCRIPTION</column-name>
</cmp-field>
<cmp-field>
<field-name>programmingAndPlanning</field-name>
<column-name>PROGRAMMING_AND_PLANNING</column-name>
</cmp-field>
<cmp-field>
<field-name>clientDisembursements</field-name>
<column-name>CLIENT_DISEMBURSEMENTS</column-name>
</cmp-field>
<cmp-field>
<field-name>approvedCapExpExpense</field-name>
<column-name>APPROVED_CAP_EXP_EXPENSE</column-name>
</cmp-field>
<cmp-field>
<field-name>spAgreementSubmission</field-name>
<column-name>SUBMISSION_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>surplusDeficit</field-name>
<column-name>SURPLUS_DEFICIT</column-name>
</cmp-field>

<ejb-name>Submission</ejb-name>
<table-name>SUBMISSION</table-name>
<cmp-field>
<field-name>submissionTypeId</field-name>
<column-name>SUBMISSION_TYPE_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
<column-name>DESCRIPTION</column-name>
</cmp-field>
<cmp-field>
<field-name>reportType</field-name>
<column-name>REPORT_TYPE</column-name>
</cmp-field>
<cmp-field>
<field-name>reportScope</field-name>
<column-name>REPORT_SCOPE</column-name>
</cmp-field>

<ejb-name>StatisticalLocalArea</ejb-name>
<table-name>STATISTICAL_LOCAL_AREA</table-name>
<cmp-field>
<field-name>slaId</field-name>
<column-name>SLA_ID</column-name>
</cmp-field>

<ejb-name>DefaultStateSla</ejb-name>
<table-name>DEFAULT_STATE_SLA</table-name>
<cmp-field>
<field-name>slaId</field-name>
<column-name>SLA_ID</column-name>
</cmp-field>

<ejb-name>UploadSession</ejb-name>
<table-name>UPLOAD_SESSION</table-name>
<cmp-field>
<field-name>sessionId</field-name>
<column-name>SESSION_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>sessionStart</field-name>
<column-name>SESSION_START</column-name>
</cmp-field>
<cmp-field>
<field-name>sessionEnd</field-name>
<column-name>SESSION_END</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>recordsInserted</field-name>
<column-name>RECORDS_INSERTED</column-name>
</cmp-field>
<cmp-field>
<field-name>recordsUpdated</field-name>
<column-name>RECORDS_UPDATED</column-name>
</cmp-field>
<cmp-field>
<field-name>recordsDeleted</field-name>
<column-name>RECORDS_DELETED</column-name>
</cmp-field>
<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
upload_session_seq
</entity-command>

<ejb-name>FundingCategory</ejb-name>
<table-name>X_FUNDING_CATEGORY</table-name>
<cmp-field>
<field-name>code</field-name>
<column-name>CODE</column-name>
</cmp-field>
<cmp-field>
<field-name>description</field-name>
<column-name>DESCRIPTION</column-name>
</cmp-field>
<cmp-field>
<field-name>containedIn</field-name>
<column-name>CONTAINED_IN</column-name>
</cmp-field>
<cmp-field>
<field-name>hiddenInd</field-name>
<column-name>HIDDEN_IND</column-name>
</cmp-field>
<cmp-field>
<field-name>customValueInd</field-name>
<column-name>CUSTOM_VALUE_IND</column-name>
</cmp-field>
<cmp-field>
<field-name>defaultValueInd</field-name>
<column-name>DEFAULT_VALUE_IND</column-name>
</cmp-field>
<cmp-field>
<field-name>activeInd</field-name>
<column-name>ACTIVE_IND</column-name>
</cmp-field>

<ejb-name>SpAgreementCategory</ejb-name>
<table-name>SP_AGREEMENT_CATEGORY</table-name>
<cmp-field>
<field-name>yearNumber</field-name>
<column-name>YEAR_NUMBER</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>agreementId</field-name>
<column-name>AGREEMENT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>lockedInd</field-name>
<column-name>LOCKED_IND</column-name>
</cmp-field>
<cmp-field>
<field-name>submitCount</field-name>
<column-name>SUBMIT_COUNT</column-name>
</cmp-field>
<cmp-field>
<field-name>spFundingCategoryId</field-name>
<column-name>SP_FUNDING_CATEGORY_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>fundingCategory</field-name>
<column-name>FUNDING_CATEGORY</column-name>
</cmp-field>

<entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
sp_agreement_category_seq
</entity-command>

<ejb-name>SpAgreementYear</ejb-name>
<table-name>SP_AGREEMENT_YEAR</table-name>
<cmp-field>
<field-name>yearNumber</field-name>
<column-name>YEAR_NUMBER</column-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
<column-name>SERVICE_PROVIDER_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>agreementId</field-name>
<column-name>AGREEMENT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>activeStatus</field-name>
<column-name>ACTIVE_STATUS</column-name>
</cmp-field>
<cmp-field>
<field-name>fundedStatus</field-name>
<column-name>FUNDED_STATUS</column-name>
</cmp-field>


</enterprise-beans>

<ejb-relation>
<ejb-relation-name>SpAgreementSubmission-OtherIncomeDetail</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>SpAgreementSubmission_has_OtherIncomeDetail</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>submissionId</field-name>
<column-name>SUBMISSION_ID</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>OtherIncomeDetail_belongesto_SpAgreementSubmission</ejb-relationship-role-name>
</ejb-relationship-role>
</ejb-relation>

</jbosscmp-jdbc>

<?xml version="1.0" encoding="US-ASCII"?>
<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN' 'http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd'>

<ejb-jar>
<enterprise-beans>

<ejb-name>Mailer</ejb-name>
au.gov.ag.npc.financials.MailerHome
au.gov.ag.npc.financials.Mailer
<ejb-class>au.gov.ag.npc.financials.MailerBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<env-entry>

<env-entry-name>mailerBCC</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value />
</env-entry>
<resource-ref>

<res-ref-name>mail/npc</res-ref-name>
<res-type>javax.mail.Session</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>SpFinOtherSession</ejb-name>
au.gov.ag.npc.financials.SpFinOtherSessionHome
au.gov.ag.npc.financials.SpFinOtherSession
<ejb-class>au.gov.ag.npc.financials.SpFinOtherSessionBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Container</transaction-type>
<env-entry>

<env-entry-name>spMailEnabled</env-entry-name>
<env-entry-type>java.lang.Boolean</env-entry-type>
<env-entry-value>false</env-entry-value>
</env-entry>
<ejb-ref>
<ejb-ref-name>ejb/ServiceProvider</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ServiceProviderHome
au.gov.ag.npc.financials.ServiceProvider
<ejb-link>ServiceProvider</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreement</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementHome
au.gov.ag.npc.financials.SpAgreement
<ejb-link>SpAgreement</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementSubmission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementSubmissionHome
au.gov.ag.npc.financials.SpAgreementSubmission
<ejb-link>SpAgreementSubmission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FinancialReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FinancialReportDetailHome
au.gov.ag.npc.financials.FinancialReportDetail
<ejb-link>FinancialReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/AgreementSubmissions</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.AgreementSubmissionsHome
au.gov.ag.npc.financials.AgreementSubmissions
<ejb-link>AgreementSubmissions</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/OtherIncomeDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.OtherIncomeDetailHome
au.gov.ag.npc.financials.OtherIncomeDetail
<ejb-link>OtherIncomeDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/TargetsReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.TargetsReportDetailHome
au.gov.ag.npc.financials.TargetsReportDetail
<ejb-link>TargetsReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Submission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SubmissionHome
au.gov.ag.npc.financials.Submission
<ejb-link>Submission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/StateProgramManager</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.StateProgramManagerHome
au.gov.ag.npc.financials.StateProgramManager
<ejb-link>StateProgramManager</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Mailer</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
au.gov.ag.npc.financials.MailerHome
au.gov.ag.npc.financials.Mailer
<ejb-link>Mailer</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FundingCategory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FundingCategoryHome
au.gov.ag.npc.financials.FundingCategory
<ejb-link>FundingCategory</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementYear</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementYearHome
au.gov.ag.npc.financials.SpAgreementYear
<ejb-link>SpAgreementYear</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ClspRatio</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ClspRatioHome
au.gov.ag.npc.financials.ClspRatio
<ejb-link>ClspRatio</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>SpFinMacSession</ejb-name>
au.gov.ag.npc.financials.SpFinMacSessionHome
au.gov.ag.npc.financials.SpFinMacSession
<ejb-class>au.gov.ag.npc.financials.SpFinMacSessionBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Container</transaction-type>
<env-entry>

<env-entry-name>spMailEnabled</env-entry-name>
<env-entry-type>java.lang.Boolean</env-entry-type>
<env-entry-value>false</env-entry-value>
</env-entry>
<ejb-ref>
<ejb-ref-name>ejb/ServiceProvider</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ServiceProviderHome
au.gov.ag.npc.financials.ServiceProvider
<ejb-link>ServiceProvider</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreement</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementHome
au.gov.ag.npc.financials.SpAgreement
<ejb-link>SpAgreement</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementSubmission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementSubmissionHome
au.gov.ag.npc.financials.SpAgreementSubmission
<ejb-link>SpAgreementSubmission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FinancialReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FinancialReportDetailHome
au.gov.ag.npc.financials.FinancialReportDetail
<ejb-link>FinancialReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/AgreementSubmissions</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.AgreementSubmissionsHome
au.gov.ag.npc.financials.AgreementSubmissions
<ejb-link>AgreementSubmissions</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/OtherIncomeDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.OtherIncomeDetailHome
au.gov.ag.npc.financials.OtherIncomeDetail
<ejb-link>OtherIncomeDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/TargetsReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.TargetsReportDetailHome
au.gov.ag.npc.financials.TargetsReportDetail
<ejb-link>TargetsReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Submission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SubmissionHome
au.gov.ag.npc.financials.Submission
<ejb-link>Submission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/StateProgramManager</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.StateProgramManagerHome
au.gov.ag.npc.financials.StateProgramManager
<ejb-link>StateProgramManager</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Mailer</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
au.gov.ag.npc.financials.MailerHome
au.gov.ag.npc.financials.Mailer
<ejb-link>Mailer</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FundingCategory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FundingCategoryHome
au.gov.ag.npc.financials.FundingCategory
<ejb-link>FundingCategory</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementYear</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementYearHome
au.gov.ag.npc.financials.SpAgreementYear
<ejb-link>SpAgreementYear</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ClspRatio</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ClspRatioHome
au.gov.ag.npc.financials.ClspRatio
<ejb-link>ClspRatio</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>Spm</ejb-name>
au.gov.ag.npc.financials.SpmHome
au.gov.ag.npc.financials.Spm
<ejb-class>au.gov.ag.npc.financials.SpmBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Container</transaction-type>
<env-entry>

<env-entry-name>spmMailEnabled</env-entry-name>
<env-entry-type>java.lang.Boolean</env-entry-type>
<env-entry-value>false</env-entry-value>
</env-entry>
<ejb-ref>
<ejb-ref-name>ejb/StateProgramManager</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.StateProgramManagerHome
au.gov.ag.npc.financials.StateProgramManager
<ejb-link>StateProgramManager</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ServiceProvider</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ServiceProviderHome
au.gov.ag.npc.financials.ServiceProvider
<ejb-link>ServiceProvider</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Agreement</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.AgreementHome
au.gov.ag.npc.financials.Agreement
<ejb-link>Agreement</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Submission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SubmissionHome
au.gov.ag.npc.financials.Submission
<ejb-link>Submission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/AgreementSubmissions</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.AgreementSubmissionsHome
au.gov.ag.npc.financials.AgreementSubmissions
<ejb-link>AgreementSubmissions</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SlaGenerator</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
au.gov.ag.npc.sla.SlaGeneratorHome
au.gov.ag.npc.sla.SlaGeneratorRemote
<ejb-link>SlaGenerator</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementSubmission</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementSubmissionHome
au.gov.ag.npc.financials.SpAgreementSubmission
<ejb-link>SpAgreementSubmission</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FundingCategory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FundingCategoryHome
au.gov.ag.npc.financials.FundingCategory
<ejb-link>FundingCategory</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/TargetsReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.TargetsReportDetailHome
au.gov.ag.npc.financials.TargetsReportDetail
<ejb-link>TargetsReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/FinancialReportDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.FinancialReportDetailHome
au.gov.ag.npc.financials.FinancialReportDetail
<ejb-link>FinancialReportDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/OtherIncomeDetail</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.OtherIncomeDetailHome
au.gov.ag.npc.financials.OtherIncomeDetail
<ejb-link>OtherIncomeDetail</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Mailer</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
au.gov.ag.npc.financials.MailerHome
au.gov.ag.npc.financials.Mailer
<ejb-link>Mailer</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreement</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementHome
au.gov.ag.npc.financials.SpAgreement
<ejb-link>SpAgreement</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementYear</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementYearHome
au.gov.ag.npc.financials.SpAgreementYear
<ejb-link>SpAgreementYear</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SpAgreementCategory</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.SpAgreementCategoryHome
au.gov.ag.npc.financials.SpAgreementCategory
<ejb-link>SpAgreementCategory</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ClspRatio</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ClspRatioHome
au.gov.ag.npc.financials.ClspRatio
<ejb-link>ClspRatio</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>SlaGenerator</ejb-name>
au.gov.ag.npc.sla.SlaGeneratorHome
au.gov.ag.npc.sla.SlaGeneratorRemote
<ejb-class>au.gov.ag.npc.sla.SlaGenerator</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<ejb-ref>
<ejb-ref-name>ejb/StatisticalLocalArea</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.sla.StatisticalLocalAreaHome
au.gov.ag.npc.sla.StatisticalLocalArea
<ejb-link>StatisticalLocalArea</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/DefaultStateSla</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.sla.DefaultStateSlaHome
au.gov.ag.npc.sla.DefaultStateSla
<ejb-link>DefaultStateSla</ejb-link>
</ejb-ref>

<ejb-name>NPCUpload</ejb-name>
au.gov.ag.npc.upload.NPCUploadHome
au.gov.ag.npc.upload.NPCUpload
<ejb-class>au.gov.ag.npc.upload.NPCUploadBean</ejb-class>
<session-type>Stateful</session-type>
<transaction-type>Bean</transaction-type>
<env-entry>

<env-entry-name>stagingDatabase</env-entry-name>
<env-entry-type>java.lang.Boolean</env-entry-type>
<env-entry-value>true</env-entry-value>
</env-entry>
<ejb-ref>
<ejb-ref-name>ejb/ServiceProvider</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.ServiceProviderHome
au.gov.ag.npc.financials.ServiceProvider
<ejb-link>ServiceProvider</ejb-link>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SlaGenerator</ejb-ref-name>
<ejb-ref-type>Session</ejb-ref-type>
au.gov.ag.npc.sla.SlaGeneratorHome
au.gov.ag.npc.sla.SlaGeneratorRemote
<ejb-link>SlaGenerator</ejb-link>
</ejb-ref>
<resource-ref>

<res-ref-name>jdbc/datasink</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>StateProgramManager</ejb-name>
au.gov.ag.npc.financials.StateProgramManagerHome
au.gov.ag.npc.financials.StateProgramManager
<ejb-class>au.gov.ag.npc.financials.StateProgramManagerBeanCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.math.BigDecimal</prim-key-class>
False
<cmp-field>
<field-name>programManagerId</field-name>
</cmp-field>
<cmp-field>
<field-name>programManagerName</field-name>
</cmp-field>
<cmp-field>
<field-name>programManagerPassword</field-name>
</cmp-field>
<cmp-field>
<field-name>emailAddress</field-name>
</cmp-field>
<primkey-field>programManagerId</primkey-field>
<ejb-ref>
<ejb-ref-name>ejb/Agreement</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.AgreementHome
au.gov.ag.npc.financials.Agreement
<ejb-link>Agreement</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<query-method>
<method-name>findByName</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>[CDATA[ SELECT OBJECT(o) FROM StateProgramManager o WHERE o.programManagerName = ?1]]</ejb-ql>

<ejb-name>Agreement</ejb-name>
au.gov.ag.npc.financials.AgreementHome
au.gov.ag.npc.financials.Agreement
<ejb-class>au.gov.ag.npc.financials.AgreementBeanCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.math.BigDecimal</prim-key-class>
False
<cmp-field>
<field-name>agreementId</field-name>
</cmp-field>
<cmp-field>
<field-name>agreementPeriodFrom</field-name>
</cmp-field>
<cmp-field>
<field-name>agreementPeriodTo</field-name>
</cmp-field>
<cmp-field>
<field-name>programManagerId</field-name>
</cmp-field>
<primkey-field>agreementId</primkey-field>
<ejb-ref>
<ejb-ref-name>ejb/StateProgramManager</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
au.gov.ag.npc.financials.StateProgramManagerHome
au.gov.ag.npc.financials.StateProgramManager
<ejb-link>StateProgramManager</ejb-link>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<query-method>
<method-name>findByStateProgramManager</method-name>
<method-params>
<method-param>java.math.BigDecimal</method-param>
</method-params>
</query-method>
<ejb-ql>[CDATA[ SELECT OBJECT(o) FROM Agreement o WHERE o.programManagerId = ?1 ]]</ejb-ql>

<query-method>
<method-name>findOverlapingPeriod</method-name>
<method-params>
<method-param>java.math.BigDecimal</method-param>
<method-param>java.math.BigDecimal</method-param>
<method-param>java.math.BigDecimal</method-param>
</method-params>
</query-method>
<ejb-ql>[CDATA[ SELECT OBJECT(o) FROM Agreement o WHERE o.programManagerId = ?1 and ( ( o.agreementPeriodFrom <= ?1 and o.agreementPeriodTo >= ?1) or ( o.agreementPeriodFrom <= ?2 and o.agreementPeriodTo >= ?2))]]</ejb-ql>

<query-method>
<method-name>findByPeriod</method-name>
<method-params>
<method-param>java.math.BigDecimal</method-param>
<method-param>java.math.BigDecimal</method-param>
<method-param>java.math.BigDecimal</method-param>
</method-params>
</query-method>
<ejb-ql>[CDATA[ SELECT OBJECT(o) FROM Agreement o WHERE o.programManagerId = ?1 AND o.agreementPeriodFrom = ?2 AND o.agreementPeriodTo = ?3 ]]</ejb-ql>

<ejb-name>AgreementSubmissions</ejb-name>
au.gov.ag.npc.financials.AgreementSubmissionsHome
au.gov.ag.npc.financials.AgreementSubmissions
<ejb-class>au.gov.ag.npc.financials.AgreementSubmissionsBeanBMP</ejb-class>
<persistence-type>Bean</persistence-type>
<prim-key-class>au.gov.ag.npc.financials.AgreementSubmissionsPK</prim-key-class>
False
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<display-name>Service Provider Bean</display-name>
<ejb-name>ServiceProvider</ejb-name>
au.gov.ag.npc.financials.ServiceProviderHome
au.gov.ag.npc.financials.ServiceProvider
<ejb-class>au.gov.ag.npc.financials.ServiceProviderBeanCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.math.BigDecimal</prim-key-class>
False
<cmp-field>
<field-name>serviceProviderId</field-name>
</cmp-field>
<cmp-field>
<field-name>programManagerId</field-name>
</cmp-field>
<cmp-field>
<field-name>spName</field-name>
</cmp-field>
<cmp-field>
<field-name>spmSpId</field-name>
</cmp-field>
<cmp-field>
<field-name>streetAddress</field-name>
</cmp-field>
<cmp-field>
<field-name>locality</field-name>
</cmp-field>
<cmp-field>
<field-name>postcode</field-name>
</cmp-field>
<cmp-field>
<field-name>state</field-name>
</cmp-field>
<cmp-field>
<field-name>sla</field-name>
</cmp-field>
<cmp-field>
<field-name>emailAddress</field-name>
</cmp-field>
<cmp-field>
<field-name>postalStreetAddress</field-name>
</cmp-field>
<cmp-field>
<field-name>postalLocality</field-name>
</cmp-field>
<cmp-field>
<field-name>postalPostcode</field-name>
</cmp-field>
<cmp-field>
<field-name>postalState</field-name>
</cmp-field>
<cmp-field>
<field-name>notes</field-name>
</cmp-field>
<primkey-field>serviceProviderId</primkey-field>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<query-method>
<method-name>findByStateProgramManager</method-name>
<method-params>
<method-param>java.math.BigDecimal</method-param>
</method-params>
</query-method>
<ejb-ql>[CDATA[ SELECT OBJECT(o) FROM ServiceProvider o WHERE o.programManagerId = ?1]]</ejb-ql>

<ejb-name>ClspRatio</ejb-name>
au.gov.ag.npc.financials.ClspRatioHome
au.gov.ag.npc.financials.ClspRatio
<ejb-class>au.gov.ag.npc.financials.ClspRatioBeanCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>au.gov.ag.npc.financials.ClspRatioPK</prim-key-class>
False
<cmp-field>
<field-name>serviceProviderId</field-name>
</cmp-field>
<cmp-field>
<field-name>financialYear</field-name>
</cmp-field>
<cmp-field>
<field-name>quarter</field-name>
</cmp-field>
<cmp-field>
<field-name>clspRatio</field-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
</cmp-field>
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>SpAgreement</ejb-name>
au.gov.ag.npc.financials.SpAgreementHome
au.gov.ag.npc.financials.SpAgreement
<ejb-class>au.gov.ag.npc.financials.SpAgreementBeanBMP</ejb-class>
<persistence-type>Bean</persistence-type>
<prim-key-class>au.gov.ag.npc.financials.SpAgreementPK</prim-key-class>
False
<resource-ref>
<res-ref-name>jdbc/npc</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

<ejb-name>SpAgreementSubmission</ejb-name>
au.gov.ag.npc.financials.SpAgreementSubmissionHome
au.gov.ag.npc.financials.SpAgreementSubmission
<ejb-class>au.gov.ag.npc.financials.SpAgreementSubmissionBeanCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.math.BigDecimal</prim-key-class>
False
<cmp-field>
<field-name>submissionId</field-name>
</cmp-field>
<cmp-field>
<field-name>serviceProviderId</field-name>
</cmp-field>
<cmp-field>
<field-name>agreementId</field-name>
</cmp-field>
<cmp-field>
<field-name>submissionTypeId</field-name>
</cmp-field>
<cmp-field>
<field-name>extentionDate</field-name>
</cmp-field>

1. Re: ClassCastException: JDBCCMP1xFieldBridge

chrisbitmead Nov 11, 2005 12:48 AM (in response to chrisbitmead)

Ok, I found it. Darn that was hard to figure out. I had an ejb 1.0 DTD at the top of the ejb-jar xml, so it was getting confused between EJB 1 and EJB 2.
Actions
2. Re: ClassCastException: JDBCCMP1xFieldBridge

chrisbitmead Nov 11, 2005 1:04 AM (in response to chrisbitmead)

Ok, I found it. Darn that was hard to figure out. I had an ejb 1.0 DTD at the top of the ejb-jar xml, so it was getting confused between EJB 1 and EJB 2.
Actions

Go to original post