Re: jdbc lob and postgresql
От | Thomas Kellerer |
---|---|
Тема | Re: jdbc lob and postgresql |
Дата | |
Msg-id | fjqq76$4ma$1@ger.gmane.org обсуждение исходный текст |
Ответ на | Re: jdbc lob and postgresql (Kris Jurka <books@ejurka.com>) |
Ответы |
Re: jdbc lob and postgresql
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: