ClassCastException when using Restrictions.like on Integer

SCAI_Andre · **Joined:** Fri Mar 28, 2008 7:57 am **Posts:** 1

Hibernate version: .2.2.ga

Hi!

I have the need to use a like expression with "%" as a placeholder on a integer column.

The problem is that Hibernate raises a classcastexception, since it is trying to cast the criterion to an integer.

lCriteria.add(
Restrictions.like(
"myIntColumn",
"1%"
)
);

What can I do about this?

TIA

Regards,
Andre

GGhido · **Joined:** Tue Mar 18, 2008 12:37 pm **Posts:** 4

Not sure if that's possible the way you're trying that out.
Another solution would be to use the Restrictions.sqlRestriction criterion, given a proper SQL statement that converts your INT type to a STRING and then applies the LIKE comparison to it.

ramnath · **Posted:** Fri Mar 28, 2008 4:52 pm

Wildcard search will work on String and will not work on Integer...Converting to String will lead to changes in DB, mapping etc....