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

ERROR [Fdperson#findByPrimaryKey] Find failed

alexcheong Dec 20, 2004 10:21 AM

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

milowe Dec 20, 2004 10:28 AM (in response to alexcheong)

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.
Actions
2. Re: ERROR [Fdperson#findByPrimaryKey] Find failed

alexcheong Dec 20, 2004 11:37 AM (in response to alexcheong)

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?
Actions
3. Re: ERROR [Fdperson#findByPrimaryKey] Find failed

milowe Dec 21, 2004 4:49 AM (in response to alexcheong)

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

4. Re: ERROR [Fdperson#findByPrimaryKey] Find failed

alexcheong Dec 21, 2004 9:59 AM (in response to alexcheong)

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();
 }
 }


}

Go to original post