Criteria operations on table's columns

auriga · **Joined:** Tue Oct 21, 2008 7:09 am **Posts:** 1

I have the following table:
TABLE
ID Integer,
IMPORTO Integer,
RESIDUO Integer

which is mapped (from Bean) with MyClass:
MyClass{
Integer Id
Integer a
Integer b
}

I need to execute the following query (using CRITERIA API):
SELECT FROM TABLE WHERE IMPORTO - RESIDUO < 10;

which becomes

Criteria criteria = session.createCriteria(MyClass.class);
criteria.add(Restrictions.lt("a", b + 10");
criteria.list();

but i receive this error:

ClassCastException

2008-10-21 10:05:44,080 - DEBUG [Dp] CRITERIA: CriteriaImpl(MyClass:this[][a>b+ 10])

2008-10-21 10:05:44,126 - DEBUG [Servlet] Error:java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer

What's wrong with my query?
Can anyone helps me?
Thnx.

Hibernate version 3.2.6

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

You are getting this exception as Restriction.lt expects first argument to be name of property and second argument to be value to which this property should be compared.

I don't think this kind of expression can be handled through lt or ltProperty method but you can use sql restriction to get the job done.