Hi, I have the following error, when executing a findAll in a ejb CMP: the problem begin when I put the PK whit two fields (compose PK), if the PK only has one all is ok
org.jboss.tm.JBossTransactionRolledbackException: Load failed; CausedByException is: ORA-04031: unable to allocate 232 bytes of shared memory ("shared pool","SELECT COD_MUNICIPIO, COD_RH...","sql area","logdef : apaclg") ; CausedByException is: Load failed; CausedByException is: ORA-04031: unable to allocate 232 bytes of shared memory ("shared pool","SELECT COD_MUNICIPIO, COD_RH...","sql area","logdef : apaclg") ; nested exception is: javax.ejb.EJBException: Load failed; CausedByException is: ORA-04031: unable to allocate 232 bytes of shared memory ("shared pool","SELECT COD_MUNICIPIO, COD_RH...","sql area","logdef : apaclg") ; - nested throwable: (javax.ejb.EJBException: Load failed; CausedByException is: ORA-04031: unable to allocate 232 bytes of shared memory ("shared pool","SELECT COD_MUNICIPIO, COD_RH...","sql area","logdef : apaclg") ) org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:267) org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:196) org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624) org.jboss.ejb.Container.invoke(Container.java:870) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:324) org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:144) org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) org.jboss.mx.server.Invocation.invoke(Invocation.java:72) org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249) org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:115) org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:101) org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97) org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:91) $Proxy756.findAll(Unknown Source) co.gov.colciencias.cvlac.referencia.en_municipio.ejb.EnMunicipioSessionFacadeRemote.findAll(EnMunicipioSessionFacadeRemote.java:55) org.apache.jsp.jsp.popup.test_005fmunicipio_jsp._jspService(test_005fmunicipio_jsp.java:73) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:39) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) the table has only 1000 rows, the log for the finder is SELECT COD_MUNICIPIO, COD_RH_MUNICIPIO, TXT_NME_MUNICIPIO, TXT_NME_MUNICIPIO_FILTRO, COD_MUNI_INTERNACIONAL, COD_MUNI_DANE, SGL_DEPARTAMENTO, SGL_PAIS FROM EN_MUNICIPIO WHERE (COD_MUNICIPIO=? AND COD_RH_MUNICIPIO=?) OR (COD_MUNICIPIO=? AND COD_RH_MUNICIPIO=?) ... etc View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3888656#3888656 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3888656 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user