Thread: getBlob and setBlob on OID columns

getBlob and setBlob on OID columns

From
Bill Schneider
Date:
I am using 7.3.x and it looks like PreparedStatement methods getBlob and
setBlob appear to work with OID columns, at least on the surface.  I am
aware of issues with deletion (content not garbage-collected when row
deleted).  Are there any other subtleties that I may be missing?

-- Bill
--
Bill Schneider
Chief Architect

Vecna Technologies
5004 Lehigh Rd., Suite B
College Park, MD 20740
bschneider@vecna.com
t: 301-864-7594
f: 301-699-3180


Re: getBlob and setBlob on OID columns

From
Kris Jurka
Date:

On Sun, 23 May 2004, Bill Schneider wrote:

> I am using 7.3.x and it looks like PreparedStatement methods getBlob and
> setBlob appear to work with OID columns, at least on the surface.  I am
> aware of issues with deletion (content not garbage-collected when row
> deleted).  Are there any other subtleties that I may be missing?
>

You cannot use this method with Connection.setAutoCommit(true) because
large objects require a transaction to use.

Kris Jurka