RE: Long atributes

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Nelson Ferreira Junior'" <nfj(at)cin(dot)ufpe(dot)br>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: Long atributes
Date: 2000-06-06 07:20:46
Message-ID: 1B3D5E532D18D311861A00600865478CF1AEA3@EXCHANGE1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)cin(dot)ufpe(dot)br]
> Sent: Wednesday, May 31, 2000 8:20 PM
> To: pgsql-interfaces(at)postgresql(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-06-06 07:45:54 RE: Re: Simple bug in JDBC interface
Previous Message Stephen Crawley 2000-06-06 00:35:48 Is it possible to "truncate" a LOB?