LargeObjects problems

From: Gustavo Muñoz <gmunoz(at)interware(dot)com(dot)mx>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: LargeObjects problems
Date: 2003-02-24 05:06:46
Message-ID: 3E59A866.6010803@interware.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi:

I have inserted a LargeObject using LargeObject Postgres API but when I
get back the bytes they are changed in some way. For instance, if I
insert the bytes of a zip or a jpg file (and they are ok, because I can
view the contents), when I retrieve the bytes from the database and
create new files with the bytes, the original files and the new ones
differ. They contain the same number of bytes, but they differ. No
longer winzip or iexplorer open the new files, and diff says the files
differ.
I'm using windows version of postgres, and jdk1.4.1_01
The field's data type is oid, of course

By the way, if I use the JDBC standard API (setBytes o setBinaryStream
using bytea) I get an OutOfMemoryError with files with size equals or
larger than 10Mb.

Regards,
Gustavo Muñoz.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Roj Niyogi 2003-02-24 07:50:38 sample JSP code connecting to PostgreSQL
Previous Message Ludwig Heinrich 2003-02-24 05:04:20 JDBC Driver for Mac OSX