Problem with JDBC and Large Objects - Mailing list pgsql-jdbc

From Randall Hauch
Subject Problem with JDBC and Large Objects
Date
Msg-id 44DA6BC2.7040903@revelytix.com
Whole thread Raw
Responses Re: Problem with JDBC and Large Objects  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
I'm using the latest JDBC driver (8.1-407) with PostgreSQL 8.1.3 (on Windows) and PostgreSQL 8.1.4 (on Debian).  I've
searchedthe archives, and found several applicable thread that were never responded to or apparently resolved:<br
/><ul><li><aclass="moz-txt-link-freetext"
href="http://archives.postgresql.org/pgsql-bugs/2001-04/msg00216.php">http://archives.postgresql.org/pgsql-bugs/2001-04/msg00216.php</a><li><a
class="moz-txt-link-freetext"
href="http://mail-archive.objectweb.org/dods/2001-11/msg00007.html">http://mail-archive.objectweb.org/dods/2001-11/msg00007.html</a></ul>
I'musing JDBC to store (binary) files in a database, and have tried storing the content in a BYTEA column and using the
LargeObject API and storing a OID column in my table.  I am able to upload various files into the database, but when I
downloadthem the 0xFF characters in the uploaded files have all been stripped.  I've looked for a configuration
setting,but don't see anything of use.  (The database or client character encodings should not apply to binary
data.)<br/><br /> Any suggestions?  Is this a bug?  (If it is a bug, it seems hard to believe that nobody has run
acrossthis.)<br /><br /> Thanks in advance!<br /><br /> Randall<br /><br /><br /> 

pgsql-jdbc by date:

Previous
From: "James Im"
Date:
Subject: Re: SQL query never ends
Next
From: Oliver Jowett
Date:
Subject: Re: SQL query never ends