Hello, I use jboss 4.0.0rc1 and mysql 4.0.12 max and I get the following error when tying to do a simple findbyprimarykey.
| 20:29:16,312 INFO [STDOUT] ------containsResults------->true | 20:29:18,140 INFO [STDOUT] javax.ejb.ObjectNotFoundException: No such entity! | 20:29:18,140 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.execute(JDBCFindByPrimaryKeyQuery.java:133) | 20:29:18,156 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:43) | 20:29:18,171 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:582) | 20:29:18,187 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:310) | 20:29:18,203 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:300) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findSingleObject(EntityContainer.java:1084) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:674) | 20:29:18,203 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | 20:29:18,203 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | 20:29:18,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | 20:29:18,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324) | 20:29:18,203 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1111) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:194) | 20:29:18,203 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:113) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:41) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:109) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:129) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:106) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:516) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:893) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:312) | 20:29:18,203 INFO [STDOUT] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:118) | 20:29:18,203 INFO [STDOUT] at $Proxy98.findByPrimaryKey(Unknown Source) | 20:29:18,203 INFO [STDOUT] at com.softwareag.test_guide.sessionFacadeEJB.PGSessionFacadeBean.getEstablishmentFromId(PGSessionFacadeBean.java:37) | 20:29:18,218 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | 20:29:18,218 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) | 20:29:18,218 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | 20:29:18,218 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324) | 20:29:18,218 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214) | 20:29:18,218 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113) | 20:29:18,218 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:625) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:871) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:394) | 20:29:18,218 INFO [STDOUT] at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:82) | 20:29:18,218 INFO [STDOUT] at $Proxy90.getEstablishmentFromId(Unknown Source) | 20:29:18,218 INFO [STDOUT] at com.softwareag.test_guide.web.temp.PGBusinessDelegate.getEstablishmentFromId(PGBusinessDelegate.java:23) | 20:29:18,218 INFO [STDOUT] at com.softwareag.test_guide.web.tags.PGSetEstablishmentTag.doStartTag(PGSetEstablishmentTag.java:27) | 20:29:18,218 INFO [STDOUT] at org.apache.jsp.displayItem_jsp._jspService(displayItem_jsp.java:91) | 20:29:18,218 INFO [STDOUT] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) | 20:29:18,218 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | 20:29:18,218 INFO [STDOUT] at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) | 20:29:18,218 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) | 20:29:18,218 INFO [STDOUT] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) | 20:29:18,218 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) | 20:29:18,218 INFO [STDOUT] at com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322) | 20:29:18,218 INFO [STDOUT] at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:147) | 20:29:18,218 INFO [STDOUT] at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) | 20:29:18,218 INFO [STDOUT] at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200) | 20:29:18,218 INFO [STDOUT] at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117) | 20:29:18,218 INFO [STDOUT] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | 20:29:18,218 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:146) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | 20:29:18,218 INFO [STDOUT] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:122) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | 20:29:18,218 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) | 20:29:18,218 INFO [STDOUT] at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) | 20:29:18,218 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) | 20:29:18,218 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) | 20:29:18,218 INFO [STDOUT] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) | 20:29:18,218 INFO [STDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) | 20:29:18,218 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534) | I turned on the logging for cmp and the generated sql seems fine: | 2004-08-16 20:29:18,125 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.EstablishmentEJB#findByPrimaryKey] Executing SQL: SELECT t0_EstablishmentEJB.id FROM ESTABLISHMENTEJB t0_EstablishmentEJB WHERE t0_EstablishmentEJB.id=? | 2004-08-16 20:29:18,125 TRACE [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.EstablishmentEJB#findByPrimaryKey] Set parameter: index=1, jdbcType=INTEGER, value=164 | Apparently I am not the only one with this problem. Is this a bug? All my sources are available here: http://www.parispano.org/ejb_tier/ Any hint or help appreciated, Julien. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845237#3845237 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845237 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
