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.
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 |