Hibernate criteria: Joining table without a mapped association

by

This is indeed possible with criteria:

DetachedCriteria ownerCriteria = DetachedCriteria.forClass(Owner.class);
ownerCriteria.setProjection(Property.forName("id"));
ownerCriteria.add(Restrictions.eq("ownername", "bob"));

Criteria criteria = getSession().createCriteria(Pet.class);
criteria.add(Property.forName("ownerId").in(ownerCriteria));

Update: This actually performs a sub-query instead of a join but it allows you to use Criteria on two entities that do not have a hibernate relationship defined.

More Related Contents:

  1. JPA and Hibernate – Criteria vs. JPQL or HQL
  2. How do you do a limit query in JPQL or HQL?
  3. What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate
  4. How to get SQL from Hibernate Criteria API (*not* for logging)
  5. How can you call custom database functions with Hibernate?
  6. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  7. Hibernate Named Query Order By parameter
  8. Hibernate HQL Query : How to set a Collection as a named parameter of a Query?
  9. How to escape reserved words in Hibernate’s HQL
  10. IN-clause in HQL or Java Persistence Query Language
  11. HQL Hibernate INNER JOIN
  12. Hibernate Criteria for Dates
  13. HQL left join of un-related entities
  14. HQL – row identifier for pagination
  15. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  16. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  17. How to write a like query in HQL
  18. Using hibernate criteria, is there a way to escape special characters?
  19. HQL recursion, how do I do this?
  20. Inserting data in one table using HQL in Hibernate
  21. Hibernate openSession() vs getCurrentSession()
  22. hibernate column name issues
  23. Hibernate use of PostgreSQL sequence does not affect sequence table
  24. JPA Multiple Embedded fields
  25. Delete Not Working with JpaRepository
  26. Disabling contextual LOB creation as createClob() method threw error
  27. Deprecated createCriteria method in Hibernate 5
  28. Name attribute in @Entity and @Table
  29. org.dbunit.dataset.NoSuchTableException: Did not find table ‘xxx’ in schema ‘null’
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment