Re: Oracle CONTAINS clause?

2009-08-10 Thread Andrus Adamchik
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

Oracle CONTAINS clause?

2009-08-10 Thread Lawrence Gerstley
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

Re: Cayenne POJO inheritance

2009-08-10 Thread Gilberto C. Andrade
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