saving Outputstream (with "Blob" or "BLOB&quo

orkus9 · **Joined:** Wed Oct 13, 2004 5:32 am **Posts:** 8

is there an elegant way to save an outputstream in oracale-db (with hibernate)

i tried to use "Blob" and "BLOB" but it doesn

georgeuoa · **Posted:** Thu Nov 11, 2004 3:35 am

Most of the Clob & Blob issues are resolved in the new 10g JDBC Driver, so you might want to give it a try.

G.

christian · **Posted:** Thu Nov 11, 2004 6:02 am

It still needs special treatment with casts to Oracle ResultSet, etc. If you use a decent Oracle driver (ie. not one made by Oracle), you get normal JDBC LOB handling.

orkus9 · **Joined:** Wed Oct 13, 2004 5:32 am **Posts:** 8

ok.
i did it with oracle.sql.BLOB

it works, but i have 2 convert the stream to a byte[] first.
its not as performant as saving the stream directly.

thx for your suggestion