Hi,

I have two entities : List and ListGroup. The relationship is many-to-one. The List table contains list id and list name. ListGroup table contains listgroup id and listgroup name. There is one more table called ListToListGroup which contains listid and listgroup id. However, List table exists in one database and Listgroup and ListToListGroup tables exist in another database.

I would like to know how can I write mapping files for these entities? When I retrieve the List entity I would like to get the details of list group to which it belongs.

I am using Hibernate version:3.2

Name and version of the database:Oracle 10 g

Thanks
Kamesh