Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Re: JDBC and Bl...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 6 Topic 1975 of 2010
Post > Topic >>

Re: JDBC and Blobs

by craig@[EMAIL PROTECTED] (Craig Ringer) Jun 19, 2008 at 09:27 PM

Dev wrote:
> Hi,
> 
> 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?

I haven't used it myself, but my understanding is that deleting the row 
will NOT free the associated blob. The oid is only a reference to the
blob.

You probably want the `lo' contrib module:

http://www.postgresql.org/docs/8.3/static/lo.html

--
Craig Ringer

-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
 




 6 Posts in Topic:
JDBC and Blobs
dev_hyd2001@[EMAIL PROTEC  2008-06-19 02:18:57 
Re: JDBC and Blobs
craig@[EMAIL PROTECTED]   2008-06-19 21:27:36 
Re: JDBC and Blobs
laurenz.albe@[EMAIL PROTE  2008-06-19 15:34:15 
Re: JDBC and Blobs
tgl@[EMAIL PROTECTED] (T  2008-06-19 10:43:28 
Re: JDBC and Blobs
d.wall@[EMAIL PROTECTED]   2008-06-19 10:33:14 
Re: JDBC and Blobs
dev_hyd2001@[EMAIL PROTEC  2008-06-23 00:06:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Aug 21 18:30:51 CDT 2008.