MappingBlobs

How-To: Map Large Objects (LOBs) to Oracle Databases with OracleAS TopLink

For TopLink904 and above, see:

http://www.oracle.com/technology/products/ias/toplink/technical/tips/LOB/index.html

Basically, use a TypeConversionMapping? and set the target class to java.sql.Blob. It just works.

Prior to TopLink904, one had to insert the EMPTY_BLOB() and manually update the row. Ie. make JDBC calls to get the Blob object, get a stream to/from it, and read/write the stream. Clumsy.

See Also

MappingClobs