Re: jdbc lob and postgresql - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: jdbc lob and postgresql
Date
Msg-id fjppu4$nj3$1@ger.gmane.org
Whole thread Raw
In response to jdbc lob and postgresql  ("Anu Padki" <padki23@gmail.com>)
Responses Re: jdbc lob and postgresql
List pgsql-general
Anu Padki wrote on 12.12.2007 20:09:
> Hello all,
>
> I am contemplating to use postgresql for a product that requires to
> manipulate many blobs.
> From the documentation I am not clear if one has to use postgres api to
> insert/update/select blobs or one can use standard jdbc api?
> Can I just execute a statement insert into (..) that has a blob and do a
> getBlob to retrieve it?

Using a PreparedStatement with setBinaryStream() to insert the blob and
getBinaryStream() to read the BLOB works fine for me.

Thomas

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Insert/Update/Delete views with INSTEAD OF
Next
From: Jorge Godoy
Date:
Subject: Re: Hijack!