Re: JDBC and Blobs

Dev wrote:
> I have a field in my database table of type OID which is
> suppose to be used to store binary data. I plan on using the
> setBlob and getBlob methods for storing and retrieving
> entries from the table. Is that the right way to proceed? If
> I delete a row in that table , will it delete the binary data
> as well from the database server?

No; the best way would be to create a trigger on the table that
will delete the large object if you delete (or change) the
OID in the table row.

This is of course only practical if the same large object
is not referenced by more than one table...

Yours,
Laurenz Albe