Hi there,
i was searching the website/ forum/mailarchive and the api docs as well for a long time but still do not know how to set the SchemaName dynamically via API.

I have a oracle db and my tables are distributed over a set of schemas.
The schema attribute in my *.hbm.xml file is working well for oracle.

My problem is that since i make TTD i use HSQLDB for my development environment and HSQLDB does not support schema names. (So far i know).

The idea is to set schema name until i use oracel at production time and do not use any schema name until development time.
Since i do not use xdoclet is there a possibility to set/ remove the schema name via API?
In worst case i can create my *hbm.xml dynamically but i'm searching for a smarter solutopn.
Thanks for any hints.

Stefan

I was also looking to answer this question, and found this yesterday: http://forum.hibernate.org/viewtopic.ph ... nge+schema

You can make a hibernate.cfg.xml for Oracle, and one for HSQLDB, and flip between them as necessary. In the config file that points to Oracle, put
and pull out all the references to schema name in your mapping xml files.

This will work if all the tables you want to hit are in the same schema. Otherwise, there is an API to call during runtime, but I didn't try that.