Does the schema name have to be changed in each of the mapping files? Is there any option to use the JDBC connection url, e.g. naming=system;libraries=lib1,lib2 ??

This would make it easier since one could simply change the hibernate config file, as opposed to rerunning the gen tool, or manually changing each of the mapping files.

I'm not sure I understand what you are trying to accomplish, but you can remove all schema attributes from mapping files, and just specify default_schema in your hibernate properties file. Then you only have to change the schema in one place and it will affect all the mappings/tables.

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional

Yeah, thats what I'm trying to accomplish, but the problem is i can only put one library in the default_schema attribute. Not like the JDBC libraries attribute appended on the connection URL. help in most cases because all files that need to be mapped are usually located in one library. Thanks