Hibernate org.hibernate.criterion.Example.create OR clause

Question

I'm using org.hibernate.criterion.Example.create to create my query from my Entity object. Everything is fine, but using this method the SQL is only created with AND clause between the restrictions.

Is it possible to use org.hibernate.criterion.Example.create but with OR clause?

This may be helpful to you: http://stackoverflow.com/questions/8126589/hibernate-criteria-restrictions-and-or-combination — TonyW, Jul 24 '14 at 02:26

score 1 · Answer 1 · answered Jul 24 '14 at 02:29

1

Yes, you can

session.createCriteria(Person.class) .add(Restrictions.disjunction() .add(Restrictions.eq("name", "James")) .add(Restrictions.eq("age", 20)) );

In the example above, class Person would have properties name and age and you would be selecting those people with name = "James" or age = 20.

answered Jul 24 '14 at 02:29

JamesB

7,774
2
22
21

1

The question is about using the `Example` class with `or`, not about creating or criterias. – Arturo Volpe Jul 24 '14 at 02:45
exactly as @AVolpe said. The question is related to Example. – Sergio Santiago Jul 24 '14 at 03:11

score 1 · Accepted Answer · answered Jul 24 '14 at 02:42

The short answer is no, you can not do it, but you can implement a OrExample, it's pretty easy, only check the source code of the Example and change the and for or (see sourcecode line 329). Since the methods are protected, you can extend it and override just the necesary.

Something like this:

public class OrExample extends org.hibernate.criterion.Example {

    @Override
    protected void appendPropertyCondition(
        String propertyName,
        Object propertyValue,
        Criteria criteria,
        CriteriaQuery cq,
        StringBuffer buf)
    throws HibernateException {
        Criterion crit;
        if ( propertyValue!=null ) {
            boolean isString = propertyValue instanceof String;
            if ( isLikeEnabled && isString ) {
                crit = new LikeExpression(
                        propertyName,
                        ( String ) propertyValue,
                        matchMode,
                        escapeCharacter,
                        isIgnoreCaseEnabled
                );
            }
            else {
                crit = new SimpleExpression( propertyName, propertyValue, "=", isIgnoreCaseEnabled && isString );
            }
        }
        else {
            crit = new NullExpression(propertyName);
        }
        String critCondition = crit.toSqlString(criteria, cq);
        if ( buf.length()>1 && critCondition.trim().length()>0 ) buf.append(" or ");
        buf.append(critCondition);
    }

See the or instead of the original and.

score 1 · Answer 3 · edited May 23 '17 at 12:10

1

an old post from SO may be helpful: Hibernate Criteria Restrictions AND / OR combination

Criteria criteria = getSession().createCriteria(clazz); 
Criterion rest1= Restrictions.and(Restrictions.eq("A", "X"), 
           Restrictions.in("B", Arrays.asList("X","Y")));
Criterion rest2= Restrictions.and(Restrictions.eq("A", "Y"), 
           Restrictions.eq("B", "Z"));
criteria.add(Restrictions.or(rest1, rest2));

edited May 23 '17 at 12:10

Community

1
1

answered Jul 24 '14 at 02:44

TonyW

18,375
42
110
183

The question is about using the `Example` class with `or`, not about creating or criterias. – Arturo Volpe Jul 24 '14 at 02:45

Hibernate org.hibernate.criterion.Example.create OR clause

3 Answers3