Re: Max size for bytea type

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Do, Leon (Leon)" <leondo(at)alcatel-lucent(dot)com>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Max size for bytea type
Date: 2007-01-21 05:10:09
Message-ID: Pine.BSO.4.64.0701210005320.8274@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Fri, 19 Jan 2007, Do, Leon (Leon) wrote:

> Hello,
>

When starting a new thread, please don't reply to some other random
message on the list.

> Can someone explain why I cann't get bytea data of more than 1998 bytes?
> Below 1998 size is ok but I got exception if the size is at and above
> 1998. I used jdbc-8.1-407.jdbc3.jar.
>

Could you provide a complete test case. What you've written below isn't
entirely clear about what's going on. I believe bytea decoding
is done correctly. Perhaps you are doing something like calling
getBinaryStream on a column that is not bytea?

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ken Johanson 2007-01-21 19:06:51 Re: Synthesize support for Statement.getGeneratedKeys()?
Previous Message Michael Schmidt 2007-01-20 22:21:53 pg_dump in PostgreSQL version 8.2 not working in Java app