Hi Guys,

I am working on a application , where, when ever i create a CASE, I have to create a seperate database for that case in the backend.
I dynamically create database through the application for each and every CASE that is created. For example if i have created 10 cases through my application , it means i would have created ten databases in the backend.

I like to use hibernate in my application. I like to know whether is that possible for me to get connection to the database , based on the CASE that i am selecting from the CASE LIST. For example , if i select CASE1 from the case list , then i should get connection to the CASE1 database.

(Actually i went through the reference document , i hope i can achieve it by programatically using configure.setproperty("hibernate.connection.url","jdbc:mysql://gsche56:3306/CASE1" ) before creating the sessionfactory. The CASE1 here is the database of the selected case.

Is there anyother way to do this.Can some one please help me on this.

NOTE: I like to use connection pooling in my app for better performance.

thanks in advance

krishna

use a separate hibernate sessionfactory for each database.

Hi

Thanks for the reply.

The main problem i face in my application is, since i create the database dynamically through my application , i will not be knowing how many database i will be having in my application. So i will not be able to create sessionfactory configuration for every database before itself.

what i understood from your reply is, i should either create a new hibernate.cfg.xml file(with different name) or alter the same hibernate.cfg.xml file by appending the new sessionfactory configuration , when ever i create a new database through my application.

So in this way i will be able get connected to the database, that is created through my application, using this sessionfactory configurations.

Is this what you are trying to convey me.

with thanks

krishna

As far as I know, you can create new Configuration (responsible for creating your SessionFactory later) without having to create hibernate.cfg.xml file. Look at the api for org.hibernate.cfg.Configuration. There are a few methods that might be useful for you. Hibernate.cfg.xml is only one of the options. You can have more than one Configuration object, created dynamically as needed. This leads you straightforward to more than one SessionFactory.