7 Replies Latest reply on Dec 21, 2004 12:22 PM by alexcheong

    jboss-3.2.7RC1 - Unable to execute remote method.

    alexcheong

      Hi Guru,

      My project was developed by using JDeveloper10g.

      I have deployed the EAR file to jboss-3.2.7RC1.

      The issue is when why JBOSS will add additional prefix to the table name whenever the create method has been invoked.

      It's work well using embedded OC4J AS provided by the IDE.

      Error Logs

      01:12:17,734 ERROR [CmsequenceManagerBean] Encountered unexpected exception : javax.ejb.Fi
      nderException: Find failed: java.sql.SQLException: ORA-00904: "T0_CMSEQUENCE"."SEQUENCEID"
      : invalid identifier
      
      01:12:17,734 ERROR [CmsequenceManagerBean] Encountered unexpected exception :
      javax.transaction.SystemException: Encountered unexpected exception
       at com.fsc.model.cm.sequence.ejb.CmsequenceManagerBean.getNextNumber(CmsequenceMan
      agerBean.java:388)
       at com.fsc.model.cm.sequence.ejb.CmsequenceManagerBean.getNextNumber(CmsequenceMan
      agerBean.java:89)
       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.GeneratedMethodAccessor146.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 $Proxy706.getNextNumber(Unknown Source)
       at com.fsc.util.sequence.SequenceFactory.getNextNumber(SequenceFactory.java:122)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addMedicalAlert(FdAllergyMa
      nagerBean.java:74)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAlert(FdAllergyManagerBe
      an.java:273)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAllergies(FdAllergyManag
      erBean.java:419)
       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.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.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)
      01:12:17,750 ERROR [SequenceFactory] Unable to execute remote method
      javax.transaction.SystemException: Encountered unexpected exception
       at com.fsc.model.cm.sequence.ejb.CmsequenceManagerBean.getNextNumber(CmsequenceMan
      agerBean.java:148)
       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.GeneratedMethodAccessor146.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 $Proxy706.getNextNumber(Unknown Source)
       at com.fsc.util.sequence.SequenceFactory.getNextNumber(SequenceFactory.java:122)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addMedicalAlert(FdAllergyMa
      nagerBean.java:74)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAlert(FdAllergyManagerBe
      an.java:273)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAllergies(FdAllergyManag
      erBean.java:419)
       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.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.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)
      01:12:17,750 INFO [STDOUT] javax.transaction.SystemException: Unable to get home object
      01:12:17,750 INFO [STDOUT] at com.fsc.util.sequence.SequenceFactory.getNextNumber(Seq
      uenceFactory.java:129)
      01:12:17,750 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      MedicalAlert(FdAllergyManagerBean.java:74)
      01:12:17,750 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      Alert(FdAllergyManagerBean.java:273)
      01:12:17,750 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      Allergies(FdAllergyManagerBean.java:419)
      01:12:17,750 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      01:12:17,750 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      01:12:17,750 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      01:12:17,750 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterc
      eptor.invoke(StatelessSessionContainer.java:683)
      01:12:17,750 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invoke(CachedConnectionInterceptor.java:186)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
      or.invoke(StatelessSessionInstanceInterceptor.java:72)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:84)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:317)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterce
      ptorCMT.java:150)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(Securi
      tyInterceptor.java:111)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercep
      tor.java:191)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      oke(ProxyFactoryFinderInterceptor.java:122)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(
      StatelessSessionContainer.java:331)
      01:12:17,750 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
      01:12:17,750 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      01:12:17,750 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      01:12:17,750 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      01:12:17,750 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(Reflec
      tedDispatcher.java:60)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :62)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :54)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:8
      2)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Abstrac
      tMBeanInvoker.java:197)
      01:12:17,750 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerI
      mpl.java:473)
      01:12:17,750 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInv
      oker.java:97)
      01:12:17,750 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerI
      nterceptor.java:90)
      01:12:17,750 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(Transacti
      onInterceptor.java:46)
      01:12:17,750 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:55)
      01:12:17,750 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(
      StatelessSessionInterceptor.java:100)
      01:12:17,750 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.
      java:85)
      01:12:17,750 INFO [STDOUT] at $Proxy721.addAllergies(Unknown Source)
      01:12:17,750 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.Con
      firmForm(FdAllergyMainAction.java:1861)
      01:12:17,750 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.fin
      dForward(FdAllergyMainAction.java:209)
      01:12:17,750 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.findFor
      ward(DataAction.java:575)
      01:12:17,750 INFO [STDOUT] at oracle.adf.controller.lifecycle.PageLifecycle.handleLif
      ecycle(PageLifecycle.java:152)
      01:12:17,750 INFO [STDOUT] at oracle.adf.controller.struts.actions.StrutsUixLifecycle
      .handleLifecycle(StrutsUixLifecycle.java:63)
      01:12:17,750 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.handleL
      ifecycle(DataAction.java:232)
      01:12:17,750 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.execute
      (DataAction.java:163)
      01:12:17,750 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processAction
      Perform(RequestProcessor.java:484)
      01:12:17,750 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(Reque
      stProcessor.java:274)
      01:12:17,750 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionSe
      rvlet.java:1482)
      01:12:17,750 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServ
      let.java:507)
      01:12:17,750 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :697)
      01:12:17,750 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :810)
      01:12:17,750 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:237)
      01:12:17,750 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,750 INFO [STDOUT] at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFB
      indingFilter.java:228)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,765 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter
      (ReplyHeaderFilter.java:75)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(St
      andardWrapperValve.java:214)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInt
      ernal(StandardContextValve.java:198)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(St
      andardContextValve.java:152)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,765 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invo
      ke(CustomPrincipalValve.java:66)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,765 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.
      invoke(SecurityAssociationValve.java:162)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(Stand
      ardHostValve.java:137)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(Erro
      rReportValve.java:118)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(Sta
      ndardEngineValve.java:109)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,765 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(Container
      Base.java:929)
      01:12:17,765 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteA
      dapter.java:160)
      01:12:17,765 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11
      Processor.java:799)
      01:12:17,765 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11Connectio
      nHandler.processConnection(Http11Protocol.java:705)
      01:12:17,765 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTc
      pEndpoint.java:577)
      01:12:17,765 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnab
      le.run(ThreadPool.java:683)
      01:12:17,765 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      01:12:17,765 ERROR [Fdmedicalalert#findByPrimaryKey] Find failed
      java.sql.SQLException: ORA-00904: "T0_FDMEDICALALERT"."FDMEDICALALERTID": invalid identifi
      er
      
       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 $Proxy198.findByPrimaryKey(Unknown Source)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.updateMedicalAlert(FdAllerg
      yManagerBean.java:148)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAlert(FdAllergyManagerBe
      an.java:269)
       at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.addAllergies(FdAllergyManag
      erBean.java:419)
       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.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.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)
      01:12:17,781 INFO [STDOUT] javax.ejb.FinderException: Find failed: java.sql.SQLException:
       ORA-00904: "T0_FDMEDICALALERT"."FDMEDICALALERTID": invalid identifier
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand
      .execute(JDBCAbstractQueryCommand.java:223)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand
      .execute(JDBCAbstractQueryCommand.java:128)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuer
      y.execute(JDBCFindByPrimaryKeyQuery.java:128)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.ex
      ecute(JDBCFindEntityCommand.java:47)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEnt
      ity(JDBCStoreManager.java:589)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(
      CMPPersistenceManager.java:271)
      01:12:17,781 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.findEntity(CachedConnectionInterceptor.java:302)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findSingleObject(EntityCo
      ntainer.java:1043)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer
      .java:627)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      01:12:17,781 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      01:12:17,781 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invo
      keHome(EntityContainer.java:1070)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Ab
      stractInterceptor.java:88)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.
      invokeHome(EntitySynchronizationInterceptor.java:204)
      01:12:17,781 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invokeHome(CachedConnectionInterceptor.java:215)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Ab
      stractInterceptor.java:88)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeH
      ome(EntityInstanceInterceptor.java:90)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(
      EntityLockInterceptor.java:61)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeH
      ome(EntityCreationInterceptor.java:28)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:88)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:343)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInt
      erceptorCMT.java:130)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Se
      curityInterceptor.java:85)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInte
      rceptor.java:120)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      okeHome(ProxyFactoryFinderInterceptor.java:93)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.EntityContainer.internalInvokeHome(Entity
      Container.java:478)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:729)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invok
      eHome(BaseLocalProxyFactory.java:347)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(Local
      HomeProxy.java:110)
      01:12:17,781 INFO [STDOUT] at $Proxy198.findByPrimaryKey(Unknown Source)
      01:12:17,781 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.upd
      ateMedicalAlert(FdAllergyManagerBean.java:148)
      01:12:17,781 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      Alert(FdAllergyManagerBean.java:269)
      01:12:17,781 INFO [STDOUT] at com.fsc.model.fd.fdallergy.ejb.FdAllergyManagerBean.add
      Allergies(FdAllergyManagerBean.java:419)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      01:12:17,781 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      01:12:17,781 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterc
      eptor.invoke(StatelessSessionContainer.java:683)
      01:12:17,781 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionIn
      terceptor.invoke(CachedConnectionInterceptor.java:186)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
      or.invoke(StatelessSessionInstanceInterceptor.java:72)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(
      AbstractTxInterceptor.java:84)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
      ons(TxInterceptorCMT.java:317)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterce
      ptorCMT.java:150)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(Securi
      tyInterceptor.java:111)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercep
      tor.java:191)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.inv
      oke(ProxyFactoryFinderInterceptor.java:122)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(
      StatelessSessionContainer.java:331)
      01:12:17,781 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met
      hod)
      01:12:17,781 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMetho
      dAccessorImpl.java:39)
      01:12:17,781 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat
      ingMethodAccessorImpl.java:25)
      01:12:17,781 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(Reflec
      tedDispatcher.java:60)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :62)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java
      :54)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:8
      2)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(Abstrac
      tMBeanInvoker.java:197)
      01:12:17,781 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerI
      mpl.java:473)
      01:12:17,781 INFO [STDOUT] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInv
      oker.java:97)
      01:12:17,781 INFO [STDOUT] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerI
      nterceptor.java:90)
      01:12:17,781 INFO [STDOUT] at org.jboss.proxy.TransactionInterceptor.invoke(Transacti
      onInterceptor.java:46)
      01:12:17,781 INFO [STDOUT] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:55)
      01:12:17,781 INFO [STDOUT] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(
      StatelessSessionInterceptor.java:100)
      01:12:17,781 INFO [STDOUT] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.
      java:85)
      01:12:17,781 INFO [STDOUT] at $Proxy721.addAllergies(Unknown Source)
      01:12:17,781 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.Con
      firmForm(FdAllergyMainAction.java:1861)
      01:12:17,781 INFO [STDOUT] at com.fsc.controller.fd.fdallergy.FdAllergyMainAction.fin
      dForward(FdAllergyMainAction.java:209)
      01:12:17,781 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.findFor
      ward(DataAction.java:575)
      01:12:17,781 INFO [STDOUT] at oracle.adf.controller.lifecycle.PageLifecycle.handleLif
      ecycle(PageLifecycle.java:152)
      01:12:17,781 INFO [STDOUT] at oracle.adf.controller.struts.actions.StrutsUixLifecycle
      .handleLifecycle(StrutsUixLifecycle.java:63)
      01:12:17,781 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.handleL
      ifecycle(DataAction.java:232)
      01:12:17,796 INFO [STDOUT] at oracle.adf.controller.struts.actions.DataAction.execute
      (DataAction.java:163)
      01:12:17,796 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processAction
      Perform(RequestProcessor.java:484)
      01:12:17,796 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(Reque
      stProcessor.java:274)
      01:12:17,796 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionSe
      rvlet.java:1482)
      01:12:17,796 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServ
      let.java:507)
      01:12:17,796 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :697)
      01:12:17,796 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java
      :810)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:237)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,796 INFO [STDOUT] at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFB
      indingFilter.java:228)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,796 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter
      (ReplyHeaderFilter.java:75)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.interna
      lDoFilter(ApplicationFilterChain.java:186)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilte
      r(ApplicationFilterChain.java:157)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(St
      andardWrapperValve.java:214)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInt
      ernal(StandardContextValve.java:198)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(St
      andardContextValve.java:152)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,796 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invo
      ke(CustomPrincipalValve.java:66)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,796 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.
      invoke(SecurityAssociationValve.java:162)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(Stand
      ardHostValve.java:137)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(Erro
      rReportValve.java:118)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:102)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(Sta
      ndardEngineValve.java:109)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNex
      t(StandardValveContext.java:104)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(Standa
      rdPipeline.java:520)
      01:12:17,796 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(Container
      Base.java:929)
      01:12:17,796 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteA
      dapter.java:160)
      01:12:17,796 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11
      Processor.java:799)
      01:12:17,796 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11Connectio
      nHandler.processConnection(Http11Protocol.java:705)
      01:12:17,796 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTc
      pEndpoint.java:577)
      01:12:17,796 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnab
      le.run(ThreadPool.java:683)
      01:12:17,796 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
      01:12:17,796 INFO [STDOUT] *********** After addNonDrugAllergy ***********
      01:15:26,593 WARN [Context] Unable to perform background process on manager
      java.lang.NullPointerException
       at oracle.adf.model.BindingContext.valuesIterator(BindingContext.java:293)
       at oracle.adf.model.BindingContext.release(BindingContext.java:190)
       at oracle.adf.model.servlet.HttpBindingContext.valueUnbound(HttpBindingContext.jav
      a:27)
       at org.apache.catalina.session.StandardSession.removeAttributeInternal(StandardSes
      sion.java:1569)
       at org.apache.catalina.session.StandardSession.expire(StandardSession.java:711)
       at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:569)
       at org.apache.catalina.session.StandardManager.processExpires(StandardManager.java
      :782)
       at org.apache.catalina.session.StandardManager.backgroundProcess(StandardManager.j
      ava:795)
       at org.apache.catalina.core.StandardContext.backgroundProcess(StandardContext.java
      :4647)
       at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChil
      dren(ContainerBase.java:1619)
       at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChil
      dren(ContainerBase.java:1628)
       at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChil
      dren(ContainerBase.java:1628)
       at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Contain
      erBase.java:1608)
       at java.lang.Thread.run(Thread.java:534)
      


      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="CmsequenceManager"/>
       <session-deployment name="CmPatientBarManager"/>
       <entity-deployment name="Cmsequence" data-source="java:/jdbc/FisicienCoreDS" table="FISICIEN.CMSEQUENCE">
       <primkey-mapping>
       <cmp-field-mapping name="sequenceId" persistence-name="SEQUENCE_ID" persistence-type="VARCHAR2(20)"/>
       </primkey-mapping>
       <cmp-field-mapping name="sequenceId" persistence-name="SEQUENCE_ID" persistence-type="VARCHAR2(20)"/>
       <cmp-field-mapping name="currentNo" persistence-name="CURRENT_NO" persistence-type="NUMBER(38)"/>
       <cmp-field-mapping name="startNo" persistence-name="START_NO" persistence-type="NUMBER(38)"/>
       <cmp-field-mapping name="endNo" persistence-name="END_NO" persistence-type="NUMBER(38)"/>
       <cmp-field-mapping name="noFormat" persistence-name="NO_FORMAT" persistence-type="VARCHAR2(40)"/>
       <cmp-field-mapping name="episodeId" persistence-name="EPISODE_ID" persistence-type="VARCHAR2(20)"/>
       <cmp-field-mapping name="resetDateFormat" persistence-name="RESET_DATE_FORMAT" persistence-type="VARCHAR2(20)"/>
       <cmp-field-mapping name="resetAtDateValue" persistence-name="RESET_AT_DATE_VALUE" persistence-type="VARCHAR2(20)"/>
       <cmp-field-mapping name="dbFunctionName" persistence-name="DB_FUNCTION_NAME" persistence-type="VARCHAR2(400)"/>
       <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>
      


      Thanks in advance.


        • 1. 3821502
          alexcheong

          Hi,

          I'm tryting to get several EJB methods exposed as Web Services. The problem I'm facing is that the methods are taking multiple complex types as arguments and returns again a complex type.

          I'm using JBoss 3.2.3 & JBossIDE 1.2.3 (with the XDoclet plugin for JBoss.NET - which should really be part of JBossIDE - also no build support for JBoss.NET).

          The BeanSerializer/Deserializer aren't suitable for the task, since there are some special mappings required in those Complex Type(s).

          Here's a list of questions:

          - Which XDoclet tags need to be used to get the deploy file right?
          - Can the mappings be defined in the Java complex type files? If so which tags?
          - Merge files - how are they named?

          I've been searching the Web for days and could not find anything. I've tried with AXIS itself (and the axisdeploy ant task), the JBoss.NET integration is far superior for development/deployment (non interactive).

          Also if somebody could point me to a working custom Serializer/Deserializer implementation somewhere I would appreciate that very much.

          Overall the JBoss.NET project is fantastic, it just needs some more documentation on how to use it.

          Thanks,
          Reiner

          • 2. Re: jboss-3.2.7RC1 - Unable to execute remote method.
            alexcheong

            Should lookup for "CMSEQUENCE"."SEQUENCEID" instead of "T0_CMSEQUENCE"."SEQUENCEID".

            • 3. Re: jboss-3.2.7RC1 - Unable to execute remote method.
              darranl

              Jboss has no interest in the contents of 'orion-ejb-jar.xml' application server specific settings can be made in 'jboss.xml' or 'jbosscmp-jdbc.xml' deployment descriptors.

              • 4. Re: jboss-3.2.7RC1 - Unable to execute remote method.
                alexcheong

                Thanks for the reply.
                I don't have such files in the project's package.

                Would it be the root of the problem?

                • 5. Re: jboss-3.2.7RC1 - Unable to execute remote method.
                  alexcheong

                  I have added following file to Conf folder.
                  Still encounter same issue.

                  jbosscmp-jdbc.xml

                  <?xml version="1.0" encoding="UTF-8"?>
                  <!DOCTYPE jbosscmp-jdbc PUBLIC
                  "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN"
                  "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd">
                  
                  <jbosscmp-jdbc>
                  
                  <defaults>
                  <datasource>java:/jdbc/FisicienCoreDS</datasource>
                  <datasource-mapping>Oracle9i</datasource-mapping>
                  <create-table>false</create-table>
                  <remove-table>false</remove-table>
                  </defaults>
                  
                  </jbosscmp-jdbc>
                  


                  Thanks.

                  • 6. Re: jboss-3.2.7RC1 - Unable to execute remote method.
                    darranl

                    I think the only solution really is going to be for you to go through the getting started guide to see some example deployments working.

                    The two JBoss deployment descriptors need to be added to your META-INF folder in the jar next to the ejb-jar.xml. There are dtd's in the docs folder that describe the contents of these files.

                    You can then use these files for mapping the table and column names.

                    • 7. Re: jboss-3.2.7RC1 - Unable to execute remote method.
                      alexcheong

                      Which are the two files?

                      Is it jbosscmp-jdbc.xml & jboss.xml?