Hi all.
I have some tables in my Oracle RDBMS where some fields are CLOB type.
I need to do a query by using hibernate DetachedCriteria setting a where condition on this fields.
How can i do this?
I'ld love to do something like this one:
Code:
DetachedCriteria criteria = DetachedCriteria.forClass(MyEntity.class);
criteria.add(Property.forName("clobField").like("test", MatchMode.ANYWHERE));
criteria.list();
For varchar fields it works pretty good. In CLOB fields i get an error.
I have seen that the generated hibenrtae query in this case doesn't contain the
dbms_lob.substr function.
I really need a solution for this scenario.
Did anybody try to solve it?
It's little bit urgent...
Thank you to everybody.
Best regards.
Angelo
Login
FAQ
Search