Hi David:
Ok, I now know why I was getting the Postgres 7.4 log messages - when I
copied over my entity configuration over from my previous version, I
also copied an entity def for a local Postgres DB I'm using. I have
taken that out, removed all traces of the local Postgres database, but
it doesn't seem to make any difference. I'm still getting these error
messages when I try and use Webtools/Entity Reference:
2006-07-31 19:03:07,989 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:126:DEBUG] [[[FindGeneric] Servlet Starting,
doing setup- total:0.0,since last(Begin):0.0]]
2006-07-31 19:03:07,991 (http-0.0.0.0-8443-Processor2) [
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 19:03:08,017 (http-0.0.0.0-8443-Processor2) [
UtilXml.java:255:DEBUG] XML Read 0.023s:
jndi:/0.0.0.0/webtools/WEB-INF/controller.xml
2006-07-31 19:03:08,043 (http-0.0.0.0-8443-Processor2) [
ConfigXMLReader.java:544:INFO ] ConfigMap Created: (4) records in 0.022s
2006-07-31 19:03:08,047 (http-0.0.0.0-8443-Processor2) [
ConfigXMLReader.java:614:INFO ] HandlerMap Created: (2) records in 0.0s
2006-07-31 19:03:08,054 (http-0.0.0.0-8443-Processor2) [
ConfigXMLReader.java:294:INFO ] RequestMap Created: (78) records in
0.0040s
2006-07-31 19:03:08,057 (http-0.0.0.0-8443-Processor2) [
ConfigXMLReader.java:403:INFO ] ViewMap Created: (51) records in 0.0010s
2006-07-31 19:03:08,104 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:203:INFO ] [Processing Request]: FindGeneric
2006-07-31 19:03:08,150 (http-0.0.0.0-8443-Processor2) [
RequestManager.java:114:INFO ] [RequestManager.getRequestAttribute]
Value for attribute "null" of uri "FindGeneric" not found
2006-07-31 19:03:08,192 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:386:INFO ] [RequestHandler.doRequest]: Response
is a view.
2006-07-31 19:03:08,194 (http-0.0.0.0-8443-Processor2) [
RequestHandler.java:538:INFO ] servletName=control, view=FindGeneric
2006-07-31 19:03:08,229 (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 19:04:43,140 (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)
++++++++ stuff deleted ++++++
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:552)
javax.transaction.RollbackException: Transaction timout
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:236)
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:143)
+++++++ stuff deleted +++++++
2006-07-31 19:04:47,726 (http-0.0.0.0-8443-Processor2) [
ControlServlet.java:186:ERROR]
---- exception report
----------------------------------------------------------
Error in request handler:
Exception: javax.servlet.ServletException
Message: javax.servlet.jsp.JspException: Roll back error, could not
commit transaction, was rolled back instead (Transaction timout)
---- stack trace
---------------------------------------------------------------
javax.servlet.ServletException: javax.servlet.jsp.JspException: Roll
back error, could not commit transaction, was rolled back instead
(Transaction timout)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:854)
+++++ Stuff deleted ++++++
Here's the log file snippets from the startup:
2006-07-31 19:01:26,241 (main) [ GenericDelegator.java:193:INFO ]
Doing database check as requested in entityengine.xml with addMissing=false
2006-07-31 19:01:27,456 (main) [ DatabaseUtil.java:765:INFO ]
Database Product Name is PostgreSQL
2006-07-31 19:01:27,458 (main) [ DatabaseUtil.java:766:INFO ]
Database Product Version is 8.1.4
2006-07-31 19:01:27,460 (main) [ DatabaseUtil.java:774:INFO ]
Database Driver Name is PostgreSQL Native Driver
2006-07-31 19:01:27,464 (main) [ DatabaseUtil.java:775:INFO ]
Database Driver Version is PostgreSQL 8.0 JDBC3 with SSL (build 311)
2006-07-31 19:01:27,478 (main) [ DatabaseUtil.java:776:INFO ]
Database Driver JDBC Version is 3.0
2006-07-31 19:01:27,480 (main) [ DatabaseUtil.java:786:INFO ]
Database Setting/Support Information (those with a * should be true):
2006-07-31 19:01:27,482 (main) [ DatabaseUtil.java:787:INFO ] -
supports transactions [true]*
2006-07-31 19:01:27,496 (main) [ DatabaseUtil.java:788:INFO
Ruth Hoffman wrote:
David:
I'm really confused and not sure where I've gone wrong. Here's how
things stand now:
* I have an external (on another server) Postgres 8.x database that
I can see and talk to using local clients (psql & pgAdmin).
* I have one version of OFBiz based on 7759 in which I get the out
of memory error when I use webtools/entity reference & xml export
against this same database. This version, BTW, was the same
version I referenced in my orginal postings asking about Geronimo
timeouts (early this month). If I look at the log files for this
version I see:
Doing database check as requested in entityengine.xml with
addMissing=false
119867 (main) [ DatabaseUtil.java:765:INFO ] Database Product
Name is PostgreSQL
119870 (main) [ DatabaseUtil.java:766:INFO ] Database Product
Version is 8.1.4
119873 (main) [ DatabaseUtil.java:774:INFO ] Database Driver
Name is PostgreSQL Native Driver
119887 (main) [ DatabaseUtil.java:775:INFO ] Database Driver
Version is PostgreSQL 8.0 JDBC3 with SSL (build 311)
119890 (main) [ DatabaseUtil.java:776:INFO ] Database Driver
JDBC Version is 3.0
Note - no mention of Postgres 7.4.x
* I checked out version 427128 today, built it, added the same
Postgres driver to this classpath (as used above). Copied over my
entityengine.xml config file and the fieldtype...xml file as well
as my entitydefs directory to the ecommerce component (I'm just
using this directory to test) and updated the
ofbiz-component.xm..and I get this in my log file when I start up:
2006-07-31 18:28:06,122 (main) [ DatabaseUtil.java:765:INFO ]
Database Product Name is PostgreSQL
2006-07-31 18:28:06,124 (main) [ DatabaseUtil.java:766:INFO ]
Database Product Version is 7.4.7
2006-07-31 18:28:06,126 (main) [ DatabaseUtil.java:774:INFO ]
Database Driver Name is PostgreSQL Native Driver
2006-07-31 18:28:06,127 (main) [ DatabaseUtil.java:775:INFO ]
Database Driver Version is PostgreSQL 8.0 JDBC3 with SSL (build 311)
2006-07-31 18:28:06,129 (main) [ DatabaseUtil.java:776:INFO ]
Database Driver JDBC Version is 3.0
2006-07-31 18:28:06,131 (main) [ DatabaseUtil.java:786:INFO ]
Database Setting/Support Information (those with a * should be true):
2006-07-31 18:28:06,132 (main) [ DatabaseUtil.java:787:INFO ]
- supports transactions [true]*
So, where have I gone wrong? I don't really even understand where
lines 765-774 are coming from.
Thanks for your patience in helping me work through this.
Ruth
David E Jones wrote:
The startup snippet you included has the following for the DB info:
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
That's definitely a 7 series version of Postgres...
On a side note, if updating Postgres is not an option, you could try
the old 7 series JDBC driver that we used to have in SVN which Andy
had hacked to support cursors... You'll have to dig around to find a
good revision to pull it from, but it would be on the old server
before the JDBC driver removal era.
-David
On Jul 31, 2006, at 4:11 PM, Ruth Hoffman wrote:
Hi David:
Excuse my ignorance, I'm a bit confused:
The target database is an 8.x database and the local jar file I'm
using is:
postgresql-8.0-311.jdbc3.jar
Where else would any Postgres stuff get configured in OFBiz?
Thanks
Ruth
David E Jones wrote:
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
[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
