RE: Large objects with JDBC - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: Large objects with JDBC
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B24B@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to Large objects with JDBC  (Rob Judd <rjudd@mlug.missouri.edu>)
List pgsql-interfaces
Which is true for any of our extensions. It's in there however, because the
standard stuff can then be implemented.

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council


-----Original Message-----
From: Joachim Achtzehnter [mailto:joachim@kraut.bc.ca]
Sent: Sunday, August 13, 2000 8:59 PM
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Large objects with JDBC


Yesterday, in a message to pgsql-interfaces, Rob Judd wrote:
>
> I would like to save Java objects in the database.  I tried a couple of
> different ways before finding one that worked, and I'd like to know if
> my first attempts failed because the functionality is missing in the
> java classes, or if I did something wrong.  
> 
> Serialize.create(conn, Vector.class) failed - looking in the sources it
> seemed to be missing the code to support arrays.
> 
> PreparedStatement.setBinaryStream(1, InputStream, length) failed with a
> not supported exception.

You can use PreparedStatement.setBytes() as an alternative.

> I did manage to get this working eventually using a different method
> (the large object API) but the other ways seemed much more straight
> forward.

Another disadvantage of the large object API is that it is specific to
Postgresql. This can become an issue if you ever need to port to another
database, e.g. Interbase.

Joachim

--
work:     joachima@realtimeint.com (http://www.realtimeint.com)
private:  joachim@kraut.bc.ca      (http://www.kraut.bc.ca)



pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: Large objects with JDBC
Next
From: Nelson Ferreira Jr
Date:
Subject: JDBC - error reading BLOBs