Skip site navigation (1) Skip section navigation (2)

Re: JDBC and Blobs

From: Dev <dev_hyd2001(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC and Blobs
Date: 2008-06-23 07:06:13
Message-ID: 468942.89271.qm@web53707.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi all,



Thanx for the responses. Looks like contrib/lo is the way to go !



cheers



/Dev

--- On Thu, 6/19/08, David Wall <d(dot)wall(at)computer(dot)org> wrote:
From: David Wall <d(dot)wall(at)computer(dot)org>
Subject: Re: [JDBC] JDBC and Blobs
To: dev_hyd2001(at)yahoo(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Date: Thursday, June 19, 2008, 7:33 PM




  


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?

        
      
    
  
  


The JDBC driver should take care of creating and deleting the
underlying LO.  However, with PG, the deleted LO isn't physically
removed until you run contrib/vacuumlo.  We include vacuumlo in our
daily db maintenance routines (pg_dump, vacuum, analyze, vacuumlo).



David

 



      

In response to

pgsql-jdbc by date

Next:From: 王铁Date: 2008-06-25 06:29:33
Subject:
Previous:From: Oliver JowettDate: 2008-06-23 06:32:10
Subject: Re: PreparedStatement implementation needet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group