Problem with Criteria.list()

ensoreus · **Joined:** Thu Mar 13, 2008 6:18 am **Posts:** 4

Hi,

I am trying to fetch all entities from the database, filtered by a given entity A which is in a many-to-one relationship with another entity B.

The problem is in the select statement generated by Hibernate. In the WHERE clause, only the fields from entity A appear, not the ones from
the joined entity B. So if I change the fields in B, but not the fields in A, List<T> ret from the code below will contain one element, even
though there is no such entity in the database.

Code:

            List<T> ret = null;

            Session session = getSession();
            Criteria crit=session.createCriteria(getPersistentClass());
            Example ex= Example.create(entity);     // entity A
            
            crit.add(ex);
            ret=crit.list();

What am I doing wrong ?

Any help would be highly appreciated.
Thanks.

Andrei

nagkumar · **Posted:** Sat Jun 14, 2008 8:36 am

Try the query some thing like this

Session session = HibernateUtil.getSession();
Criteria cr = session.createCriteria(Relation.class);
cr.add(Restrictions.ilike(Relation.FIELD_RELATION, aRelation));
cr.createCriteria(UserAssociated.FIELD_USER).add(
Restrictions.ilike(User.FIELD_LOGIN_ID, aLoginID));
Relation lRelation = (Relation) cr.uniqueResult();

instead of using example etc..

Regards,
Nagendra

Cameron McKenzie · **Posted:** Sat Jun 14, 2008 9:53 am

Indeed, check out the Restrictions class. Here's the Hibernate JavaDoc for the Criterion Restrictions class:

http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Restrictions.html

Quote:

static Criterion
ilike(String propertyName, Object value)
A case-insensitive "like", similar to Postgres ilike operator
static Criterion

ilike(String propertyName, String value, MatchMode matchMode)
A case-insensitive "like", similar to Postgres ilike operator

For more examples, you can check out this tutorial of mine:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi

This tutorial does a good job of contrasting what you can do with the Example class and what you can do with the Restrictions class of the hibernate Criteria API.

ensoreus · **Joined:** Thu Mar 13, 2008 6:18 am **Posts:** 4

Thanks a lot for the help and the tutorial. Now it works perfect.

Cameron McKenzie · **Posted:** Tue Jun 17, 2008 3:53 pm

Happy to be of assistance. :)