From: Bryan \(Mailing Lists\) <bryan_lists@netmeme.org>
To: pgsql-interfaces@postgresql.org
Subject: JDBC and long TEXT fields
Date: Sat, 2 Dec 2000 20:33:29 -0700
Message-ID: <002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org> (raw)
References: <200012011652.WAA08483@tcs.com>
<012d01c05c66$0108d6f0$c6290218@workhorse>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bryan_lists@netmeme.org
Subject: Re: JDBC and long TEXT fields
In-Reply-To: <002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox