Do you have any working examples on how to setting restriction constraint of property that maps to a Clob type in database table?
For instance, calling
where propertyName is mapping to a Clob-typed column in a table.
I always got java.sql.SQLException: ORA-00932: inconsistent datatypes: expected NUMBER got LONG exception
How do you use Restrictions.sqlRestriction(sql)? Would it be a possible replacement?
I have been spending time converting 'propertyName' from Clob to String in hoping Hibernate will stop complaining about data mismatch when comparing it against value(String) I pass in 2nd parameter. Not successful so far! I am not a DB guy:-)