We're using Hibernate 3.2.5 in JBoss 4.0.2. In development we use PostgreSQL, but in production we're goin to use DB2. Hibernate is initialized through the Hibernate jmx bean (in a .sar file included in the application).

As the dialect depends on the target environment (postgreSQL or DB2), I'd like to keep this condiguration outside of the application (.ear file) as I would like to use the same archive for all environments. As of now I configure the dialect in the jboss-service.xml, which is part of the application (as the .sar file is part of the application).

How could I solve this?

After some investigation (browsing the code) it looks like it would be possible to leave some configuration out of the jboss-service.xml and define it in hibernate.properties instead.
My thinking is that it would be possible to keep the hibernate.properties file outside of the application and thereby keeping some config outside of the application.

I've tried to put the hibernate.properties in [jboss_root]\server\default\lib, but it isn't being picked up. According to the code, Hibernate tries to read /hibernate.properties and I though that the lib folder was in the class path.
Any ideas?

Solved it by putting the hibernate.properties file in [jboss_root]\server\default\conf .