Hi,

We are facing some performance issues with Oracle10g database using hibernate. oracle.sql.BLOB object is taking more time in persisting the BLOB into the database. When we use the setBytes method rather than creating a BLOB object and directly put the byte[] the performance improves a lot. Is setBytes method an efficient way of handling BLOB data in Oracle10g.
How can i avoid creating a BLOB object? Are there any other ways by ways by which we can save an BLOB objects into the database.

Thanks.

You can use a custom UserType if you want to control how the field is saved