JDBC and long TEXT fields
От | Bryan \(Mailing Lists\) |
---|---|
Тема | JDBC and long TEXT fields |
Дата | |
Msg-id | 002901c05cd9$cd8cf6c0$54ed90cc@netmeme.org обсуждение исходный текст |
Ответ на | Thanks.....& How do I implement Connection Pooling....;-)) (Sanjay Arora <sk@pobox.com>) |
Ответы |
Re: JDBC and long TEXT fields
|
Список | 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
В списке pgsql-interfaces по дате отправления: