|Never mind. I got the answer to my query on reading this excellent article : |
The answer is that the desired database location needs to be specified in the database connection string.
As an aside, I would like to add that there is a dearth of good articles on Derby. It is just a candid opinion, and I don't intend to offend anyone, particularly those who are involved with this project.
--- On Sat, 24/4/10, Dinesh Bajaj <email@example.com> wrote:
From: Dinesh Bajaj <firstname.lastname@example.org>
Subject: Database restoration not working.
Date: Saturday, 24 April, 2010, 8:07
My understanding is that restoring a backedup database should restore it to to its original location. If for example, a database is backedup from the location c:\one to c:\two, and if it is later restored, then the database ought to be restored to the original location, i.e. c:\one. However, I find that this is not the case with Derby.
String connectionURL = "jdbc:derby:mydbname;restoreFrom=c:/temp/two/mydbname"
On using the above-mentioned connection string, the connection to the database is indeed made; however, it is not restored to its original location. Where the database is restored, and how I can get it restored to its original location?
Thanks in advance.