Programmatically configure Hibernate with dynamic username and password

Question

I am implementing a web application where the user needs to authenticate with his database username and password. I woudld like to use the same entered username and password to connect to the database.

In other words, i would like that these two fields:(dbusername and dbpassword) in the hibernate configuration file:

<property name="hibernate.connection.username">dbusername</property>
<property name="hibernate.connection.password">dbpassword</property>

can be filled dynimacally dependant on the user who enterd his username and password to log in the web application.

is this do-able?

thanks

harrybvp · Accepted Answer · 2013-08-03 13:51:51Z

10

Here is how you can acheive

Configuration cfg = new Configuration();
cfg.configure("hibernate.cfg.xml"); //hibernate config xml file name
String newUserName,newPassword;//set them as per your needs
cfg.getProperties().setProperty("hibernate.connection.password",newPassword);
cfg.getProperties().setProperty("hibernate.connection.username",newUserName);
sessionFactory = cfg.buildSessionFactory();

answered Aug 3, 2013 at 13:51

harrybvp

2,5032 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohammed R. El-Khoudary Over a year ago

This wouldn't solve the problem, the requirement is to change that per user.. are you planning to build a factory each time you request a connection?!

Aleksandr M · Accepted Answer · 2013-08-03 20:49:49Z

-1

Yes, you can set all the hibernate properties dynamically, using

Configuration configuration = new Configuration();
configuration.configure("hibernate_sp.cfg.xml");
ServiceRegistryBuilder serviceRegistryBuilder = new ServiceRegistryBuilder().applySettings(configuration
                            .getProperties());
SessionFactory sessionFactory = configuration
                            .buildSessionFactory(serviceRegistryBuilder.buildServiceRegistry());
Session session = sessionFactory.openSession();
logger.info("Test connection with the database created successfuly.");

set properties using configuration object.

edited Aug 3, 2013 at 20:49

Aleksandr M

24.4k13 gold badges75 silver badges148 bronze badges

answered Aug 3, 2013 at 13:35

thegeek

2422 silver badges8 bronze badges

Collectives™ on Stack Overflow

Programmatically configure Hibernate with dynamic username and password

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related