Kris Jurka, 13.12.2007 08:24:
Using a PreparedStatement with setBinaryStream() to insert the blob
and getBinaryStream() to read the BLOB works fine for me.
It depends how you want to handle binary data on the server side.
get/setBinaryStream only work with the bytea data type. getBlob/setBlob
only work with real large objects (oid data type). Both methods work,
it's just a tradeoff on how you want handle it on the server. The API
downside of Blob is that only JDBC4 offers a portable way to create a
Blob (Connection.createBlob) and the pg driver does not implement that yet.
I just looked through the manual but could not find an "oid data type".
I thought that oids were some kind of unique row "address" (at least
that's what http://www.postgresql.org/docs/8.2/static/datatype-oid.html
sates as far as I can tell)
Can you point me to the manual for these types of BLOBs are described?
The "Data Types" chapter does not list them as far as I can tell.
Background: I'm maintaining a SQL front end (Java/JDBC based) which
supports reading and writing of BLOBs and I would like to make sure that
I also support these "oid data type" BLOBs
Regards
Thomas
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
