Hi all,

I'm trying to create two different database schemas from one entity jar-file. The point is that I need one DB for the actual data and exactly identical DB for backup purposes etc. My operative DB works just fine and all tables are created, but the problem is that my backup DB remains empty without any errors from Hibernate. I get no tables, no errors, no warnings and nothing seems to be wrong in log-files either. The other DB just remains empty.

Log-file is identical with both of these persistence-units. Hibernate tells me that this-n-that table not found in database etc and it leads to table creation in my operative database, like it should be. Nothing, absolutely nothing, happens to my backup persistence-unit.

I have JBoss 4.0.5.GA and Hibernate 3.2.1.GA. Both databases are empty and listed in deploy/postgres-ds.xml and they do exist before JBoss launch. My app is packed inside an EAR and my EJB-module has this persistence.xml listed below.

My persistence.xml:
<persistence-unit name="my-operative-db">
<jta-data-source>java:/my-operative-db</jta-data-source>
<jar-file>../entity-data.jar</jar-file>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.max_fetch_depth" value="0" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
<property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.CMTTransactionFactory" />
</properties>
</persistence-unit>
<persistence-unit name="my-backup-db">
<jta-data-source>java:/my-backup-db</jta-data-source>
<jar-file>../entity-data.jar</jar-file>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.max_fetch_depth" value="0" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
<property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.CMTTransactionFactory" />
</properties>
</persistence-unit>

Does any one have similar problems? Am I missing something or is there something wrong in Hibernate? Some one please try this out and post your comments.

Thanks for advance,
Ville

It might be a bug in JBoss EJB 3.0, ignoring subsequent PU loads, try to post on the JBoss EJB3 forum and open a JIRA issue

Thanks for your reply Emmanuel, I'll post this issue to the JBoss forum and JIRA as you suggested. Lets see if it helps.

Hi again,

Unfortunately this issue is still open. Has any of you Hibernate users experienced similar problems? Some solution suggestions perhaps...

This problem is also discussed in JBoss forums, but no luck yet.
JBoss forum topic can be found here.

Regards,
Ville Ingman