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

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.

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