Re: Large objects with JDBC

From: Joachim Achtzehnter <joachim(at)kraut(dot)bc(dot)ca>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Large objects with JDBC
Date: 2000-08-13 19:58:49
Message-ID: Pine.LNX.4.21.0008131253590.4724-100000@wizard.kraut.bc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)realtimeint(dot)com (http://www.realtimeint.com)
private: joachim(at)kraut(dot)bc(dot)ca (http://www.kraut.bc.ca)

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-08-14 06:45:29 RE: JDBC2 support
Previous Message george stewart 2000-08-13 16:04:19 Link for osage.sourceforge.net at pgsql interfaces