setBlob/getBlob, slony and bytea - Mailing list pgsql-jdbc

From Tore Halset
Subject setBlob/getBlob, slony and bytea
Date
Msg-id B0F1EB43-2349-49A5-B3E0-61D36D5CBB85@pvv.ntnu.no
Whole thread Raw
Responses Re: setBlob/getBlob, slony and bytea  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hello.

My application uses lots of setBlob and getBlob to handle the oid
blobs in the database. I do not use streaming of blobs as my largest
blob are only 5MB.

I want to try out Slony-I. It can replicate bytea fields, but not oid
blobs. As I do not use streaming I just switched over the fields from
oid to bytea.

After the switch to bytea setBlob and getBlob are not working
anymore. Can this be fixed in the driver or do I need to detect if
the blob in the database are oid or bytea before deciding if I should
use setBlob or setBytes?

  - Tore.

pgsql-jdbc by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: XA end then join fix for WebLogic
Next
From: Kris Jurka
Date:
Subject: Re: XA end then join fix for WebLogic