Hibernate Criteria Restrictions AND / OR combination

by

think works 

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));

More Related Contents:

  1. JPA and Hibernate – Criteria vs. JPQL or HQL
  2. Hibernate Criteria Join with 3 Tables
  3. Criteria.DISTINCT_ROOT_ENTITY vs Projections.distinct
  4. Hibernate: Difference between session.get and session.load
  5. Hibernate: one-to-one lazy loading, optional = false
  6. How to use Spring managed Hibernate interceptors in Spring Boot?
  7. @OrderColumn annotation in Hibernate 3.5
  8. How to query data for Primefaces dataTable using lazy loading and pagination
  9. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  10. Performing Date/Time Math In HQL?
  11. How to connect to multiple databases in Hibernate
  12. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  13. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  14. how to return Map with HQL
  15. How to transform a flat result set using Hibernate
  16. Spring Data JPA – Pass column name and value as parameters
  17. hibernate could not get next sequence value
  18. Invalidating JPA EntityManager session
  19. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  20. Grails 2.4 and hibernate4 errors with run-app
  21. Hibernate/JPA ManyToOne vs OneToMany
  22. When to Use EntityManager.clear()?
  23. How is Hibernate deciding order of update/insert/delete
  24. Hibernate inserts duplicates into a @OneToMany collection
  25. hibernate – get id after save object
  26. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  27. Hibernate 3.6 – session.get() vs session.load()
  28. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  29. CDI injection in EntityListeners
  30. UnsupportedOperationException: The application must supply JDBC connections

Leave a Comment