To be more precise, the table that I am trying to view has: 1,571,094
records.
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
[EMAIL PROTECTED]
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
