binary data in `bytea' column - Mailing list pgsql-jdbc

From Anton Komarevtsev
Subject binary data in `bytea' column
Date
Msg-id 4084370A.608@rt.mipt.ru
Whole thread Raw
Responses Re: binary data in `bytea' column
List pgsql-jdbc
Hello.

It's nesessary for me to store bianary data (images, sounds, texts as
bytes) in the database. What should I use for better scalability,
generic `PreparedStatement.setBinaryStream' and
`SesultSet.getBinaryStream' or Large Objects?

I use Postgres 7.4, and autocommit=on is hardcoded in it. But I've
listened, that Large Objects may only work in a single transaction. So,
if I should use Large Objects (if so), how should I use them?

                                                    Anton

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Bad timestamp external representation ''
Next
From: Oliver Jowett
Date:
Subject: Re: binary data in `bytea' column