Data fetch from multiple SQL tables

[mallika arora]

I am in the process of writing my first hibernate application. I have a sql query that fetches data from multiple tables using left and right outer joins. I need to convert this JDBC data access code into Hibernate code. The tables in SQL are not related using foreign keys.

I have created hibernate mapping for each table, datasource configuration xml and POJO for each table. I am unable to follow how to use HQL createQuery that would use table classes to retrieve data from 8 or 9 tables.

Any example of HQL fetching data from multiple tables would be a help.

Please advice.

Thanks,
Mallika

[Mark Spritzler]

From the Hibernate documentation pages

Joins
http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-joins


Describing implicit versus explicit joins
http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-joins-forms

Where clauses
http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-where

Examples
http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-examples

Mark