I have 2 tables namely Person and Dept with many to many relationship between them. Then its obvious that I have refer each table from others mapping file. e.g. I have to refer Person table from Dept.hbm.xml and vice a versa.

Now my these two table lie on different database. For this purpose I have v created 2 hibernate.cfg.xml. One having person.hbm.xml and second having dept.hbm.xml. When I try to create a session factory by configuring , the cfg file with person.hbm.xml inside it.
It gives me org.hibernate.MappingException: An association from the table Person refers to an unmapped class: com.db.objectmodel.Dept

Does hibernate supports such scenario where object graph is spread across databases? I have looked into hibernate shards but does not support as it meant for solving horizontal partitioning.

Thanks in advance,

When mapping a <class> you can try setting the 'catalog' and/or 'schema' attributes. All mapping files must go into the same Configuration and SessionFactory.

Something like