Dear Experts,

We are developing ‘Issue Tracking’ product by using Hibernate. We have to handle multiple schema in our product. For example we have two schemas in our Database that are ‘Major’ and ‘Minor’. If the user age is below 18 then the corresponding user details should be stored in ‘Minor’ Schema, else in ‘Major’ Schema. To achieve this we have to change ‘Hibernate mapping file’ in run time.
Can any one help me?
And give some sample code for this.

Advance Thanks.

Why do you need to modify the mapping file at runtime? Isn't all you need to create two session factories (or EntityManagerFactories if you use JPA) one for each database and then just use the correct factory to get your session object from based on the age of your user.

We are going to use single database with multiple schemas, that is our requirement. So can you tell me, is it possible to change the schema value at runtime? if so, can you explain me?