Dear All;

I am newbie user for hibernate. I want to make sample mrp projects with Java,Hibernate and GWT. My projects runing with multiple database. I have a master database. The role of Master database is holding with common data (User,Authentication and other database config[server,dbname]).Other database creates by users and uses. The structure of other databases is same.

1- I want to make join query and mapping between master database and other database.
For example

SELECT * FROM master.locale ml INNER JOIN userdatabase.address ua (ml.country=ua.country);

2- I want to change dynamically the name of catalog in runtime
For example

Step-1 : User login to application.
Step-2 : User going to select a database to work.
Step-3 : Catalog name of my mapping is going to change according to selected database in runtime.

Best regards