0 Replies Latest reply on Aug 3, 2005 4:03 PM by Ricardo

    Error in findAll

    Ricardo Newbie

      Hi, I have the following error, when executing a findAll in a ejb CMP:

      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