| From: | "Bryan \(Mailing Lists\)" <bryan_lists(at)netmeme(dot)org> |
|---|---|
| To: | <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | JDBC and long TEXT fields |
| Date: | 2000-12-03 03:33:29 |
| Message-ID: | 002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Speegle | 2000-12-03 03:50:17 | Re: JDBC and long TEXT fields |
| Previous Message | Bryan Bateman | 2000-12-02 13:44:33 | Re: Thanks.....& How do I implement Connection Pooling....;-)) |