Want to Construct session Factory using Datasource

kks_krishna · **Joined:** Thu Jan 05, 2006 1:33 am **Posts:** 6

HI,

I have a requirement to create hibernate session factory dynamically using the datasource. That means my database will be dynamically created, so we can't declare the datasource in mysql-ds.xml in the JBoss server. When system is trying to create the hibernate session factory we have to set the datasource dynamicaly and use it to create the session factory.

If anyone have idea on this, Please help me.

nagkumar · **Posted:** Mon May 26, 2008 11:44 pm

this code may be of help in this context..

Configuration lConf = new AnnotationConfiguration();
lConf.configure("/resources/hibernate.common.cfg.xml");
lConf.configure(
ConfigHelper.locateConfig("resources/hibernate.cfg.xml"));
sessionFactory = lConf.buildSessionFactory();

Basically look at Configurtion api of hibernate.. and its different impl..

Regards,
Nagendra

kks_krishna · **Joined:** Thu Jan 05, 2006 1:33 am **Posts:** 6

Your answer for creating simple hibernate session factory. But my requirement is to manipulate the datasource itself.

nagkumar · **Posted:** Tue May 27, 2008 3:29 am

Configuration interface has a way to manipulate its properties though methods such as mergeProperties(Properties properties)
and setProperty(String propertyName, String value)..

These methods should enable the overide of data source or any property which u may wish to change at run time

kks_krishna · **Joined:** Thu Jan 05, 2006 1:33 am **Posts:** 6

I understand that. But even if you override the datasource property, datasource is deployed in JBoss server only. how can I dynamicaly set the database name to datasource.

nagkumar · **Posted:** Tue May 27, 2008 4:38 am

Sorry.. krishna.. unable to understand your need further... in case you are blr.. you could call me.. so that we could discuss further..

My mobile : +91-9886723872.