Thread: Long atributes

Hello,
   I have to store strings larger than 8Kb in a table. Using postgreSQL
7.0, buit with a 32K page size, the latest JDBC driver and JDK1.2   I still get a SQLException "SQL statement is to
long"when I try to do
 
a insert with a big string, although the homepage says that there is no
query size limit anymore (but the tuples still have to fin in one disk
page).

                                              Thanks

Nelson Ferreira Junior <nfj@cin.ufpe.br> writes:
>     I have to store strings larger than 8Kb in a table. Using postgreSQL
> 7.0, buit with a 32K page size, the latest JDBC driver and JDK1.2
>     I still get a SQLException "SQL statement is to long" when I try to do
> a insert with a big string,

I believe the JDBC driver still has a query length limit in it :-(

(Hey Peter, is anything likely to be done about that soon?)
        regards, tom lane

Ah, there's a hardwired 8K limit in Connection (must have dated from the
distant past).

Quick fix: in src/interfaces/jdbc/org/postgresql/Connection.java, delete
lines 323 & 324

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

> -----Original Message-----
> From:    Nelson Ferreira Junior [SMTP:nfj@cin.ufpe.br]
> Sent:    Wednesday, May 31, 2000 8:20 PM
> To:    pgsql-interfaces@postgresql.org
> Subject:    [INTERFACES] Long atributes
> 
> 
>     Hello,
> 
>     I have to store strings larger than 8Kb in a table. Using postgreSQL
> 7.0, buit with a 32K page size, the latest JDBC driver and JDK1.2
>     I still get a SQLException "SQL statement is to long" when I try to do
> a insert with a big string, although the homepage says that there is no
> query size limit anymore (but the tuples still have to fin in one disk
> page).
> 
> 
>                                                Thanks