Re: Please help with binary file

On 02/07/2003 06:38 Akash Shah wrote:
> Hi ,
>
> I am trying to upload binary file to the PostgreSQL 7.3.2 with JDBC3
> driver
> supplied by postgresql (pg73jdbc3). The table to which I am trying to
> save
> the file has a field of OID datatype. And while doing so I get
>
> "java.sql.SQLException: ERROR: oidin.............." error.
>
> I tried changing OID data type to bytea. After that code worked and I
> tried
> file sizes from 4KB to1.6 MB. If file size is larger than that ( even for
> a
> 10 MB size file ) execution just gets stuck. No error, no exception
> thrown.

Reaed the docs (5.6 Storing Binary Data). They give sample code of how to
use Large Objects with JDBC. I think this will do what you want.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+