1 Reply Latest reply on Feb 14, 2004 5:14 AM by Heiko Rupp

    Reload new postgres datasource

    rn2004 Newbie

      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.