Tag Archives: join

Hibernate Fetch Lazy Child Entities with HQL and Native SQL

In one-to-many or many-to-many relationship, we often configure Hibernate to lazily fetch the children collection for performance reasons by reducing the database join operation and the amount of the data been pulled and transmitted from database to application. The application, … Continue reading

Posted in Database, Java | Tagged , , , , , , , , | Leave a comment

SQL Join Review

Here I just re-post a nice SQL JOIN diagram from stackoverflow by Lasse V. Karlsen, and adding a few examples to further illustrated the joins. Examples: First let’s create two tables and insert some data. The tables now look like … Continue reading

Posted in Database | Tagged , | Leave a comment