How to set "hibernate.properties" environment specific

[ug4jee]

Hi All,

Greetings,

I would like to know steps for,

How to configure the "hibernate.properties" specific to environment(dev/stage/prod).

we are using .properties file for DB connection utility with below props.

hibernate.dialect = org.hibernate.dialect.OracleDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@host:port_no:dsn
hibernate.connection.username=username
hibernate.connection.password=password
hibernate.jdbc.batch_size=0

we are not using hibernate-cfg.xml for DB connection,

I need to put this for specific to the environment, as of now we are using the "hibernate.properties" for every environment, we used to change the db connection everytime whenever we want to deploy to dev/stage/prod envs which is causing issue with other developers, if they are not aware of usage of this process.

Iam using Tomcat server and deploying the war file in to it.

Please let me know your ideas on this.

Thanks,

[ug4jee]

Any help is appreciated...!!!

[ug4jee]

if it is not the correct place to put this question please let me point to the correct place...

[ug4jee]

Today when i was googling found a link http://galaxy.andromda.org/forum/vie...f9ecbc4fa95e64 which has some info on it. I was trying with this it could resolve the issue.

i.e. Adding the properties to CATALINA_OPTS and export like below..
-Dhibernate.dialect=org.hibernate.dialect.HSQLDialect

[ug4jee]

The above mentioned process is working like chome....