Sounds like you have some digging to do then.
Please understand this is most likely a database configuration
problem, not a problem that can be fixed with code or other changes
in OFBiz.
The best thing to do is review the JDBC driver documentation to see
if special parameters are needed, or in general do some debugging to
see exactly what is going on.
Unless someone else has any tips from recent experience for you, I'm
not sure how much help this mailing list can be...
Best of luck,
-David
On Aug 1, 2006, at 9:20 AM, Ruth Hoffman wrote:
Thanks David:
Now I have the same client version as the server version (here's
the log file):
2006-08-01 10:14:06,553 (main) [ DatabaseUtil.java:765:INFO ]
Database Product Name is PostgreSQL
2006-08-01 10:14:06,555 (main) [ DatabaseUtil.java:766:INFO ]
Database Product Version is 8.1.4
2006-08-01 10:14:06,557 (main) [ DatabaseUtil.java:774:INFO ]
Database Driver Name is PostgreSQL Native Driver
2006-08-01 10:14:06,561 (main) [ DatabaseUtil.java:775:INFO ]
Database Driver Version is PostgreSQL 8.1 JDBC3 with SSL (build
407)
And I just verified that: Webtools/Entity Reference; Webtools/XML
export & programmatic EntityListIterator...all cause either an out
of memory error or, a transaction time out error.
TIA
Ruth
David E Jones wrote:
On Aug 1, 2006, at 8:50 AM, Ruth Hoffman wrote:
David:
Please clarify, if you could - are you saying that PostgresSQL
v. 8.1.4 (as a client) is not compatible with PostgresSQL 8.0?
(as installed on my remote db)
I'm saying look at the pgsql web site because there are issues
with using the wrong version of the JDBC driver for a given
version of the database.
In other words, there are two different things: the database, and
the JDBC driver. Each has its own version. If the JDBC driver
version does not work with the version of the database it is
talking to, things will not work.
To your knowledge, has anyone ever successfully used the Entity
Engine with remote (not on the same server) database tables of
over 1.5Milliion records?
Yes, there are many OFBiz installations with single tables even
larger than this and they work fine.
-David
