Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Steve_Clark
I guess I had modified JdbcAccessImpl to add some print statements. I have solved the problem. Here's what was happening: I had code like this: crit.addGreaterThan("contains(clob_column, 'someval')", "0"), because I needed to get SQL like this: contains(clob_column, 'someval') > 0. When OJB p

Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Armin Waibel
Hi Steve, do you use a modified version of JdbcAccessImpl? The stack trace show line 327 in method 'executeQuery' as causer but this doesn't match with 1.0.4 version of this class (SNV: 365259) ... at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:327

Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Dennis Bekkering
Hello Steve, What does your criteria code look like? I have the same problem when applying like operation on a CLOB. I therefore changed the fieldtype to varchar2(4000). Cheers, Dennis