Need to login to Hibernate with Database Username & Password dynamically

Try this:

// Get the application context. Alternatively you could implement the ApplicationContextAware interface @Autowired private ApplicationContext applicationContext; public void setPassword(String myDynamicallyCalculatedPassword){ BasicDataSource dataSourceShrms = applicationContext.getBean("dataSourceShrms"); dataSourceShrms.setPassword(myDynamicallyCalculatedPassword); } 

Note: According to the documentation the set password method:

This method currently has no effect once the pool has been initialized. The pool is initialized the first time one of the following methods is invoked: getConnection, setLogwriter, setLoginTimeout, getLoginTimeout, getLogWriter.

So make sure you do not create a connection first. If you cannot do it you could try to create the connection programatically.

Imagine that you have your database url, driverClassname, username and password in variables with the same name. On your case those variables would be filled from the input page or wherever the user itroduces that data.

And you have a class MyClass class configured with Hibernate annotations on the package com.myapplication.POJO

So, you just create Configuration object and query the database:

Configuration configuration = new Configuration().configure() .setProperty("hibernate.dialect", "org.hibernate.dialect.Oracle8iDialect") .setProperty("hibernate.connection.driver_class", driverClassname) .setProperty("hibernate.connection.url", url) .setProperty("hibernate.connection.username", username) .setProperty("hibernate.connection.password", password) //In next line you just tell Hibernate which classes are you going to query configuration = configuration.addPackage("com.myapplication.POJO"). addAnnotatedClass(MyCustomClass.class); StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); SessionFactory factory = configuration.buildSessionFactory(ssrb.build()); //We open session with database Session session = factory.openSession(); List<MyCustomClass> result = null; try { //Here we get the list of MyCustomClass objects from database result = session.createQuery("FROM MyCustomClass").list(); } catch (Exception e) { e.printStackTrace(); } finally { session.close(); } 

IMPORTANT: I think Oracle8iDialect is the most common for Oracle DB. If you are using Oracle 10g or Oracle 9i you should use org.hibernate.dialect.Oracle10gDialect or org.hibernate.dialect.Oracle9iDialect. Complete reference here: http://docs.jboss.org/hibernate/orm/3.5/javadocs/org/hibernate/dialect/package-summary.html

You can define the Hibernate property as below,

Refer: http://www.mkyong.com/spring/maven-spring-hibernate-mysql-example/

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource"> <ref bean="dataSource"/> </property> <property name="hibernateProperties"> <props> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> 

You can use dynamic values in your applicationContext.xml. For example you can read values from a external properties file pointed by a Environmental variable that conaints a path to a file:

<context:property-placeholder location="file:${my_environmental_variable_name}/project.properties" /> 

Asuming that your properties file contains:

hibernate.connection.url=jdbc:mysql://localhost:3306/yourapplication hibernate.connection.username=username hibernate.connection.password=yourpassword 

You can use them in yout applicationcontext.xml this way:

<bean id="dataSourceShrms" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="oracle.jdbc.OracleDriver" /> <property name="url" value="${hibernate.connection.url}" /> <property name="username" value="${hibernate.connection.username}" /> <property name="password" value="${hibernate.connection.password}" /> </bean> 

So you can run your application defining each time a different value for your 'my_environmental_variable_name' environmental variable pointing to different properties configuration file.