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

Hibernate version: 3.1.3

Is it possible to change the connection.url at runtime?

I've got sixteen databases spread across two servers. Depending on parms passed into my application, I will need to change the connection.url and the database name at runtime.

Is there any way to do this in Hibernate? I looked in the API docs for Session, but don't see any way to set these at runtime.

Thanks,
Curt

We use the Spring Framework in conjunction with Hibernate to do something similar. You can configure the different data sources in the Spring Application Context and then choose which one based on your application's needs.

two options:

if you don't use 2nd level cache, use a custom ConnectionProvider that knows how to choose amongst them.

if you use 2nd level cache, change the connection parameters on the Configuration object and build another sessionfactory.

Max, changing the connection properties on the Configuration object was the perfect solution.

Thanks!

Curt