Usage of like condition in Hibernate for Criteria Builder

polppan · **Joined:** Fri May 10, 2013 3:57 pm **Posts:** 4

I am using Hibernate 4.0 and I have the following in DAO class for my filter condition

Code:

ParameterExpression<Long> pexp = criteriaBuilder.parameter(Long.class,"empNo");
criteria.add(criteriaBuilder.like(emp.<String>get(String.valueOf(Employee_.empNo)),
String.valueOf(pexp)));

However when I run I am getting the following exception

Code:

Unable to resolve attribute [org.hibernate.ejb.metamodel.SingularAttributeImpl$Identifier@a21c8
a] against path
java.lang.IllegalArgumentException: Unable to resolve attribute [org.hibernate.ejb.metamodel.Singula
rAttributeImpl$Identifier@a21c8a] against path
    at org.hibernate.ejb.criteria.path.AbstractPathImpl.unknownAttribute(AbstractPathImpl.java:116)
    at org.hibernate.ejb.criteria.path.AbstractPathImpl.locateAttribute(AbstractPathImpl.java:221)
    at org.hibernate.ejb.criteria.path.AbstractPathImpl.get(AbstractPathImpl.java:192)

How can I fix this issue?

I have tried as

Code:

Predicate predicate = criteriaBuilder.like(emp.get(Employee_.empNo).as(String.class), 
                  pexp.as(String.class));

but the generated sql shows as

Code:

where cast(emp0_.EMP_NO as varchar2(255 char)) like cast(? as varchar2(255 char)

shynate26 · **Posted:** Fri May 17, 2013 6:13 am

Hi .

why dont you have duplicate column with formula field and you could cast as to_char(column).

The same can be used in filter condition with out type casting.

Please let know how this worked.

Cheers!

polppan · **Joined:** Fri May 10, 2013 3:57 pm **Posts:** 4

shynate

Thanks for the reply.

You mean another field for

Code:

empNo

as String in Entity class?

Could you be kind enough to point to some example or any code snippet?

Appreciated.

polppan · **Joined:** Fri May 10, 2013 3:57 pm **Posts:** 4

I have added a duplicate column in Entity as

Code:

private String empNoDup;
@Column(name = "employeeNumber, insertable = false, updatable = false")

with getter and setter

I am getting the following exceptions

Code:

 org.hibernate.exception.SQLGrammarException: ORA-00923: FROM keyword not found where expected

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: ORA-00923: FROM
 keyword not found where expected

I believe empNoDup is treating as a database field and it is expecting it to be part of the query? Or should I declare it as transient?
If it is transient then would I be able to use for filter?

Thanks

polppan · **Joined:** Fri May 10, 2013 3:57 pm **Posts:** 4

Thank you shynate26 for providing the idea of duplicating the column for filtering, it works very well. Appreciated.

Regards