Looks like Cayenne attempts to read CLOB as a byte[] instead of a
String, which is odd, and is likely due to Oracle driver incorrectly
reporting the result type. One possible way around it is using the
#result directive in SQLTemplate. The downside of it is that if it is
used, it has to be
Hello,
Have you any experience using a query with an Oracle "CONTAINS"
clause? I'm trying to get results back from a SQLTemplate query from a
table with CLOBs that have been indexed to improve performance with
the form of:
select * from entity where CONTAINS(entityDescription, 'blood%', 1
Thanks Tore, but my initial problem is understand Andrus's tips:
3 Run class generator to generate the _Xyz superclasses.
4 Change the existing classes by hand to inherit from _Xyz counterpart.
5 Remove existing persistence fields, and use superclass getters and
setters to access them. * Change the