I'm using hibernate inside JBoss with an Oracle datasource. Usually when I do JDBC queries against the datasource it uses the schema as defined in the -ds.xml. But with hibernate I have to add the hibernate.default_schema property in persistence.xml too:



I've got a set up where the schema changes a lot between environments and ususally I can change the -ds.xml in deploy/ and that's all that needs doing.

However with hibernate have to change the persistence.xml file inside the EAR too - I want to avoid have to change the EAR file if I can help it.

I was wondering if there was a way of making hibernate pick up the default schema from the datasource?