JDBC Username and Password

MikeOliverAZ · **Posted:** Tue Feb 16, 2010 8:04 pm

I have a situation where the JDBC connection isn't a static set of username and password, but that the actual user making the request is used to make the connection.

Is it possible to pass the JDBC Connection Username and Password to Hibernate at runtime in the context or some other way?

nordborg · **Posted:** Wed Feb 17, 2010 3:08 am

This is set at configuration time, so once you have started your application and built the session factory it can't be changed. You can set this programmatically on the configuration. We are doing something like this:

Code:

Configuration cfg = new Conficguration();
cfg.setProperty("hibernate.connection.url", dbUrl);
cfg.setProperty("hibernate.connection.username", username);
cfg.setProperty("hibernate.connection.password", password);
// .. and a lot of other things....
cfg.configure();
SessionFactory sf = cfg.buildSessionFactory();