I am currently working with a customer who wants to have multiple setts of same tables in different schemas and to be able to pass the schema name to the mapping files through some configuration or properties file. Does Hibernate support this kind of functionality?

There is an "hibernate.default_schema" option that can be set in either hibernate.properties or hibernate.cfg.xml. I have never used so I can't say if it works in your case or not. For more info see: http://www.hibernate.org/hib_docs/v3/re ... ional.html

Hi nordborg,
Thank you very much for your suggestion.
I have not tried it yet, but it looks very logical and applicable to my case.
I will try it shortly and will update this thread with the results.

Tested the solution and it works fine.
Thanks again.

Can you tell in details how you did it? I have similar situation. Multiple schema (diff environments) that have same tables but I somehow I want to pass the schema as an argument in command-line.

Or if that cant work then I can go with the properties file, as last option but even that I do not know. Thanks for replying! :)