|(no subject) [message #704553 is a reply to message #703539]
||Thu, 28 July 2011 19:22
| Chris Delahunt
Registered: July 2009
I do not believe Oracle allows using = on clobs. You will need to try something else, such as converting the clob in the database to a string, using EclipseLink's JPQL FUNC to use the database TO_CHAR function. |
"select entity.clobField from Entity entity where (FUNC(TO_CHAR, entity.clobField) = '9BSMsjkuGA') and ... "
Or use the LIKE operator instead of equals:
"select entity.clobField from Entity entity where (entity.clobField LIKE '9BSMsjkuGA') and ... "
[Updated on: Thu, 28 July 2011 19:29]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.09520 seconds