Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Hello,

I need to dynamically get the datasource value for various envoirnments like test or production.

Following is my hibernate configuration properties -

hibernate.connection.username=user
hibernate.connection.password=pwd
hibernate.connection.datasource=jdbc/testDB
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.OracleDialect

connection.datasource has test database value - jdbc/testDB.

I need to change it to production value - pordDB, for ear deployment in production.

testDB & prodDB values are mapped in web.xml.

What i need to do to get <connection.datasource> value dynamically change according to the envoirnments.

What are the alternative solutions?

Thanks.

Amit.

For my money, the point of having the datasource defined via JNDI is so that the server can determine which datasource to use. So the JNDI mapping, rather than being defined in your application, is defined on the server, like in server.xml for Tomcat, via the Weblogic console, whatever.

In other words, the server you use for test will have the JNDI datasource mapped to the test database. The production server will have the JNDI datasource pointing at the production database. That way you don't have to change the configuration.

I suppose you could configure Hibernate programmatically, but... that just seems to defeat the purpose.

Another option would be to pass an option into your ant build script and set properties based on that, or just pass in the properties themselves.

Dave