[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5339) Restrictions.ilike doesn't work on integer columns

[Gail Badner (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gail Badner resolved HHH-5339.
------------------------------

      Assignee: Gail Badner
    Resolution: Rejected

Restrictions.ilike is intended to be used on strings. Restrictions.sqlRestriction(...) should be used instead.

> Restrictions.ilike doesn't work on integer columns
> --------------------------------------------------
>
>                 Key: HHH-5339
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5339
>             Project: Hibernate Core
>          Issue Type: Bug
>            Reporter: Chris Wilson
>            Assignee: Gail Badner
>         Attachments: HibernateCriteriaLikeIntegerTest.java
>
>
> Hibernate doesn't like using {@link Restrictions#ilike} on integer columns.
> It uses the SQL lowercase function on the column, the result of which
> must be a character type (CHAR or VARCHAR) because:
> bq. LOWER Converts a string to all lowercase characters ([SQL in a Nutshell|http://oreilly.com/catalog/sqlnut/chapter/ch04.html])
> But IlikeExpression.getTypedValues() asks the criteria query for the type of the typed values, which returns the underlying type, which in this case is an integer type.
> Hibernate then throws a ClassCastException, trying to fit the string parameter into an Integer TypedValue:
> * java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer
> * at org.hibernate.type.IntegerType.set(IntegerType.java:64)
> * at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:154)
> * at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
> * at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1732)
> * at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1703)
> * at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1593)
> * at org.hibernate.loader.Loader.doQuery(Loader.java:696)
> * at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
> * at org.hibernate.loader.Loader.doList(Loader.java:2232)
> * at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
> * at org.hibernate.loader.Loader.list(Loader.java:2124)
> * at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
> * at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
> * at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
> * at org.wfp.rita.datafacade.RequestDao.listRequests(RequestDao.java:736)
> I can't give you a patch because I can't build Hibernate because the actual instructions are missing from [http://www.hibernate.org/sourcecode.html]. I'll attach the test in a second.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira