Integration

I have read the Toplink tip regarding lobs as well as (I think) every discussion topic related to the subject, but I am still having problems storing data in a blob.

If I do what the Toplink tip says and use a TypeConversionMapping to java.sql.Blob, I get the error message "Inconsistent data types, got: BLOB". This is an Oracle error, not a Toplink error.

If I use a direct mapping, I can store small objects, probably less than the 4 or 5k limit that has been discussed. When I try something larger, I don't get an exception but the database connection seems to time out and the row does not get saved.

I have tried JDBC drivers 10.1.0.2.0 and 9.0.2.0.0 and the results are the same. I have turned on both byte array and stream binding (in that order) just like the tip says to and I have set the platform to Oracle9. I am mapping the blob column to a byte[].

If anyone has any suggestions or samples of blobs working, I would be very appreciative. Thanks in advance.

By the way, long raw works perfectly in place of blob, but since it is being deprecated, I need to figure out how to make blobs work.