Matthew,

>
> To give a little more info on my problems: I am using firebird in a
> Java application deployed to users on Windows XP. There are different
> scenarios under which I need to programmatically restore a database
> backup (I'm using gbak for this). In one place where the application
> does this, I can consistently reproduce inaccurate results from
> queries afterwards if I do not restart my application after the
> restore before the queries. Inserts actually insert but gets seem to
> be using data ignoring the inserts that occurred after the restore, at
> least for the first insert/get pair. I am guessing that I am getting
> values cached from the old pre-restore database for the gets.

What you're doing is unsafe. You're replacing a data file under
a running application. Don't do it. Shutdown your clients before
you begin the backup and restart them after the restore completes.
Otherwise, you'll lose any work they do between the two events.


Good luck,


Ann