Re: JDBC and long TEXT fields

Here are the last two entries from the PostgreSQL 7.0.3 
/src/interfaces/jdbc/CHANGELOG:

Tue Jun 06 12:00:00 BST 2000 petermount@it.maidstone.gov.uk       - Added org/postgresql/DriverClass.java to the list
offiles removed         by make clean (it's dynamically built)       - Fixed Statement, so that the update count is
validwhen an SQL         DELETE operation is done.       - While fixing the update count, made it easier to get the OID
of        the last insert as well. Example is in example/basic.java
 
Tue Jun 06 08:37:00 BST 2000 petermount@it.maidstone.gov.uk       - Removed a hardwired 8K limit on query strings
-Added some missing org.'s in Connection that prevented         the use of the geometric types.
                                 
 

This one above says it removed the 8k limit on query strings.  I can't 
remember all the release dates of 7.0.2 etc, but maybe these changes above 
only made it into 7.0.3, not 7.0.2.

The jar file is now just called postgresql.jar in 7.0.3.

Hope this info is helpful.


On Saturday 02 December 2000 22:33, Bryan \(Mailing Lists\) wrote:
> I am trying to insert rows into a table containing a field of type "TEXT".
> The documentation says there is no limit to the size of this field; yet,
> when I try to insert or update a row with a field contents of around 10k, I
> get an error from the JDBC driver:
>
> The SQL Statement is too long - insert into Customer_History (id,
> id_customer, id_admin, timestamp, description) values (2021, 37515, null,
> '2000-12-02 21:29:48.279', '...very very very long TEXT field')
>
>         at org.postgresql.Connection.ExecSQL(Connection.java:324)
>         at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
>         at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
>         at
> org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java
>: 126)
>
>
> I am using jdbc7.0.2-1.2.jar.
>
> Any help would be appreciated.
>
> Thank you in advance,
> Bryan

-- 
-------- Robert B. Easter  reaster@comptechnews.com ---------
- CompTechNews Message Board   http://www.comptechnews.com/ -
- CompTechServ Tech Services   http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------