java.lang.UnsupportedOperationException: Blobs are not cacheable

Question

After adding java.sql.Blob field to one of my objects the hibernate persistence manager is now throwing Blobs are not cacheable exception.

Any idea how to solve this other than disabling the cache. I tried making the field transient but of course with no success.

BTW I use the latest Spring Framework.

Can you provide more details? Exception? DB? Have you tried turning off caching?

Mat Banik · Accepted Answer · 2011-10-14 15:42:45Z

up vote 3 down vote accepted

You have 2 choices.

if you don't need the relevant blob data cached, move it into a secondary hibernate object which is not cached
if you do want the data cached (in which case i would assume it has a limited size), then you can use the hibernate type which maps the data to/from a byte[] ("binary" i believe) - http://www.mkyong.com/hibernate/hibernate-save-image-into-database/

edited Oct 14 '11 at 15:42

Mat Banik
3,84972179

answered Oct 14 '11 at 15:24

jtahlborn
14.8k1819

@MattBanik - if you go the binary route, just make sure someone doesn't try to save a 2GB image. – jtahlborn Oct 14 '11 at 15:49

feedback

1 Answer