How to implement Joins in Hibernate?

Question

We have an application wherein we want to keep separate database for each client. We want to achieve this using multi tenancy approach. A working example will be highly appreciated.

Answer 1

There are various ways to implement joins in hibernate.

Using associations such as one-to-one, one-to-many etc.
Using JOIN in the HQL query. There is another form “join fetch” to load associated data simultaneously, no lazy loading.
We can fire native sql query and use join keyword.