Re: SQL-Statement is too long - Mailing list pgsql-jdbc

From Jason Davies
Subject Re: SQL-Statement is too long
Date
Msg-id 20011030132413.A25075@netspade.com
Whole thread Raw
In response to SQL-Statement is too long  (Erwin Ambrosch <erwin@ebutec.com>)
List pgsql-jdbc
Erwin,

This is probably because you have PostgreSQL compiled with the default blocksize, which is 8k. You can recompile with a
largerblocksize, but I think it may be configurable in version 7.1. It's not the JDBC driver's fault anyway :) 

Jason

On Mon, Oct 29, 2001 at 05:52:26PM +0100, Erwin Ambrosch wrote:
> Hi,
>
> I'm using Postgesql 7.0.3-8 and the postgresql-jdbc2.jar to talk to the
> databse from within Java. I tried to write a quite long text into a TEXT
> column, and got the following SQLExcpetion:  The SQL Statement is too
> long - INSERT INTO ...
>
> A file which contains the text has a size of 9244 byte. Are there any
> restriction for the length of a TEXT column.
>
> Thank you for any response.
>
> Erwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Jason Davies

jason@netspade.com

Attachment

pgsql-jdbc by date:

Previous
From: Guy McArthur
Date:
Subject: Re: "No Suitable Driver"
Next
From: Erwin Ambrosch
Date:
Subject: German Special Characters