Streaming binary data into db, difference between Blob and LargeO bject - Mailing list pgsql-jdbc

From Andreas Prohaska
Subject Streaming binary data into db, difference between Blob and LargeO bject
Date
Msg-id A11D9B8C48C1D411AE0C000062A129947B1C61@ganymed.allocation.net
Whole thread Raw
List pgsql-jdbc
Hi!

What's the difference in the current (7.3.4) JDBC driver between
ordinary JDBC Blobs and the LargeObject API in matters of *streaming*
data into the DB? I don't want to allocate a buffer in the Java VM to
hold the whole blob and send the blob in one piece. Rather I would like
to work with a small buffer (~4kb) and stream the blob from the
filesystem into the db.

Looking at the AbstractJdbc2Blob class I think that JDBC Blobs internally
use LargeObjects. As I know, this was not the case in earlier versions
of the driver. Am I right?

So far, I'm using LargeObjects and everything works fine, but I intend to
use c-jdbc for db replication and would have to use JDBC blobs then.

Thanks a lot.

    Andreas


pgsql-jdbc by date:

Previous
From: Shilad Sen
Date:
Subject: Strange encoding problems
Next
From: jonathan.lister@vaisala.com
Date:
Subject: Stored Procedure returns a ResultSet