In our application we want have schema on DataBase which depends upon the user logging in (user chooses)...

How can Hibernate at runtime be directed to choose different Data Source..I am using hibernate.cfg.xml for configuration !!

Thanks
Andy

Have a SessionFactory for each Database Schema. And based on the runtime condition (login in your case), you can decide on which SessionFactory to use to get your session.

If you are using the HibernateSession utility class with one session per thread one static sessionfactory, you can have one sessionfactory for schema and getSession can check the login condition.

There could be some better ways of doing this and maybe some sample utility classes somewhere...
[/quote]

well.. some typos here.. i was referring to the HibernateUtil class in http://www.hibernate.org/42.html when I meant HibernateSession utility class. and read it as one static SessionFactory per schema, one threadlocal session and threadlocal transaction per schema and let the getSession() method return the Session based on the runtime condition.

Hope this helps.