Hibernate: Throws Clobs are not cacheable Exception when try to cache

[jackrish krish]

[color=blue][/color]
Hi,
I am using hibernate in my application and i had implemented second level cache .My table has clob data type .When cache the clob data,
it displays "clobs are not cacheable". is there any way to cache the clob type . If not cachebale, can you explain me why its not caching.
(Second level caching is working fine with all other data type except clob or blob).

Any immediate help would be appriciated .....
Thanks in Advance ..

[Anantha Sharma]

refer to hibernate forum

https://forum.hibernate.org/viewtopic.php?f=9&t=985980&start=0

[jackrish krish]

Thaks for your reply sharma,

I read your post . In my application i should have to use clob or blob datatype to handle lengthy data and also i need to use the second level cache .In this case ,it does not caching the clob or blob data . caching is working properly with string,interger..... data. I sthere any other way to handle this .

If anybody knows please help to solve this ..

Thanks...

[Anantha Sharma]

I understand your requirement, you need to say that its a clob but for hibernate you need to configure the field as String...

the post on the link contains a piece of code which does just that...