Hi
We have a need to be able to change the owner (schema) of our underlying tables in the .xml mapping files without having to recompile our applications. To clarify consider the below:



In the test region of our system we have a development region, a QA region and a region that mirrors prod. These are differentiated by schema name. We need to be able to swap regions based on a config value or the like and not have to hardcode the owner name. Nobody is going to sign off on an app that needs to be recompiled to swap regions - too much risk involved and testing in production is out. Is there an easy way to set the schema value at runtime?

Thanks,
Robin

Set the hibernate.default_schema in your configuration file and don't specify the schema in the mapping files.

Then it should be just a config file change.

BOb

Most awesome.

Thanks