Hi all,
I've a problem with the result sets using criteria api. The result set to be upper cased by the criteria list().

SQL query:
select empid, upper(name), dept from employee where empid=1;

The above query returns the result with the upper case name column.
But the below query returns the exact name values from the table.

Criteria query:
Criteria criteria = session.createCriteria(Employee.class);
List list = criteria.add(Restrictions.ilike("empid", empid)).list();

I appreciate if any one clarify how to resolve this issue.

Thanks
Velu

If you want the name in uppercase then use toUpperCase() function

Thx,
Murugesan.

Thanks for your reply murugesan.
I found another solution as we can make the Hibernate to deal with upper case of the result set by defining below in mapping file.

<property name="name" column="NAME" formula="upper(NAME)" />

Thanks
Velu

Yes, thats a solution. But in that case your name will always be in uppercase. Is that wanted?

Yes.. I wanted the result set should return the name field upper cased.