Hello all,

We are considering using Hibernate in one of our projects.
According to customer's requirements we need to connect to the DB (oracle) using the DB users, which means that we need to dynamically set the username / password for connecting to the DB at runtime.

(The users of the application should connect to the application with their DB users and the application will use this username to connect to the DB)

Has anybody done it in hibernate ? is it possible ?

Try something like this.

Configuration config = new Configuration();
config.setProperty("hibernate.connection.url", init.getDatabaseUrl());
config.setProperty("hibernate.connection.username", init.getDatabaseUser());
config.setProperty("hibernate.connection.password", init.getDatabasePass());
config.configure();
sessionFactory = config.buildSessionFactory();

Thanks prateek.singh !
This helps a lot !