Re: Problems retrieving data from bytea field - Mailing list pgsql-jdbc

From Dirk Bromberg
Subject Re: Problems retrieving data from bytea field
Date
Msg-id 000101c2ff23$e73c9280$24ddfea9@xbserv
Whole thread Raw
In response to Re: Problems retrieving data from bytea field  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
You can take the pg72jdbc.jar, this works. (with postgres 7.3 and
bytea's).

Dirk




>-----Ursprüngliche Nachricht-----
>Von: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] Im Auftrag von Barry Lind
>Gesendet: Mittwoch, 9. April 2003 23:29
>An: Iran
>Cc: pgsql-jdbc@postgresql.org
>Betreff: Re: [JDBC] Problems retrieving data from bytea field
>
>
>Iran,
>
>This is a bug in the database server in 7.3.  The server is doing
>character set translation on the binary data being returned to
>the jdbc
>client.  This bug was reported a couple of months ago on the
>pgsql-hackers mail list.  I don't know if it has been fixed yet.
>
>thanks,
>--Barry
>
>
>Iran wrote:
>> Hi. I'm havnig a problem when try to retrieve binary data
>from a bytea
>> field where I'm storing na image (jpg).
>>
>> First of all, my setup is, RedHat 8.0, PostgreSQL 7.3.2 and
>I'm trying
>> to access this data using the latest JDBC stable driver released (I
>> think) which is the pg73jdbc2.jar (I tried with pg73jdbc3.jar too).
>>
>> The store process occurs nicely, but when I retrieve this data from
>> database, it comes corrupted and I invariably got more bytes than I
>> stored.
>>
>> What am I missing here?
>>
>> Thanx in advance.
>>
>> iran
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>>     (send "unregister YourEmailAddressHere" to
>majordomo@postgresql.org)
>>
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>


pgsql-jdbc by date:

Previous
From: "agnes"
Date:
Subject: traversing an array column
Next
From: "Iran"
Date:
Subject: RES: Problems retrieving data from bytea field