4 Replies Latest reply on Dec 21, 2004 9:59 AM by Alex Cheong

    ERROR [Fdperson#findByPrimaryKey] Find failed

    Alex Cheong Newbie

      Hi Guru,

      I have the following errors when create a new record by the EJB bean.
      Any idea what's wrong?

      23:13:24,953 INFO [Engine] StandardContext[/Fisicien-ViewController-context-root]No Metho
      d onGoInitForm and no actionBinding goInitForm found.
      23:13:24,968 INFO [STDOUT] sessionid : 352D4EEF8A1B6720E063932EAF79A78A
      23:13:27,875 INFO [Engine] StandardContext[/Fisicien-ViewController-context-root]No Metho
      d onGoSetSession and no actionBinding goSetSession found.
      23:13:27,906 INFO [STDOUT] sessionid : 352D4EEF8A1B6720E063932EAF79A78A
      23:13:29,078 INFO [Engine] StandardContext[/Fisicien-ViewController-context-root]No Metho
      d onGoSetSession and no actionBinding goSetSession found.
      23:13:29,093 INFO [STDOUT] sessionid : 352D4EEF8A1B6720E063932EAF79A78A
      23:13:31,203 INFO [Engine] StandardContext[/Fisicien-ViewController-context-root]No Metho
      d onGoConfirmForm and no actionBinding goConfirmForm found.
      23:13:31,218 INFO [STDOUT] sessionid : 352D4EEF8A1B6720E063932EAF79A78A
      23:13:31,265 ERROR [Fdperson#findByPrimaryKey] Find failed
      java.sql.SQLException: ORA-00904: "T0_FDPERSON"."FDPERSONID": invalid identifier
      
       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
       at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
       at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
       at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
       at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:677)
       at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2371)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:26
      60)
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen
      t.java:457)
       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement
      .java:387)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPr
      eparedStatement.java:314)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQue
      ryCommand.java:206)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQue
      ryCommand.java:128)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.execute(JDBCFindByPrim
      aryKeyQuery.java:128)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityComm
      and.java:47)
       at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.jav
      a:589)
       at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.ja
      va:271)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(Cac
      hedConnectionInterceptor.java:302)
       at org.jboss.ejb.EntityContainer.findSingleObject(EntityContainer.java:1043)
       at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:627)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
      va:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.j
      ava:1070)
       at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:8
      8)
       at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchro
      nizationInterceptor.java:204)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(Cac
      hedConnectionInterceptor.java:215)
       at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:8
      8)
       at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterc
      eptor.java:90)
       at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.ja
      va:61)
       at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterc
      eptor.java:28)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.ja
      va:88)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.jav
      a:343)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:130)
       at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:8
      5)
       at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
       at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFind
      erInterceptor.java:93)
       at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:478)
       at org.jboss.ejb.Container.invoke(Container.java:729)
       at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFact
      ory.java:347)
       at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
       at $Proxy236.findByPrimaryKey(Unknown Source)
       at com.fsc.model.fd.pmi.ejb.FdPersonManagerBean.updateFdPerson(FdPersonManagerBean
      .java:97)
       at com.fsc.model.fd.pmi.ejb.FdPersonManagerBean.updatePersonInfo(FdPersonManagerBe
      an.java:384)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
      va:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSe
      ssionContainer.java:683)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedC
      onnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessi
      onInstanceInterceptor.java:72)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.ja
      va:84)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.jav
      a:317)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:150)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
       at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderIn
      terceptor.java:122)
       at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContaine
      r.java:331)
       at org.jboss.ejb.Container.invoke(Container.java:709)
       at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
      va:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
       at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionIntercep
      tor.java:100)
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
       at $Proxy760.updatePersonInfo(Unknown Source)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAllergies(FdAllergyManag
      erBean.java:425)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
      va:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSe
      ssionContainer.java:683)
       at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedC
      onnectionInterceptor.java:186)
       at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessi
      onInstanceInterceptor.java:72)
       at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.ja
      va:84)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.jav
      a:317)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:150)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
       at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderIn
      terceptor.java:122)
       at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContaine
      r.java:331)
       at org.jboss.ejb.Container.invoke(Container.java:709)
       at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
      va:25)
       at java.lang.reflect.Method.invoke(Method.java:324)
       at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
       at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
       at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
       at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55)
       at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionIntercep
      tor.java:100)
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
       at $Proxy721.addAllergies(Unknown Source)
       at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.ConfirmForm(FdAllergyMainAc
      tion.java:1861)
       at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.findForward(FdAllergyMainAc
      tion.java:209)
       at oracle.adf.controller.struts.actions.DataAction.findForward(DataAction.java:575
      )
       at oracle.adf.controller.lifecycle.PageLifecycle.handleLifecycle(PageLifecycle.jav
      a:152)
       at oracle.adf.controller.struts.actions.StrutsUixLifecycle.handleLifecycle(StrutsU
      ixLifecycle.java:63)
       at oracle.adf.controller.struts.actions.DataAction.handleLifecycle(DataAction.java
      :232)
       at oracle.adf.controller.struts.actions.DataAction.execute(DataAction.java:163)
       at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor
      .java:484)
       at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
       at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
       at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil
      terChain.java:237)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
      .java:157)
       at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:228)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil
      terChain.java:186)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
      .java:157)
       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:
      75)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil
      terChain.java:186)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
      .java:157)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
      214)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:104)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
       at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal
      ve.java:198)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
      152)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:104)
       at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.
      java:66)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:102)
       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociati
      onValve.java:162)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:102)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:104)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:102)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:10
      9)
       at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.j
      ava:104)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
       at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnecti
      on(Http11Protocol.java:705)
       at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:6
      83)
       at java.lang.Thread.run(Thread.java:534)
      23:13:31,281 INFO [STDOUT] javax.ejb.FinderException: Find failed: java.sql.SQLException:
       ORA-00904: "T0_FDPERSON"."FDPERSONID": invalid identifier
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand
      .execute(JDBCAbstractQueryCommand.java:223)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand
      .execute(JDBCAbstractQueryCommand.java:128)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuer
      y.execute(JDBCFindByPrimaryKeyQuery.java:128)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.ex
      ecute(JDBCFindEntityCommand.java:47)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEnt
      ity(JDBCStoreManager.java:589)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(
      CMPPersistenceManager.java:271)
      23:13:31,281 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.findEntity(CachedConnectionInterceptor.java:302)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findSingleObject(EntityCo
      ntainer.java:1043)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer
      .java:627)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      23:13:31,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      23:13:31,281 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invo
      keHome(EntityContainer.java:1070)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Ab
      stractInterceptor.java:88)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.
      invokeHome(EntitySynchronizationInterceptor.java:204)
      23:13:31,281 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invokeHome(CachedConnectionInterceptor.java:215)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Ab
      stractInterceptor.java:88)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeH
      ome(EntityInstanceInterceptor.java:90)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(
      EntityLockInterceptor.java:61)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeH
      ome(EntityCreationInterceptor.java:28)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:88)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:343)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInt
      erceptorCMT.java:130)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Se
      curityInterceptor.java:85)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInte
      rceptor.java:120)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      okeHome(ProxyFactoryFinderInterceptor.java:93)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.EntityContainer.internalInvokeHome(Entity
      Container.java:478)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:729)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invok
      eHome(BaseLocalProxyFactory.java:347)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(Local
      HomeProxy.java:110)
      23:13:31,281 INFO [STDOUT] at $Proxy236.findByPrimaryKey(Unknown Source)
      23:13:31,281 INFO [STDOUT] at com.fsc.model.fd.pmi.ejb.FdPersonManagerBean.updateFdPe
      rson(FdPersonManagerBean.java:97)
      23:13:31,281 INFO [STDOUT] at com.fsc.model.fd.pmi.ejb.FdPersonManagerBean.updatePers
      onInfo(FdPersonManagerBean.java:384)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      23:13:31,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      23:13:31,281 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterc
      eptor.invoke(StatelessSessionContainer.java:683)
      23:13:31,281 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invoke(CachedConnectionInterceptor.java:186)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
      or.invoke(StatelessSessionInstanceInterceptor.java:72)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:84)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:317)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterce
      ptorCMT.java:150)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(Securi
      tyInterceptor.java:111)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercep
      tor.java:191)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      oke(ProxyFactoryFinderInterceptor.java:122)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(
      StatelessSessionContainer.java:331)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
      23:13:31,281 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown S
      ource)
      23:13:31,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      23:13:31,281 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(Reflec
      tedDispatcher.java:60)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :62)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :54)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:8
      2)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Abstrac
      tMBeanInvoker.java:197)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerI
      mpl.java:473)
      23:13:31,281 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInv
      oker.java:97)
      23:13:31,281 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerI
      nterceptor.java:90)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(Transacti
      onInterceptor.java:46)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:55)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(
      StatelessSessionInterceptor.java:100)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.
      java:85)
      23:13:31,281 INFO [STDOUT] at $Proxy760.updatePersonInfo(Unknown Source)
      23:13:31,281 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      Allergies(FdAllergyManagerBean.java:425)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      23:13:31,281 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      23:13:31,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      23:13:31,281 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterc
      eptor.invoke(StatelessSessionContainer.java:683)
      23:13:31,281 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invoke(CachedConnectionInterceptor.java:186)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
      or.invoke(StatelessSessionInstanceInterceptor.java:72)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:84)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:317)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterce
      ptorCMT.java:150)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(Securi
      tyInterceptor.java:111)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercep
      tor.java:191)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      oke(ProxyFactoryFinderInterceptor.java:122)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(
      StatelessSessionContainer.java:331)
      23:13:31,281 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
      23:13:31,281 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown S
      ource)
      23:13:31,281 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      23:13:31,281 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(Reflec
      tedDispatcher.java:60)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :62)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :54)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:8
      2)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Abstrac
      tMBeanInvoker.java:197)
      23:13:31,281 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerI
      mpl.java:473)
      23:13:31,281 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInv
      oker.java:97)
      23:13:31,281 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerI
      nterceptor.java:90)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(Transacti
      onInterceptor.java:46)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:55)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(
      StatelessSessionInterceptor.java:100)
      23:13:31,281 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.
      java:85)
      23:13:31,281 INFO [STDOUT] at $Proxy721.addAllergies(Unknown Source)
      23:13:31,281 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.Con
      firmForm(FdAllergyMainAction.java:1861)
      23:13:31,281 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.fin
      dForward(FdAllergyMainAction.java:209)
      23:13:31,281 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.findFor
      ward(DataAction.java:575)
      23:13:31,281 INFO [STDOUT] at oracle.adf.controller.lifecycle.PageLifecycle.handleLif
      ecycle(PageLifecycle.java:152)
      23:13:31,296 INFO [STDOUT] at oracle.adf.controller.struts.actions.StrutsUixLifecycle
      .handleLifecycle(StrutsUixLifecycle.java:63)
      23:13:31,296 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.handleL
      ifecycle(DataAction.java:232)
      23:13:31,296 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.execute
      (DataAction.java:163)
      23:13:31,296 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processAction
      Perform(RequestProcessor.java:484)
      23:13:31,296 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(Reque
      stProcessor.java:274)
      23:13:31,296 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionSe
      rvlet.java:1482)
      23:13:31,296 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServ
      let.java:507)
      23:13:31,296 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :697)
      23:13:31,296 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :810)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:237)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      23:13:31,296 INFO [STDOUT] at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFB
      indingFilter.java:228)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      23:13:31,296 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter
      (ReplyHeaderFilter.java:75)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(St
      andardWrapperValve.java:214)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInt
      ernal(StandardContextValve.java:198)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(St
      andardContextValve.java:152)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      23:13:31,296 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invo
      ke(CustomPrincipalValve.java:66)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      23:13:31,296 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.
      invoke(SecurityAssociationValve.java:162)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(Stand
      ardHostValve.java:137)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(Erro
      rReportValve.java:118)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(Sta
      ndardEngineValve.java:109)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      23:13:31,296 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(Container
      Base.java:929)
      23:13:31,296 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteA
      dapter.java:160)
      23:13:31,296 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11
      Processor.java:799)
      23:13:31,296 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11Connectio
      nHandler.processConnection(Http11Protocol.java:705)
      23:13:31,296 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTc
      pEndpoint.java:577)
      23:13:31,296 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnab
      le.run(ThreadPool.java:683)
      23:13:31,296 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      


        • 1. Re: ERROR [Fdperson#findByPrimaryKey] Find failed
          micke Novice

          Check your column name in DB. Should it be "T0_FDPERSON.FDPERSONID" instead of "T0_FDPERSON"."FDPERSONID" ?

          Oracle says:
          To be a valid column name the following criteria must be met:
          The column name must begin with a letter.
          The column name can not be longer than 30 characters.
          The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks.
          The column name can not be a reserved word.

          • 2. Re: ERROR [Fdperson#findByPrimaryKey] Find failed
            Alex Cheong Newbie

            Hi,

            Thanks for the reply.
            I think the problem is the table name should be "FDPERSON"."FDPERSONID" intead of "T0_FDPERSON"."FDPERSONID".

            But I could not find the code where the lookup manager generate extra "T0_".

            Any comments?

            • 3. Re: ERROR [Fdperson#findByPrimaryKey] Find failed
              micke Novice

              Do you think posting your xdoclet tags/relevant xml files for your EJB might help?

              • 4. Re: ERROR [Fdperson#findByPrimaryKey] Find failed
                Alex Cheong Newbie

                OK. Thanks for your help!

                orion-ejb-jar.xml

                <?xml version = '1.0' encoding = 'windows-1252'?>
                <!DOCTYPE orion-ejb-jar PUBLIC "-//Evermind//DTD Enterprise JavaBeans 1.1 runtime//EN" "http://xmlns.oracle.com/ias/dtds/orion-ejb-jar.dtd">
                <orion-ejb-jar>
                 <enterprise-beans>
                 <session-deployment name="FdAllergyManager"/>
                 <entity-deployment name="Fddrugallergy" data-source="java:/jdbc/FisicienCoreDS" table="FISICIEN.FDDRUGALLERGY">
                 <primkey-mapping>
                 <cmp-field-mapping name="fddrugallergyId" persistence-name="FDDRUGALLERGY_ID" persistence-type="NUMBER(38)"/>
                 </primkey-mapping>
                 <cmp-field-mapping name="fddrugallergyId" persistence-name="FDDRUGALLERGY_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="fdpersonId" persistence-name="FDPERSON_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="gngenericdrugId" persistence-name="GNGENERICDRUG_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="system" persistence-name="SYSTEM" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="route" persistence-name="ROUTE" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="probability" persistence-name="PROBABILITY" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="reaction" persistence-name="REACTION" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="activeInd" persistence-name="ACTIVE_IND" persistence-type="CHAR(1)"/>
                 <cmp-field-mapping name="enteredBy" persistence-name="ENTERED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="enteredDatetime" persistence-name="ENTERED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="prevUpdatedBy" persistence-name="PREV_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="prevUpdatedDatetime" persistence-name="PREV_UPDATED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="lastUpdatedBy" persistence-name="LAST_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="lastUpdatedDatetime" persistence-name="LAST_UPDATED_DATETIME" persistence-type="DATE"/>
                 </entity-deployment>
                 <entity-deployment name="Fdmedicalalert" data-source="java:/jdbc/FisicienCoreDS" table="FISICIEN.FDMEDICALALERT">
                 <primkey-mapping>
                 <cmp-field-mapping name="fdmedicalalertId" persistence-name="FDMEDICALALERT_ID" persistence-type="NUMBER(38)"/>
                 </primkey-mapping>
                 <cmp-field-mapping name="fdmedicalalertId" persistence-name="FDMEDICALALERT_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="fdpersonId" persistence-name="FDPERSON_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="medicalAlert" persistence-name="MEDICAL_ALERT" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="indicator" persistence-name="INDICATOR" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="activeInd" persistence-name="ACTIVE_IND" persistence-type="CHAR(1)"/>
                 <cmp-field-mapping name="enteredBy" persistence-name="ENTERED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="enteredDatetime" persistence-name="ENTERED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="prevUpdatedBy" persistence-name="PREV_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="prevUpdatedDatetime" persistence-name="PREV_UPDATED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="lastUpdatedBy" persistence-name="LAST_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="lastUpdatedDatetime" persistence-name="LAST_UPDATED_DATETIME" persistence-type="DATE"/>
                 </entity-deployment>
                 <entity-deployment name="Fdnondrugallergy" data-source="java:/jdbc/FisicienCoreDS" table="FISICIEN.FDNONDRUGALLERGY">
                 <primkey-mapping>
                 <cmp-field-mapping name="fdnondrugallergyId" persistence-name="FDNONDRUGALLERGY_ID" persistence-type="NUMBER(38)"/>
                 </primkey-mapping>
                 <cmp-field-mapping name="fdnondrugallergyId" persistence-name="FDNONDRUGALLERGY_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="fdpersonId" persistence-name="FDPERSON_ID" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="allergyType" persistence-name="ALLERGY_TYPE" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="allergyDescription" persistence-name="ALLERGY_DESCRIPTION" persistence-type="VARCHAR2(100)"/>
                 <cmp-field-mapping name="reaction" persistence-name="REACTION" persistence-type="VARCHAR2(5)"/>
                 <cmp-field-mapping name="activeInd" persistence-name="ACTIVE_IND" persistence-type="CHAR(1)"/>
                 <cmp-field-mapping name="enteredBy" persistence-name="ENTERED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="enteredDatetime" persistence-name="ENTERED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="prevUpdatedBy" persistence-name="PREV_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="prevUpdatedDatetime" persistence-name="PREV_UPDATED_DATETIME" persistence-type="DATE"/>
                 <cmp-field-mapping name="lastUpdatedBy" persistence-name="LAST_UPDATED_BY" persistence-type="NUMBER(38)"/>
                 <cmp-field-mapping name="lastUpdatedDatetime" persistence-name="LAST_UPDATED_DATETIME" persistence-type="DATE"/>
                 </entity-deployment>
                 </enterprise-beans>
                </orion-ejb-jar>
                


                FdAllergyManager.java
                package com.fsc.model.fd.fdallergy.ejb;
                import com.fsc.model.fd.pmi.FdPersonInfoModel;
                import javax.ejb.EJBObject;
                import java.rmi.RemoteException;
                import java.util.Vector;
                import com.fsc.model.fd.fdallergy.FdDrugAllergyInfoModel;
                import com.fsc.model.fd.fdallergy.FdNonDrugAllergyInfoModel;
                import com.fsc.model.fd.fdallergy.FdMedicalAlertInfoModel;
                
                public interface FdAllergyManager extends EJBObject
                {
                
                
                 public void addDrugAllergy(String sessionId, Vector vInfoModel2) throws RemoteException;
                
                 public void addNonDrugAllergy(String sessionId, Vector vInfoModel3) throws RemoteException;
                
                
                
                 void addDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel) throws RemoteException;
                
                 void addAlert(String sessionId, FdMedicalAlertInfoModel infoModel) throws RemoteException;
                
                 void addNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel) throws RemoteException;
                
                 void updateAlert(String sessionId, FdMedicalAlertInfoModel infoModel) throws RemoteException;
                
                 void updateDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel) throws RemoteException;
                
                 void updateNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel) throws RemoteException;
                
                 void addAlert(String sessionId, Vector vInfoModel) throws RemoteException;
                
                 void addAllergies(String sessionid, Vector vMedicalAlertInfoModel, Vector vDrugAllergyInfoModel, Vector vNonDrugAllergyInfoModel, FdPersonInfoModel infomodel) throws RemoteException;
                
                
                }
                


                FdAllergyManagerHome.java
                package com.fsc.model.fd.fdallergy.ejb;
                import javax.ejb.EJBHome;
                import java.rmi.RemoteException;
                import javax.ejb.CreateException;
                
                public interface FdAllergyManagerHome extends EJBHome
                {
                 FdAllergyManager create() throws RemoteException, CreateException;
                }
                


                FdAllergyManagerLocal.java
                package com.fsc.model.fd.fdallergy.ejb;
                import com.fsc.model.fd.pmi.FdPersonInfoModel;
                import javax.ejb.EJBLocalObject;
                import java.util.Vector;
                import com.fsc.model.fd.fdallergy.FdDrugAllergyInfoModel;
                import com.fsc.model.fd.fdallergy.FdNonDrugAllergyInfoModel;
                import com.fsc.model.fd.fdallergy.FdMedicalAlertInfoModel;
                
                public interface FdAllergyManagerLocal extends EJBLocalObject
                {
                
                
                
                 public void addDrugAllergy(String sessionId, Vector vInfoModel2);
                
                 public void addNonDrugAllergy(String sessionId, Vector vInfoModel3);
                
                
                
                 void addDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel);
                
                 void addAlert(String sessionId, FdMedicalAlertInfoModel infoModel);
                
                 void addNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel);
                
                 void updateAlert(String sessionId, FdMedicalAlertInfoModel infoModel);
                
                 void updateDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel);
                
                 void updateNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel);
                
                 void addAlert(String sessionId, Vector vInfoModel);
                
                 void addAllergies(String sessionid, Vector vMedicalAlertInfoModel, Vector vDrugAllergyInfoModel, Vector vNonDrugAllergyInfoModel, FdPersonInfoModel infomodel);
                
                
                }
                


                FdAllergyManagerLocalHome.java
                package com.fsc.model.fd.fdallergy.ejb;
                import javax.ejb.EJBLocalHome;
                import javax.ejb.CreateException;
                
                public interface FdAllergyManagerLocalHome extends EJBLocalHome
                {
                 FdAllergyManagerLocal create() throws CreateException;
                }
                


                FdAllergyManagerBean.java
                package com.fsc.model.fd.fdallergy.ejb;
                import com.fsc.model.fd.fdallergy.FdDrugAllergyInfoModel;
                import com.fsc.model.fd.fdallergy.FdMedicalAlertInfoModel;
                import com.fsc.model.fd.fdallergy.FdNonDrugAllergyInfoModel;
                import com.fsc.model.fd.pmi.FdPersonInfoModel;
                import com.fsc.model.fd.pmi.ejb.FdPatientManagerHome;
                import com.fsc.model.fd.pmi.ejb.FdPersonManager;
                import com.fsc.model.fd.pmi.ejb.FdPersonManagerHome;
                import com.fsc.util.ejb.EJBService;
                import com.fsc.util.lang.DateUtilities;
                import com.fsc.util.sequence.SequenceFactory;
                import com.fsc.util.session.FSCSession;
                import com.fsc.util.session.SessionManager;
                import java.util.Iterator;
                import java.util.Vector;
                import javax.ejb.SessionBean;
                import javax.ejb.SessionContext;
                import javax.naming.InitialContext;
                import javax.naming.NamingException;
                
                public class FdAllergyManagerBean implements SessionBean
                {
                 public void ejbCreate()
                 {
                 }
                
                 public void ejbActivate()
                 {
                 }
                
                 public void ejbPassivate()
                 {
                 }
                
                 public void ejbRemove()
                 {
                 }
                
                 public void setSessionContext(SessionContext ctx)
                 {
                 }
                
                 private FddrugallergyLocalHome getFddrugallergyLocalHome() throws NamingException
                 {
                 final InitialContext context = new InitialContext();
                 return (FddrugallergyLocalHome)context.lookup("java:comp/env/ejb/local/Fddrugallergy");
                 }
                
                 private FdmedicalalertLocalHome getFdmedicalalertLocalHome() throws NamingException
                 {
                 final InitialContext context = new InitialContext();
                 return (FdmedicalalertLocalHome)context.lookup("java:comp/env/ejb/local/Fdmedicalalert");
                 }
                
                 private FdnondrugallergyLocalHome getFdnondrugallergyLocalHome() throws NamingException
                 {
                 final InitialContext context = new InitialContext();
                 return (FdnondrugallergyLocalHome)context.lookup("java:comp/env/ejb/local/Fdnondrugallergy");
                 }
                
                 private FSCSession getSessionObject(String sessionId) throws Exception
                 {
                 return SessionManager.getInstance().getSessionObject(sessionId);
                 }
                
                
                 private void addMedicalAlert(String sessionId, FdmedicalalertLocalDTO dTO)
                 {
                 try
                 {
                 FdmedicalalertLocalHome fdmedicalalertLocalHome = (FdmedicalalertLocalHome)getFdmedicalalertLocalHome();
                
                
                 dTO.setFdmedicalalertId(new Long(SequenceFactory.getFactory().getNextNumber(sessionId,"SQ_GLOBAL_SEQUENCE")));
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 //dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 //dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                
                 //for insert
                 FdmedicalalertLocal fdmedicalalertLocal = fdmedicalalertLocalHome.create(dTO);
                 }
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 private void addFdDrugAllergy(String sessionId, FddrugallergyLocalDTO dTO)
                 {
                 try
                 {
                 FddrugallergyLocalHome fddrugallergyLocalHome = (FddrugallergyLocalHome)getFddrugallergyLocalHome();
                
                
                 dTO.setFddrugallergyId(new Long(SequenceFactory.getFactory().getNextNumber(sessionId,"SQ_GLOBAL_SEQUENCE")));
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 //dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 //dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                
                 //for insert
                 FddrugallergyLocal fddrugallergyLocal = fddrugallergyLocalHome.create(dTO);
                 }
                
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 private void addFdNonDrugAllergy(String sessionId, FdnondrugallergyLocalDTO dTO)
                 {
                 try
                 {
                 FdnondrugallergyLocalHome fdnondrugallergyLocalHome = (FdnondrugallergyLocalHome)getFdnondrugallergyLocalHome();
                
                
                 dTO.setFdnondrugallergyId(new Long(SequenceFactory.getFactory().getNextNumber(sessionId,"SQ_GLOBAL_SEQUENCE")));
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 //dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 //dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                
                 //for insert
                 FdnondrugallergyLocal fdnondrugallergyLocal = fdnondrugallergyLocalHome.create(dTO);
                 }
                
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 private void updateMedicalAlert(String sessionId, FdmedicalalertLocalDTO dTO)
                 {
                 try
                 {
                 FdmedicalalertLocalHome fdmedicalalertLocalHome = (FdmedicalalertLocalHome)getFdmedicalalertLocalHome();
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 FdmedicalalertLocal fdmedicalalertLocal = fdmedicalalertLocalHome.findByPrimaryKey(dTO.getFdmedicalalertId());
                
                 if(dTO._getActiveInd()==true)
                 fdmedicalalertLocal.setActiveInd(dTO.getActiveInd());
                 if(dTO._getFdpersonId()==true)
                 fdmedicalalertLocal.setFdpersonId(dTO.getFdpersonId());
                 if(dTO._getIndicator()==true)
                 fdmedicalalertLocal.setIndicator(dTO.getIndicator());
                 if(dTO._getMedicalAlert()==true)
                 fdmedicalalertLocal.setMedicalAlert(dTO.getMedicalAlert());
                
                 if(dTO.getLastUpdatedBy()!=null && dTO.getLastUpdatedDatetime()!=null)
                 {
                 dTO.setPrevUpdatedBy(dTO.getLastUpdatedBy());
                 dTO.setPrevUpdatedDatetime(dTO.getLastUpdatedDatetime());
                 }
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                 }
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 private void updateFdDrugAllergy(String sessionId, FddrugallergyLocalDTO dTO)
                 {
                 try
                 {
                 FddrugallergyLocalHome fddrugallergyLocalHome = (FddrugallergyLocalHome)getFddrugallergyLocalHome();
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 FddrugallergyLocal fddrugallergyLocal = fddrugallergyLocalHome.findByPrimaryKey(dTO.getFddrugallergyId());
                
                 if(dTO._getActiveInd()==true)
                 fddrugallergyLocal.setActiveInd(dTO.getActiveInd());
                 if(dTO._getGngenericdrugId()==true)
                 fddrugallergyLocal.setGngenericdrugId(dTO.getGngenericdrugId());
                 if(dTO._getFdpersonId()==true)
                 fddrugallergyLocal.setFdpersonId(dTO.getFdpersonId());
                 if(dTO._getGngenericdrugId()==true)
                 fddrugallergyLocal.setGngenericdrugId(dTO.getGngenericdrugId());
                 if(dTO._getSystem()==true)
                 fddrugallergyLocal.setSystem(dTO.getSystem());
                 if(dTO._getRoute()==true)
                 fddrugallergyLocal.setRoute(dTO.getRoute());
                 if(dTO._getProbability()==true)
                 fddrugallergyLocal.setProbability(dTO.getProbability());
                 if(dTO._getReaction()==true)
                 fddrugallergyLocal.setReaction(dTO.getReaction());
                
                 if(dTO.getLastUpdatedBy()!=null && dTO.getLastUpdatedDatetime()!=null)
                 {
                 dTO.setPrevUpdatedBy(dTO.getLastUpdatedBy());
                 dTO.setPrevUpdatedDatetime(dTO.getLastUpdatedDatetime());
                 }
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                 }
                
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 private void updateFdNonDrugAllergy(String sessionId, FdnondrugallergyLocalDTO dTO)
                 {
                 try
                 {
                 FdnondrugallergyLocalHome fdnondrugallergyLocalHome = (FdnondrugallergyLocalHome)getFdnondrugallergyLocalHome();
                 FSCSession sessionObject = getSessionObject(sessionId);
                
                 FdnondrugallergyLocal fdnondrugallergyLocal = fdnondrugallergyLocalHome.findByPrimaryKey(dTO.getFdnondrugallergyId());
                
                 if(dTO._getActiveInd()==true)
                 fdnondrugallergyLocal.setActiveInd(dTO.getActiveInd());
                 if(dTO._getFdpersonId()==true)
                 fdnondrugallergyLocal.setFdpersonId(dTO.getFdpersonId());
                 if(dTO._getAllergyType()==true)
                 fdnondrugallergyLocal.setAllergyType(dTO.getAllergyType());
                 if(dTO._getReaction()==true)
                 fdnondrugallergyLocal.setReaction(dTO.getReaction());
                
                 if(dTO.getLastUpdatedBy()!=null && dTO.getLastUpdatedDatetime()!=null)
                 {
                 dTO.setPrevUpdatedBy(dTO.getLastUpdatedBy());
                 dTO.setPrevUpdatedDatetime(dTO.getLastUpdatedDatetime());
                 }
                
                 dTO.setEnteredBy(sessionObject.getUsermstrId());
                 dTO.setEnteredDatetime(DateUtilities.getCurrentSystemDate());
                 dTO.setLastUpdatedBy(sessionObject.getUsermstrId());
                 dTO.setLastUpdatedDatetime(DateUtilities.getCurrentSystemDate());
                 }
                
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 public void addAlert(String sessionId, Vector vInfoModel)
                 {
                 try
                 {
                 if (vInfoModel != null)
                 {
                 for (int i = 0; i < vInfoModel.size(); i++)
                 {
                 FdMedicalAlertInfoModel fdMedicalAlertInfoModel = (FdMedicalAlertInfoModel) vInfoModel.get(i);
                 FdmedicalalertLocalDTO fdmedicalalertDTO = fdMedicalAlertInfoModel.getFdmedicalalertLocalDTO();
                
                 if (fdMedicalAlertInfoModel.getFdmedicalalertId() != null)
                 {
                 updateMedicalAlert(sessionId, fdmedicalalertDTO);
                 }
                 else
                 {
                 addMedicalAlert(sessionId, fdmedicalalertDTO);
                 }
                 }
                 }
                 }
                 catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void addDrugAllergy(String sessionId, Vector vInfoModel2)
                 {
                 try
                 {
                 if (vInfoModel2 != null)
                 {
                 for (int i = 0; i < vInfoModel2.size(); i++)
                 {
                 FdDrugAllergyInfoModel fddrugAllergyInfoModel = (FdDrugAllergyInfoModel) vInfoModel2.get(i);
                 FddrugallergyLocalDTO fddrugalleryDTO = fddrugAllergyInfoModel.getFddrugallergyLocalDTO();
                
                 if (fddrugAllergyInfoModel.getFddrugallergyId() != null)
                 {
                 updateFdDrugAllergy(sessionId, fddrugalleryDTO);
                 }
                 else
                 {
                 addFdDrugAllergy(sessionId, fddrugalleryDTO);
                 }
                 }
                 }
                 }
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                 public void addNonDrugAllergy(String sessionId, Vector vInfoModel3)
                 {
                 try
                 {
                 if (vInfoModel3 != null)
                 {
                 for (int i = 0; i < vInfoModel3.size(); i++)
                 {
                 FdNonDrugAllergyInfoModel fdnondrugAllergyInfoModel = (FdNonDrugAllergyInfoModel) vInfoModel3.get(i);
                 FdnondrugallergyLocalDTO fdnondrugalleryDTO = fdnondrugAllergyInfoModel.getFdnondrugallergyLocalDTO();
                
                 if (fdnondrugAllergyInfoModel.getFdnondrugallergyId() != null)
                 {
                 updateFdNonDrugAllergy(sessionId, fdnondrugalleryDTO);
                 }
                 else
                 {
                 addFdNonDrugAllergy(sessionId, fdnondrugalleryDTO);
                 }
                 }
                 }
                 }
                
                 catch(Exception e)
                 {
                 e.printStackTrace();
                 }
                 }
                
                
                
                
                 public void addDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel)
                 {
                 try{
                
                 FddrugallergyLocalDTO fddrugallergyLocalDTO = infoModel.getFddrugallergyLocalDTO();
                 addFdDrugAllergy(sessionId,fddrugallergyLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void addAlert(String sessionId, FdMedicalAlertInfoModel infoModel)
                 {
                 try{
                
                 FdmedicalalertLocalDTO fdmedicalalertLocalDTO = infoModel.getFdmedicalalertLocalDTO();
                 addMedicalAlert(sessionId,fdmedicalalertLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void addNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel)
                 {
                 try{
                
                 FdnondrugallergyLocalDTO fdnondrugallergyLocalDTO = infoModel.getFdnondrugallergyLocalDTO();
                 addFdNonDrugAllergy(sessionId,fdnondrugallergyLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void updateAlert(String sessionId, FdMedicalAlertInfoModel infoModel)
                 {
                 try{
                
                 FdmedicalalertLocalDTO fdmedicalalertLocalDTO = infoModel.getFdmedicalalertLocalDTO();
                 updateMedicalAlert(sessionId,fdmedicalalertLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void updateDrugAllergy(String sessionId, FdDrugAllergyInfoModel infoModel)
                 {
                 try{
                
                 FddrugallergyLocalDTO fddrugallergyLocalDTO = infoModel.getFddrugallergyLocalDTO();
                 updateFdDrugAllergy(sessionId,fddrugallergyLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void updateNonDrugAllergy(String sessionId, FdNonDrugAllergyInfoModel infoModel)
                 {
                 try{
                
                 FdnondrugallergyLocalDTO fdnondrugallergyLocalDTO = infoModel.getFdnondrugallergyLocalDTO();
                 updateFdNonDrugAllergy(sessionId,fdnondrugallergyLocalDTO);
                
                 } catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                 public void addAllergies(String sessionid, Vector vMedicalAlertInfoModel, Vector vDrugAllergyInfoModel, Vector vNonDrugAllergyInfoModel, FdPersonInfoModel infomodel)
                 {
                 try
                 {
                 addAlert(sessionid, vMedicalAlertInfoModel);
                 addDrugAllergy(sessionid, vDrugAllergyInfoModel);
                 addNonDrugAllergy(sessionid, vNonDrugAllergyInfoModel);
                
                 System.out.println("*********** After addNonDrugAllergy ***********");
                
                 //FdPersonManager manager = (FdPersonManager) EJBService.getFactory().lookUpManager("FdPersonManager",FdPersonManagerHome.class);
                
                 //manager.updatePersonInfo(sessionid,infomodel);
                
                 }
                 catch(Exception e){
                 e.printStackTrace();
                 }
                 }
                
                
                }