Friday, August 29, 2014

Researching Hibernate for Queries

How to perform unions and/or one-to-one joins with multiple intermediate tables? Looks like there are no easy solutions. Best may be using SQL or creating numerous hibernate mappings for a legacy database.

Read:
http://hibernate-samples.blogspot.com/2011/10/one-to-one-association-using-join-table.html
 https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Web_Server/1.0/html/Hibernate_Core_Reference_Guide/assoc-bidirectional-join-121.html
 example of multiple intermediate join tables?
 named query: http://stackoverflow.com/questions/8399379/hibernate-named-query-join-3-tables
 with sql: http://jumpingbean.co.za/blogs/mark/hibernate
 http://stackoverflow.com/questions/18257757/how-to-execute-query-with-union-in-hibernate