Good afternoon,

I have an application with a login page that allows you to select the DB you wish to connect to via a drop-down list.

What is the best way to accomplish this without imposing a fair amount of overhead for the other db providers that are not actually used during the lifecycle of the application (one and only one of the DB is ever actually used since it can only be selected at login)

Thanks in advance.

Whatty

I guess you could have a separate SessionFactory for each. Then only the database chosen ever has the SessionFactory for that db instantiated?

I know this may seem like a very basic question and I apologize in advance, but I am fairly new to Hibernate and I haven't had much luck in finding out exactly how to do what you are proposing.

I am using Hibernate with Spring (also new to that) and I am not 100% sure how to control the instantiation of the SessionFactory, or do I instantiate both and dynamically select the session factory in my DAO object.

I am digging through the Spring documentation at the moment to dynamically parse a config file based upon the initial selection but thought I would ask anyway.

Thanks in advance.

Whatty