posted 20 years ago
Thanks Marcos Maia for your previous help.
Hi all , can you help me for this problem?
Getting following error* when i execute EJBQL:"select object(o) from AddressCMPB as o, IN(o.balancecmpb) as b where b.BALANCE=?1"
There is a one-to-many relationship between two bean AddressCMPB and BalanceCMPB.
Working on WSAD and DB2.
Thanks
Biswajit
*[2/10/04 16:39:32:273 GMT+05:30] 279a0591 DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@71740592
[2/10/04 16:39:32:289 GMT+05:30] 279a0591 DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@71740592
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:127)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at not.to.release.ejb.entity.ConcreteAddressCMPB_8ad746ae.ejbFindForSelectIDWithRelationBalanceCMPB_Local(ConcreteAddressCMPB_8ad746ae.java:511)
at not.to.release.ejb.entity.EJSCMPAddressCMPBHomeBean_8ad746ae.findForSelectIDWithRelationBalanceCMPB_Local(EJSCMPAddressCMPBHomeBean_8ad746ae.java:270)
at not.to.release.ejb.entity.EJSLocalCMPAddressCMPBHome_8ad746ae.findForSelectIDWithRelationBalanceCMPB(EJSLocalCMPAddressCMPBHome_8ad746ae.java:389)
at not.to.release.ejb.entity.ConcreteAddressCMPB_8ad746ae.ejbSelectIDWithRelationBalanceCMPB(ConcreteAddressCMPB_8ad746ae.java:495)
at not.to.release.ejb.entity.AddressCMPBBean.getIDDD(AddressCMPBBean.java:154)
at not.to.release.ejb.entity.EJSLocalCMPAddressCMPB_8ad746ae.getIDDD(EJSLocalCMPAddressCMPB_8ad746ae.java:263)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:323)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
---- Begin backtrace for nested exception
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0206N "Q2.ADDRESSCMPB_ID" is not valid in the context where it is used. SQLSTATE=42703
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:275)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:212)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:463)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:2114)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:1600)
at not.to.release.ejb.entity.websphere_deploy.DB2UDBNT_V72_2.AddressCMPBBeanFunctionSet_8ad746ae.ejbSelectIDWithRelationBalanceCMPB(AddressCMPBBeanFunctionSet_8ad746ae.java:762)
at not.to.release.ejb.entity.websphere_deploy.DB2UDBNT_V72_2.AddressCMPBBeanFunctionSet_8ad746ae.execute(AddressCMPBBeanFunctionSet_8ad746ae.java:515)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:156)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeFinder(WSRelationalRAAdapter.java:262)
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(DataAccessRequestImpl.java:81)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeQuery(ConcreteBeanInstanceExtensionImpl.java:264)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanInstanceExtensionImpl.executeFind(ConcreteBeanInstanceExtensionImpl.java:155)
at not.to.release.ejb.entity.ConcreteAddressCMPB_8ad746ae.ejbFindForSelectIDWithRelationBalanceCMPB_Local(ConcreteAddressCMPB_8ad746ae.java:511)
at not.to.release.ejb.entity.EJSCMPAddressCMPBHomeBean_8ad746ae.findForSelectIDWithRelationBalanceCMPB_Local(EJSCMPAddressCMPBHomeBean_8ad746ae.java:270)
at not.to.release.ejb.entity.EJSLocalCMPAddressCMPBHome_8ad746ae.findForSelectIDWithRelationBalanceCMPB(EJSLocalCMPAddressCMPBHome_8ad746ae.java:389)
at not.to.release.ejb.entity.ConcreteAddressCMPB_8ad746ae.ejbSelectIDWithRelationBalanceCMPB(ConcreteAddressCMPB_8ad746ae.java:495)
at not.to.release.ejb.entity.AddressCMPBBean.getIDDD(AddressCMPBBean.java:154)
at not.to.release.ejb.entity.EJSLocalCMPAddressCMPB_8ad746ae.getIDDD(EJSLocalCMPAddressCMPB_8ad746ae.java:263)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.etools.utc.model.ReflectionMethodModel.invoke(ReflectionMethodModel.java:68)
at com.ibm.etools.utc.servlet.InvokeServlet.invoke(InvokeServlet.java:110)
at com.ibm.etools.utc.servlet.InvokeServlet.doPost(InvokeServlet.java:323)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
[ February 11, 2004: Message edited by: Biswajit Paria ]