Hi BJ:
Perhaps there is a misunderstanding and I am mistaken, but it doesn't
work, in this release, for the XML Export tools either :
late.jsp] is:
/Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
2006-07-31 16:15:03,472 (http-0.0.0.0-8443-Processor3)
[ApplicationDispatcher.java:704:ERROR] Servlet.service() for servlet
jsp threw exception
java.lang.OutOfMemoryError
2006-07-31 16:15:03,543 (http-0.0.0.0-8443-Processor3) [
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.xmldsdump_jsp._jspService(xmldsdump_jsp.java:598)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
Thanks
Ruth
BJ Freeman wrote:
I think the confusion is the cursors was for Import and Export, in web
tools based on the email dated back in may.
Ruth Hoffman sent the following on 7/31/2006 12:59 PM:
Hi BJ:
Thanks for the quick reply.
In a recent email where I reported the same problem in an older
version of OFBiz, David and several others suggested that this had
been fixed or rather Webtools had been changed to use cursors. I'm
here to report that it does not appear to have any effect. I still
get an OutOfMemoryError.
When I set xms (for example: MEMIF="-Xms512M -Xmx512M") I get the
following error (which was the subject of my orginal post - some time
ago - about Geronimo time outs):
006-07-31 14:50:35,443 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:538:INFO ] servletName=control, view=FindGeneric
2006-07-31 14:50:35,452 (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 14:52:21,717 (http-0.0.0.0-8443-Processor2)
[InheritableTransactionContext.java:311:ERROR] Unable to roll back
transaction
java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION
at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:308)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
at
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
at
org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(GeronimoTransactionManager.java:81)
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:181)
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
at
org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:188)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
++++++ lots of stuff left out +++++++++
java.lang.Exception: Stack trace
at java.lang.Thread.dumpStack(Thread.java:1082)
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:194)
at
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
at
org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:188)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
+++++ more stuff left out ++++++
java.lang.Thread.run(Thread.java:552)
javax.transaction.RollbackException: Transaction timout
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:236)
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:143)
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:196)
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(GeronimoTransactionManager.java:81)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:181)
org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:188)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
+++++ and on it goes ++++++
BJ Freeman wrote:
I am guessing, and david will correct me, that the view has not be
set to use the cursors.
I am not sure if the widgets next and previous are setup to switch
to cursors if the data exceeds a certian amount.
would be a nice feature though.
Th only other options is to increase the Xms to more till you don't
get the out of memory.
if on windows, this will slow down the response, if the max you put
in exceeds real memory.
Ruth Hoffman sent the following on 7/31/2006 12:04 PM:
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
