| 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: | Whole Thread | Raw Message | 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
| 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? |