I built an EJB following the steps for the Inventory CMP EJB in chapter 5 on page 203 using MySQL as the database product. When I test the EJB, I have NO problems creating records in the table I created using similar create statements to the ones in your example but when I try to use the custom finders again similar create statements to the ones in your example, I get the following error (The DataBase name is CFL the Table name is Event). It looks like the custom finder is trying to use a table called q1 instead on the Event table that was coded in the EJB QL select statment:


javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManage rException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@29f7abb a
com.ibm.ws.ejbpersistence.utilpm.PersistenceManage rException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@29f7abb a
    at com.ibm.ws.ejbpersistence.dataaccess.DataAccessReq uestImpl.execute(DataAccessRequestImpl.java:127)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanInstanceExtensionImpl.executeQuery(ConcreteBean InstanceExtensionImpl.java:264)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanInstanceExtensionImpl.executeFind(ConcreteBeanI nstanceExtensionImpl.java:155)
    at com.jboss.cfl.ejb.ConcreteEvent_cf657097.ejbFindBy Id_Local(ConcreteEvent_cf657097.java:197)
    at com.jboss.cfl.ejb.EJSCMPEventHomeBean_cf657097.fin dById_Local(EJSCMPEventHomeBean_cf657097.java:169)
    at com.jboss.cfl.ejb.EJSLocalCMPEventHome_cf657097.fi ndById(EJSLocalCMPEventHome_cf657097.java:213)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.ibm.etools.utc.model.ReflectionMethodModel.inv oke(ReflectionMethodModel.java:68)
    at com.ibm.etools.utc.servlet.InvokeServlet.invoke(In vokeServlet.java:110)
    at com.ibm.etools.utc.servlet.InvokeServlet.doPost(In vokeServlet.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.StrictServletInsta nce.doService(StrictServletInstance.java:110)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
    at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
    at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
    at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
    at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199)
    at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
    at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182)
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331)
    at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
    at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432)
    at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:343)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:592)
---- Begin backtrace for nested exception
java.sql.SQLException: General error, message from server: "Table 'cfl.q1' doesn't exist"
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1626)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:88 6)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :945)
    at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:917)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 1841)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 1775)
    at com.mysql.jdbc.Statement.executeQuery(Statement.ja va:1220)
    at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(Dat abaseMetaData.java:2496)
    at com.mysql.jdbc.UpdatableResultSet.checkUpdatabilit y(UpdatableResultSet.java:1924)
    at com.mysql.jdbc.UpdatableResultSet.(UpdatableResult Set.java:98)
    at com.mysql.jdbc.MysqlIO.buildResultSetWithRows(Mysq lIO.java:1207)
    at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:2 96)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :985)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 1844)
    at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1458)
    at com.jboss.cfl.ejb.websphere_deploy.MYSQL_V323_1.Ev entBeanFunctionSet_cf657097.FindById(EventBeanFunc tionSet_cf657097.java:484)
    at com.jboss.cfl.ejb.websphere_deploy.MYSQL_V323_1.Ev entBeanFunctionSet_cf657097.execute(EventBeanFunct ionSet_cf657097.java:598)
    at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute (WSInteractionImpl.java:156)
    at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.exe cuteFinder(WSRelationalRAAdapter.java:262)
    at com.ibm.ws.ejbpersistence.dataaccess.DataAccessReq uestImpl.execute(DataAccessRequestImpl.java:81)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanInstanceExtensionImpl.executeQuery(ConcreteBean InstanceExtensionImpl.java:264)
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanInstanceExtensionImpl.executeFind(ConcreteBeanI nstanceExtensionImpl.java:155)
    at com.jboss.cfl.ejb.ConcreteEvent_cf657097.ejbFindBy Id_Local(ConcreteEvent_cf657097.java:197)
    at com.jboss.cfl.ejb.EJSCMPEventHomeBean_cf657097.fin dById_Local(EJSCMPEventHomeBean_cf657097.java:169)
    at com.jboss.cfl.ejb.EJSLocalCMPEventHome_cf657097.fi ndById(EJSLocalCMPEventHome_cf657097.java:213)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.ibm.etools.utc.model.ReflectionMethodModel.inv oke(ReflectionMethodModel.java:68)
    at com.ibm.etools.utc.servlet.InvokeServlet.invoke(In vokeServlet.java:110)
    at com.ibm.etools.utc.servlet.InvokeServlet.doPost(In vokeServlet.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.StrictServletInsta nce.doService(StrictServletInstance.java:110)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
    at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
    at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
    at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
    at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199)
    at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
    at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182)
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331)
    at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
    at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432)
    at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:343)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:592)
javax.ejb.EJBException: nested exception is: com.ibm.ws.ejbpersistence.utilpm.PersistenceManage rException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@29f7abb a
    at com.ibm.ws.ejbpersistence.beanextensions.ConcreteB eanInstanceExtensionImpl.executeFind(ConcreteBeanI nstanceExtensionImpl.java:182)
    at com.jboss.cfl.ejb.ConcreteEvent_cf657097.ejbFindBy Id_Local(ConcreteEvent_cf657097.java:197)
    at com.jboss.cfl.ejb.EJSCMPEventHomeBean_cf657097.fin dById_Local(EJSCMPEventHomeBean_cf657097.java:169)
    at com.jboss.cfl.ejb.EJSLocalCMPEventHome_cf657097.fi ndById(EJSLocalCMPEventHome_cf657097.java:213)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.ibm.etools.utc.model.ReflectionMethodModel.inv oke(ReflectionMethodModel.java:68)
    at com.ibm.etools.utc.servlet.InvokeServlet.invoke(In vokeServlet.java:110)
    at com.ibm.etools.utc.servlet.InvokeServlet.doPost(In vokeServlet.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.StrictServletInsta nce.doService(StrictServletInstance.java:110)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
    at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
    at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
    at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
    at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199)
    at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
    at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182)
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331)
    at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
    at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432)
    at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:343)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:592)

I am also having this same problem, did you find a solution?

Not yet! I have looked at the generated SQL and do not see any problems, BUT I can create an error message that is similar to this from mySQL directly by using the following select statement:

select * from Event q1

mySQL tries to do a showtable command on q1 with the above select statement which results in a similar error message about the cfl.q1 table not existing after it actually returns the records from the query.

If I type in:

select q1.* from Event q1

mySQL does not try to do a showtable command on q1 and returns the results with no problems

NOTE: This does not produce an error if I use DB2 as the database instead of mySQL.

Does anyone have a solution for this problem?

I have exactly the same problem on Cloudscape and WebSphere Studio. Any solutions so far ?

It seems to be related to the schema -- db mapping ?

I am also having this same problem with DB2, did any one found the solution?

I encountered the same problem using WSAD 5.1 connecting to an Oracle 9i database.

The problem was caused by an old EJB-Database map in WSAD, even though I told WSAD to use the proper backend in the EJB deployment descriptor. Deleting the old map solved the error, so I suggest all of you wanting to get to the bottom of this, to start digging in the backend mapping xmi's...

I am facing the same problem with Oracle 9i. Could you please tell me how to delete the old EJB-database map and create a new one?

Thanks in advance.

Hi everybody, in my case, the problem is a trigger, when i drop the trigger for the target table, i execute my create method in EJB, without restart server, and every works fine.

regards..

Richard Marques