Streaming binary data into db, difference between Blob and LargeO bject

Поиск
Список
Период
Сортировка
От Andreas Prohaska
Тема Streaming binary data into db, difference between Blob and LargeO bject
Дата
Msg-id A11D9B8C48C1D411AE0C000062A129947B1C61@ganymed.allocation.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Shilad Sen
Дата:
Сообщение: Strange encoding problems
Следующее
От: jonathan.lister@vaisala.com
Дата:
Сообщение: Stored Procedure returns a ResultSet