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 по дате отправления:

Предыдущее
От: "Bryan Bateman"
Дата:
Сообщение: Re: Thanks.....& How do I implement Connection Pooling....;-))
Следующее
От: Greg Speegle
Дата:
Сообщение: Re: JDBC and long TEXT fields