File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Change DB runtime

 
Krishnakumar Ramanathan
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a particular error that you are running across or are you not sure where to start on solving this problem?
 
Sagar Rohankar
Ranch Hand
Posts: 2905
1
Java Spring Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks like you are using Spring Framework, so better post this in Application Framework section.

Cant help you much cause I don't know Spring !
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic