posted 15 years ago
Hi all,
this is my code in applicationcontext.xml and its working fine, my doubt is how to change the DB at run time, In our application we have 4 -5 Databases and user is allowed to change the Db once he/she login
<bean id="placeholderConfigurer"
class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="location" value="classpath:ryanco.properties"/>
<property name="ignoreUnresolvablePlaceholders" value="true"></property>
</bean>
<!-- ========================= DataSource ========================= -->
<!-- DataSource Definition -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName">
<value>${db.driverClassName}</value>
</property>
<property name="url">
<value>${db.1.url}</value>
</property>
<property name="username">
<value>${db.1.username}</value>
</property>
<property name="password">
<value>${db.1.password}</value>
</property>
</bean>
this is the code in properties file
db.1.name=Database3
db.1.password=test
db.1.username=test
db.1.driverClassName=oracle.jdbc.driver.OracleDriver
db.1.url=jdbc\ Oracle\:thin\:@10.10.4.3\:1521\ Database3
thanks in advance
[ October 02, 2008: Message edited by: Krishnakumar Ramanathan ]