SQL-Statement is too long

From: Erwin Ambrosch <erwin(at)ebutec(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: SQL-Statement is too long
Date: 2001-10-29 16:52:26
Message-ID: 3BDD894A.4090207@ebutec.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jayesh K. Parayali 2001-10-29 17:24:55 Re: Error: ClassNotFoundException
Previous Message Nick Fankhauser 2001-10-29 16:33:19 Re: hello