java.lang.OutOfMemoryError - still, please some advice?

[Ruth Hoffman]

Hello All:
Finally had a chance to try a recent version of OFBiz Webtools against
my 14M+ record database. The only thing I'm doing here is selecting the
Entity Reference tool & then selecting the link to "view data". As you
can see, I'm still getting that nasty out of memory error. Here's some
of the log file:

    2006-07-31 13:38:00,996 (http-0.0.0.0-8443-Processor2) [            
    Region.java:107:INFO ] real path for [/templates/main_template.jsp]
    is:
    /Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
    2006-07-31 13:38:20,017 (http-0.0.0.0-8443-Processor4) [    
    ContextFilter.java:183:INFO ] [Request]: /webtools/control/FindGeneric
    2006-07-31 13:38:20,019 (http-0.0.0.0-8443-Processor4) [    
    ControlServlet.java:90 :INFO ] The character encoding of the request
    is: [null]. The character encoding we will use for the request and
    response is: [UTF-8]
    2006-07-31 13:38:20,021 (http-0.0.0.0-8443-Processor4) [    
    ControlServlet.java:126:DEBUG] [[[FindGeneric] Servlet Starting,
    doing setup- total:0.0,since last(Begin):0.0]]
    2006-07-31 13:38:20,023 (http-0.0.0.0-8443-Processor4) [    
    ControlServlet.java:175:DEBUG] [[[FindGeneric] Setup done, doing
    Event(s) and View(s)- total:0.0,since last([FindGeneric] Ser...):0.0]]
    2006-07-31 13:38:20,052 (http-0.0.0.0-8443-Processor4) [          
    UtilXml.java:255:DEBUG] XML Read 0.026s:
    jndi:/0.0.0.0/webtools/WEB-INF/controller.xml
    2006-07-31 13:38:20,056 (http-0.0.0.0-8443-Processor4) [  
    ConfigXMLReader.java:544:INFO ] ConfigMap Created: (4) records in
    0.0010s
    2006-07-31 13:38:20,058 (http-0.0.0.0-8443-Processor4) [  
    ConfigXMLReader.java:614:INFO ] HandlerMap Created: (2) records in 0.0s
    2006-07-31 13:38:20,064 (http-0.0.0.0-8443-Processor4) [  
    ConfigXMLReader.java:294:INFO ] RequestMap Created: (78) records in
    0.0040s
    2006-07-31 13:38:20,067 (http-0.0.0.0-8443-Processor4) [  
    ConfigXMLReader.java:403:INFO ] ViewMap Created: (51) records in 0.0010s
    2006-07-31 13:38:20,069 (http-0.0.0.0-8443-Processor4) [    
    RequestHandler.java:203:INFO ] [Processing Request]: FindGeneric
    2006-07-31 13:38:20,111 (http-0.0.0.0-8443-Processor4) [    
    RequestManager.java:114:INFO ] [RequestManager.getRequestAttribute]
    Value for attribute "null" of uri "FindGeneric" not found
    2006-07-31 13:38:20,113 (http-0.0.0.0-8443-Processor4) [    
    RequestHandler.java:386:INFO ] [RequestHandler.doRequest]: Response
    is a view.
    2006-07-31 13:38:20,115 (http-0.0.0.0-8443-Processor4) [    
    RequestHandler.java:538:INFO ] servletName=control, view=FindGeneric
    2006-07-31 13:38:20,117 (http-0.0.0.0-8443-Processor4) [            
    Region.java:107:INFO ] real path for [/templates/main_template.jsp]
    is:
    /Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
    2006-07-31 13:38:22,206 (http-0.0.0.0-8443-Processor4)
    [XAConnectionFactory.java:119:WARN ] no xares in rms for con
    org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl@d5bd50
    2006-07-31 13:39:08,143 (http-0.0.0.0-8443-Processor4)
    [ApplicationDispatcher.java:704:ERROR] Servlet.service() for servlet
    jsp threw exception
    java.lang.OutOfMemoryError
    2006-07-31 13:39:08,261 (http-0.0.0.0-8443-Processor4) [    
    JspViewHandler.java:88 :ERROR]
    ---- exception report
    ----------------------------------------------------------
    ServletException rendering JSP view
    Exception: javax.servlet.ServletException
    Message: null
    ---- stack trace
    ---------------------------------------------------------------
    javax.servlet.ServletException
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
    org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:838)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
    org.apache.catalina.core.ApplicationFilterCha..

