How to specify and condition using query by Example?

dleal · **Posted:** Fri Apr 07, 2006 6:01 am

Dear members,

We have detected that when we use for example a query like this:

Code:

Cat cat = new Cat();
cat.setSex('F');
cat.setColor(Color.BLACK);
List results = session.createCriteria(Cat.class)
    .add( Example.create(cat) )
    .list();

we get on the result a "OR" condition, so we would get all the cats that are Female or Black. On the Reference Manual there is no more additional information about how it is solved:

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#querycriteria-examples

Do you have any idea how to impose we want a AND condition, that is all cats that are females and black too?

Thanks in advance,

David