Lists: | pgsql-jdbc |
---|
From: | Bill Schneider <bschneider(at)vecna(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | getBlob and setBlob on OID columns |
Date: | 2004-05-23 20:43:15 |
Message-ID: | 40B10CE3.8040505@vecna.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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(at)vecna(dot)com
t: 301-864-7594
f: 301-699-3180
From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Bill Schneider <bschneider(at)vecna(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: getBlob and setBlob on OID columns |
Date: | 2004-05-23 21:07:35 |
Message-ID: | Pine.BSO.4.56.0405231605310.5428@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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