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:

<persistence-unit name="jpaPersistence">
 <jta-data-source>java:/MainDS</jta-data-source>
...
 <properties>
 <property name="hibernate.default_schema" value="guy" />
...

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?