Re: updateBlob()-example?

On Thu, 12 Feb 2004, Guido Fiala wrote:

> Hallo together,
>
> maybe someone can help - i can get updateBlob() working and i couldn't find
> any working example so far.
>

It is entirely unclear what your column's underlying data type is, for
binary data it should be oid or bytea, but the only mention of datatype in
your email is varchar.  The Blob interface only works with the oid
datatype and large object method and even then support is poor.  JDBC3 has
added write support for blobs, but these have not been implemented in the
pg JDBC driver.  If you want to use large objects the easiest way is to
pass compatible=7.1 as a URL parameter and then use setBytes/getBytes.
Could you be more clear on what you want to do and where it is failing?
The numerous one line snippets you have included aren't clear and actually
seem contradictory to me.

Kris Jurka