Two Table Connection and Fetch

edward_durai · **Joined:** Tue Jun 06, 2006 7:56 am **Posts:** 20

How to Connect two tables. And Fetch the particular records using Hiberante Classes.

Pls explain using Examples

Thanks
A.Edward Durai

ramnath · **Posted:** Tue Jun 06, 2006 8:21 am

Hi,

You can use Restriction in Criteria API. Please go through the below link

http://www.hibernate.org/hib_docs/v3/re ... rycriteria

or an HQL as below

from Cat cat, Cat rival where cat.mate = rival.mate

damnhandy · **Posted:** Tue Jun 06, 2006 8:27 am

Edward,

Could be be a bit more specific with your question? Are you looking to map a single class against two or more tables, or would you like to issue a query which joins two or more classes?

Ryan-