7.1 RPM has old JDBC driver - SQL statement too long - Mailing list pgsql-general

From Adam Rossi
Subject 7.1 RPM has old JDBC driver - SQL statement too long
Date
Msg-id 01041900065100.00960@SOLO.PSGROUP
Whole thread Raw
Responses Re: 7.1 RPM has old JDBC driver - SQL statement too long
Re: 7.1 RPM has old JDBC driver - SQL statement too long
List pgsql-general
I just wanted to pass this along to everyone checking out the new 7.1
release. The jdbc jars that are included with the current RPM's are from the
7.0.3 release. So if you try to take advantage of the new unlimited size text
fields, you will get the familiar "SQL statement too long" error when you try
to do an insert of text greater then 8k.

To get the new 7.1 jdbc driver, the only place I have been able to find it is
in the source tarball. You have to make the jar using the instructions in the
jdbc readme. Once you get a proper make, the new jar will allow large text
inserts and selects. Finally, no more limitations!

I hope this helps someone.

- Adam
--
Adam Rossi
President, PlatinumSolutions, Inc.
adam.rossi@platinumsolutions.com
http://www.platinumsolutions.com
P.O. Box 31  Oakton, VA 22124
PH: 703.471.9793  FAX: 703.471.7140

pgsql-general by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: MS Access 97 ODBC opens 2 connections to the backend?
Next
From: "Richard Huxton"
Date:
Subject: Re: loop on trigger