db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Unable to restore a Derby database [SOLVED?]
Date Wed, 24 Nov 2004 16:21:03 GMT
Hash: SHA1

I also think you should file a JIRA entry.  I would have at least
expected some message in the derby.log.  A discussion would be good
as I don't know what users want in this case.  Should the connection
~    a) fail with a reasonable message back to user
~    b) succeed but with a warning that the restore did not work back to
~    c) succeed but with an error in derby.log
~    d) fail but with an error in derby.log
~    e) succeed with no message
a or b seems reasonable, c or d may be easiest to implement, e seems

The actual code to execute the restore from backup happens in derby at
"boot" time.  And historically it has been hard to get good error
messages back to user when boot fails at such a low level, I am not
sure what happened in this particular case as I did not debug it.

Amit Handa wrote:
| Calvin Smith wrote:
|>Oh man, do I feel stupid. I just re-read the manual again and realized
|>that the restore from path is not the directory into which the backup
|>occurred, but the sub-directory that the backup created in that directory.
|>I was doing:
|>connect 'jdbc:derby:myDb;restoreFrom=/mybackupdir';
|>instead of:
|>connect 'jdbc:derby:myDb;restoreFrom=/mybackupdir/myDb';
|>After trying the second form, it works perfectly. Perhaps a better
|>message (indicating success or failure, instead of silence in both
|>cases) would be helpful, but this was a case of PEBCAK
|>Thanks again, and I apologize for wasting anybody's time on a silly
|>p.s. If anybody thinks that the silent response when the backup
|>directory (which contains the backup database directory) exists but the
|>backup database directory doesn't exist is a bug, I'll be happy to file
|>a Jira issue. This is inconsistent with the behavior when the backup
|>database directory does exist but isn't valid, and the user is notified
|>of an error.
| Calvin,
| I think it would be good to file a bug and have a discussion around it,
| since you started the thread.
| We can always close it later, if we[derby-users] feel otherwise.
| thanks,
| Amit
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org


View raw message