Обсуждение: SQL Statement too long

Поиск
Список
Период
Сортировка

SQL Statement too long

От
"Jayson Callaway"
Дата:
I am using Postgres 7.1.2 under linux with the JDBC drivers and Iam trying
to do an insert into a text field with about a 9K string of text. Does
anyone know why I would be getting an error back that says "The SQL
Statement is too long?

At first I though it was because I was creating the SQL statement as a
string used through the Statement class, so I tried using a
PreparedStatement, but I am still getting the same problem.

--
Jayson Callaway




Re: SQL Statement too long

От
"Josh Berkus"
Дата:
Jayson,

> I am using Postgres 7.1.2 under linux with the JDBC drivers and Iam
> trying
> to do an insert into a text field with about a 9K string of text.
> Does
> anyone know why I would be getting an error back that says "The SQL
> Statement is too long?

You need to post this question on the pgsql-jdbc list.  It is unlikely
that anyone on this list can help you, as this sounds like a JDBC
problem.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco