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