To recap:
OFBiz version: 427128 (checked out today - July 31, 2006)
Postgres info from OFBiz log file:
2006-07-31 13:36:04,584 (main) [       DatabaseUtil.java:765:INFO ]
Database Product Name is PostgreSQL
2006-07-31 13:36:04,586 (main) [       DatabaseUtil.java:766:INFO ]
Database Product Version is 7.4.7
2006-07-31 13:36:04,588 (main) [       DatabaseUtil.java:774:INFO ]
Database Driver Name is PostgreSQL Native Driver
2006-07-31 13:36:04,590 (main) [       DatabaseUtil.java:775:INFO ]
Database Driver Version is PostgreSQL 8.0 JDBC3 with SSL (build 311)
2006-07-31 13:36:04,591 (main) [       DatabaseUtil.java:776:INFO ]
Database Driver JDBC Version is 3.0

Also, I'm having the same problem when I try to programmatically access
this database and attempt to set the TYPE_SCROLL_INSENSITIVE. The Entity
Engine never returns from a call - just runs out of memory.

Ruth

[David E Jones-2]

This doesn't look like anything in OFBiz, there is just an error in  
your database setup.

I'm guessing the problem is that the PG8 drivers don't really work  
with PG7 databases... You MUST have a driver that matches your database.

In this case if you're using PG 7.4.7 you'll have to move down to a 7  
series JDBC driver. Of course, that will cause another problem  
because the 7 series drivers did NOT support paging through result  
sets using a database cursor, so you'll still get the out of memory  
error.

So, the only solution is to upgrade your database to an 8 series,  
preferably the latest stable 8.1 release. And of course update the  
JDBC driver while you're at it... ;)

-David


On Jul 31, 2006, at 12:54 PM, Ruth Hoffman wrote:

