Hi !
I am using Jboss 3.2.1 with Postgres 7.3.2. I have my application up and running using the postgres database DB_1 as the datasource. I have specified this datasource in the postgres-ds.xml file :
<connection-url>jdbc:postgresql://DB_1</connection-url>
How do I reload a new database, say DB_2, and get my application to switch from using datasource DB_1 to the new datasource DB_2 on the fly (i.e. without having to manually restart the application)? Once I switch to the new datasource DB_2, I do not need to "see" the old datasource DB_1.
Thanks in advance. Any help would be appreciated.
Iff db_2 has all data from db_1, then just replace db_1 in your postgres-ds.xml.
Unfortunately, I am not 100% sure if this goes without restarting your app afterwards.