Re: Streaming blob to db

From: 時期 精霊 <kuon(at)goyman(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Streaming blob to db
Date: 2005-07-05 10:23:30
Message-ID: 15EE35F3-F225-443B-831D-D1115E37E6DA@goyman.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

How can I trigger the deletion of the large object when the row
containing the oid is deleted?

I mean I know that:
DELETE FROM pg_largeobject WHERE loid = nnn

But is there in jdbc, an automatic way to handle that?

Regards

Kuon

On Jul 4, 2005, at 11:33 AM, Kris Jurka wrote:

>
>
> On Fri, 1 Jul 2005, [UTF-8] æ^Y^Bæ^\^_ ç²¾é^\Š wrote:
>
>>
>> I got a web application that use jdbc and that will need to stream
>> binary data to the database.
>>
>> My application need an outputstream to send the data to the db, and
>> an inputstream to read the data from the db.
>>
>> I use postgresql 8.0.1 with bytea field.
>>
>>
>>> 100mb 20%
>>>
>>
>>
>
> If you are really dealing with 100+Mb files you should probably
> look into
> using large objects instead of bytea storage. This will provide the
> streaming interfaces you are looking for and avoid excessive memory
> usage.
>
> http://jdbc.postgresql.org/documentation/80/binary-data.html
>
> Kris Jurka
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message PANOZZ00USER0002 2005-07-05 12:37:58 Problem with Jdk1.4 and Linux
Previous Message Oliver Jowett 2005-07-05 00:03:30 Re: Create Database using JDBC