Hibernate version:3.2.0.cr4
Hibernate Tools version:3.2.0.GA
Database: Oracle 10

We're reverse engineering pojos and the hibernate.cfg.xml file. We also have separate database 'regions'. i.e. we'll have a CLIENT_DEV schema and CLIENT_PROD schema.

For that reason, we specifically don't set hibernate.default_schema - that way we can use the same persistence layer throughout the regions.

However, without hibernate.default_schema set, this type of class definition for the table in the reveng.xml file seems to have no effect:



What I mean is the tools generate a Usr.java file instead of the desired User.java file. Again, setting default_schema allows the code generation to happen as expected.

Any assistance in clearing up my confusion would be appreciated.

Thanks
M

yes it has no effect because the table name is now not unique, it would need a schema name.

You can just set hibernate.default_schema only when you do the reverse engineering it does not need to be set when running hibernate runtime.

Thanks Max - That makes perfect sense...

But now I don't see any way to generate the hibernate.cfg.xml file with the proper class name:



(instead of Usr)

Without also generating:



Which makes my persistence layer schema specific.

Am I missing something - or just asking too much :)
Thanks again.
M

chicken and egg ,)

well you could generate the hbm.xml's first with the schema set and then do a second run to generate the cfg.xml by including the *.hbm.xml's by **/*.hbm.xml

Thanks again -

But I'm not quite tracking with you - how do you create a cfg.xml from the hbm.xml set?

M

from the docs 4.3.1.1:

Thanks! Shoulda spotted that in the docs. Worked like a charm!

M