Expression.like do not work

fmelo · **Joined:** Fri Aug 26, 2005 9:32 pm **Posts:** 1

Hi friends,

I try to use a criteria whit Expression.like and do not work. Someone can help whit that? Thanks.

Hibernate version: 2.1.8
Database: SQL Server 2000
Database Driver: sun.jdbc.odbc.JdbcOdbcDriver
Netbeans with Tomcat bundle: 4.1 / 5.5.7

Here is my code:

Code:

    //Create session
    HibernateBusinessObject hbo = new HibernateBusinessObject();

    List list1 = hbo.getSession().createCriteria(Author.class).add([color=red]Expression.like[/color]("au_lname", s1, MatchMode.ANYWHERE)).list();

    or

    //s1 is a String parameter of method
    List list1;
    Criteria criteira1 = hbo.getSession().createCriteria(Author.class);
    criteira1.add([color=red]Expression.like[/color]("au_lname", "%" + s1 + "%"));
    criteira1.setMaxResults(10);
    list1 = criteira1.list();    

    //Destroy session
    hbo.finalize();

    return list1;

kgignatyev · **Posted:** Sat Aug 27, 2005 11:05 am

Just guessing: your object does not have property 'au_lname', that is the name of the column.
In the criteria we should use object property name, that means that if the Author class has lastName property (getLastName()/setLastName( String v)) then criteria looks like this:
criteira1.add(Expression.like("lastName", "%" + s1 + "%"));