Hello,
we have an EJB application using two different Oracle Databases.
We set the default schema of each persistence context in the persistence.xml (residing within the EAR-file):
Code:
<persistence-unit name="PersistenceUnitDefault">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
...
<properties>
<property name="hibernate.default_schema" value="data1"/>
...
<persistence-unit name="PersistenceUnitStock">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
...
<properties>
<property name="hibernate.default_schema" value="prod1"/>
...
The application is used by serveral customers, each using their own databases / schema assignment. Since the persistence.xml is contained within the EAR, we have to provide a specific EAR file for each installation.
How can we define the default schema for each persistence context outside of the EAR, e. g. in the datastore definition file?
Hibernate version 3.2.4.sp1
JBoss 4.2.3.GA
Oracle 10g Database
Thank you,
Raimund