Hi, i have the following to implement:

A web app used to store projects.
Individual projects are store in separate database (requirement i cant change)
Projects are created by users registered to the system. (ie, databases that exists will not be known beforehand)
Users have many-one association with projects.
The only database known beforehand (lets call it database A), is used to store the databases created and the users associated.

I am not sure how i should implement the connection to the database, as most documentations/articales i read had the database connection configured on xml/properties files. (which is not possible in my case) Basically, i think i have to connect to database A when the application starts (which is easy since database A can have settings in the config files) and the application will connect to another database depending on the user who logged in.

Any comments appreciated. Thanks.

-Jo

Look at the Configuration object API, you can configure all this dynamically.

Thks, so i simply set the connections setting using the .setProperty(propertyName,value) method? and then use the configuration object to create a new SessionFactory using the buildSessionFactory()?