Streaming blob to db

From: 時期 精霊 <kuon(at)goyman(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Streaming blob to db
Date: 2005-07-01 16:05:29
Message-ID: 15D1FD8F-91C2-4565-B804-E43DDEEC93AB@goyman.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

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 seeked the web but I did not found any working example.

I use postgresql 8.0.1 with bytea field.

The data size will be around:

<1mb 50%
1 - 100mb 30%
>100mb 20%

Any idea of the best approach?

Regards

Kuon

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2005-07-01 17:15:49 Re: XA support
Previous Message Dave Cramer 2005-07-01 14:26:09 Re: jdbc cts final diff for review