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

    ClassCastException: JDBCCMP1xFieldBridge

    Chris Bitmead Newbie

      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>
      <!-- <unknown-pk>
      <unknown-pk-class>au.gov.ag.SpAgreementYearPK</unknown-pk-class>
      <field-name>emailId</field-name>
      <column-name>EMAIL_ID</column-name>
      <jdbc-type>Integer</jdbc-type>
      <sql-type>Integer</sql-type>
      </unknown-pk> -->

      </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>