Received: from netmeme.org (firewall.netmeme.org [204.144.237.82])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB33XRF68757
	for <pgsql-interfaces@postgresql.org>;
	Sat, 2 Dec 2000 22:33:27 -0500 (EST)
	(envelope-from bryan_lists@netmeme.org)
Received: from workstation (workstation.netmeme.org [204.144.237.84])
	by netmeme.org (8.9.3/8.9.3) with SMTP id VAA22575
	for <pgsql-interfaces@postgresql.org>; Sat, 2 Dec 2000 21:34:05 -0700
Message-ID: <002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org>
From: "Bryan \(Mailing Lists\)" <bryan_lists@netmeme.org>
To: <pgsql-interfaces@postgresql.org>
References: <200012011652.WAA08483@tcs.com>
	<012d01c05c66$0108d6f0$c6290218@workhorse>
Subject: JDBC and long TEXT fields
Date: Sat, 2 Dec 2000 20:33:29 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200012/9
X-Sequence-Number: 346

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