Hibernate version:
2.1.8

Mapping documents:
(do you mean post them here? it's not letting me do that for some reason, and it's too long to type the whole thing in...)

this is the relevant portion though...
<hibernate-mapping schema="myschema">
...

Code between sessionFactory.openSession() and session.close():
n/a

Full stack trace of any exception that occurs:
n/a

Name and version of the database you are using:
n/a

The generated SQL (show_sql=true):
n/a

Debug level Hibernate log excerpt:
n/a

Problem Description

I would like to deploy a jar that contains my services layer, including the hibernate orm portion of my services. However, the jar would be deployed to different environments where the tables would be in not just different databases, but in different schemas. The table structure is identical, but the schema name is different. I have looked and talked to people, and don't see a way to do it. That means I need a completely "new" xml mapping file for each environment that differs only by the schema name defined there. Am I totally wrong? Thanks in advance for any help/explanations you can provide.

programatically set hibernate.default_schema or mainpulate your DOM tree programatically before adding it to the configuration object.