db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: connection url not working
Date Sun, 13 Jul 2008 21:17:58 GMT
> if i try to move to a different location with the datafiles:
> jdbc:derby://localhost:1527/home/thirdshift/b1/JADE_DB

Simply changing the URL won't move the data; the data still
resides in the database at its original location.

To move the data, you could:
  - backup and restore the database
  - export the data from the old DB, then import it to the new one
  - write a program of your own to read the data out of the old
    DB and write it to the new DB

The database can be located at any location, and you can certainly
set up your program so that your users can choose a different
location than you have used.

However, once a location is chosen for the database, you'll
need to consistently use that same location in the connection URL
in order to successfully access that database.

So, make your connection URL configurable, but once your users
have selected a particular location, set the URL to point to
that location and use it from then on.



View raw message