> Hello All:
> Finally had a chance to try a recent version of OFBiz Webtools  
> against my 14M+ record database. The only thing I'm doing here is  
> selecting the Entity Reference tool & then selecting the link to  
> "view data". As you can see, I'm still getting that nasty out of  
> memory error. Here's some of the log file:
>
>    2006-07-31 13:38:00,996 (http-0.0.0.0-8443-Processor2)  
> [               Region.java:107:INFO ] real path for [/templates/
> main_template.jsp]
>    is:
>    /Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/
> webtools/templates/main_template.jsp
>    2006-07-31 13:38:20,017 (http-0.0.0.0-8443-Processor4)  
> [        ContextFilter.java:183:INFO ] [Request]: /webtools/control/
> FindGeneric
>    2006-07-31 13:38:20,019 (http-0.0.0.0-8443-Processor4)  
> [       ControlServlet.java:90 :INFO ] The character encoding of  
> the request
>    is: [null]. The character encoding we will use for the request and
>    response is: [UTF-8]
>    2006-07-31 13:38:20,021 (http-0.0.0.0-8443-Processor4)  
> [       ControlServlet.java:126:DEBUG] [[[FindGeneric] Servlet  
> Starting,
>    doing setup- total:0.0,since last(Begin):0.0]]
>    2006-07-31 13:38:20,023 (http-0.0.0.0-8443-Processor4)  
> [       ControlServlet.java:175:DEBUG] [[[FindGeneric] Setup done,  
> doing
>    Event(s) and View(s)- total:0.0,since last([FindGeneric] Ser...):
> 0.0]]
>    2006-07-31 13:38:20,052 (http-0.0.0.0-8443-Processor4)  
> [              UtilXml.java:255:DEBUG] XML Read 0.026s:
>    jndi:/0.0.0.0/webtools/WEB-INF/controller.xml
>    2006-07-31 13:38:20,056 (http-0.0.0.0-8443-Processor4)  
> [      ConfigXMLReader.java:544:INFO ] ConfigMap Created: (4)  
> records in
>    0.0010s
>    2006-07-31 13:38:20,058 (http-0.0.0.0-8443-Processor4)  
> [      ConfigXMLReader.java:614:INFO ] HandlerMap Created: (2)  
> records in 0.0s
>    2006-07-31 13:38:20,064 (http-0.0.0.0-8443-Processor4)  
> [      ConfigXMLReader.java:294:INFO ] RequestMap Created: (78)  
> records in
>    0.0040s
>    2006-07-31 13:38:20,067 (http-0.0.0.0-8443-Processor4)  
> [      ConfigXMLReader.java:403:INFO ] ViewMap Created: (51)  
> records in 0.0010s
>    2006-07-31 13:38:20,069 (http-0.0.0.0-8443-Processor4)  
> [       RequestHandler.java:203:INFO ] [Processing Request]:  
> FindGeneric
>    2006-07-31 13:38:20,111 (http-0.0.0.0-8443-Processor4)  
> [       RequestManager.java:114:INFO ]  
> [RequestManager.getRequestAttribute]
>    Value for attribute "null" of uri "FindGeneric" not found
>    2006-07-31 13:38:20,113 (http-0.0.0.0-8443-Processor4)  
> [       RequestHandler.java:386:INFO ] [RequestHandler.doRequest]:  
> Response
>    is a view.
>    2006-07-31 13:38:20,115 (http-0.0.0.0-8443-Processor4)  
> [       RequestHandler.java:538:INFO ] servletName=control,  
> view=FindGeneric
>    2006-07-31 13:38:20,117 (http-0.0.0.0-8443-Processor4)  
> [               Region.java:107:INFO ] real path for [/templates/
> main_template.jsp]
>    is:
>    /Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/
> webtools/templates/main_template.jsp
>    2006-07-31 13:38:22,206 (http-0.0.0.0-8443-Processor4)
>    [XAConnectionFactory.java:119:WARN ] no xares in rms for con
>    org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAConnectionImpl@d5bd50
>    2006-07-31 13:39:08,143 (http-0.0.0.0-8443-Processor4)
>    [ApplicationDispatcher.java:704:ERROR] Servlet.service() for  
> servlet
>    jsp threw exception
>    java.lang.OutOfMemoryError
>    2006-07-31 13:39:08,261 (http-0.0.0.0-8443-Processor4)  
> [       JspViewHandler.java:88 :ERROR]
>    ---- exception report
>    ----------------------------------------------------------
>    ServletException rendering JSP view
>    Exception: javax.servlet.ServletException
>    Message: null
>    ---- stack trace
>    ---------------------------------------------------------------
>    javax.servlet.ServletException
>    org.apache.jasper.runtime.PageContextImpl.doHandlePageException
> (PageContextImpl.java:858)
>    org.apache.jasper.runtime.PageContextImpl.handlePageException
> (PageContextImpl.java:791)
>    org.apache.jsp.entity.FindGeneric_jsp._jspService
> (FindGeneric_jsp.java:838)
>    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>    javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>    org.apache.jasper.servlet.JspServletWrapper.service
> (JspServletWrapper.java:332)
>    org.apache.jasper.servlet.JspServlet.serviceJspFile
> (JspServlet.java:314)
>    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>    javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>    org.apache.catalina.core.ApplicationFilterCha..
>
> To recap:
> OFBiz version: 427128 (checked out today - July 31, 2006)
> Postgres info from OFBiz log file:
> 2006-07-31 13:36:04,584 (main) [       DatabaseUtil.java:765:INFO ]  
> Database Product Name is PostgreSQL
> 2006-07-31 13:36:04,586 (main) [       DatabaseUtil.java:766:INFO ]  
> Database Product Version is 7.4.7
> 2006-07-31 13:36:04,588 (main) [       DatabaseUtil.java:774:INFO ]  
> Database Driver Name is PostgreSQL Native Driver
> 2006-07-31 13:36:04,590 (main) [       DatabaseUtil.java:775:INFO ]  
> Database Driver Version is PostgreSQL 8.0 JDBC3 with SSL (build 311)
> 2006-07-31 13:36:04,591 (main) [       DatabaseUtil.java:776:INFO ]  
> Database Driver JDBC Version is 3.0
>
> Also, I'm having the same problem when I try to programmatically  
> access this database and attempt to set the  
> TYPE_SCROLL_INSENSITIVE. The Entity Engine never returns from a  
> call - just runs out of memory.
>
> Ruth
>
>