Hi,

You could also the the Firebird server handle this by using a mirror. The
server will keep two copies of the database for you.

For extra backup you can put the mirror db file on a second hard drive in
the server. That helps if you have a drive failure. It also reduces the
chance that an error like you describe will occur because the data isn't
transmitted twice over the net.

Rick

----- Original Message -----
From: "Lester Caine" <lester@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Wednesday, January 07, 2004 3:04 AM
Subject: Re: [Firebird-Java] unprofessional question


> Gerevich Janos wrote:
>
> > try{...
> > int chk=st_check.executeUpdate(toinsert); //insert into check db, later
> > into normal db
> > if(st_normal.executeUpdate(toinsert)!=1) do all sorts of error messages
> > and such
> > ...}catch {error messages and such}
>
> My 'quick' reaction would be - how do you know that BOTH
> st_check and st_normal have been updated. From my
> experience, it is quite possible that just occasionally the
> 'normal flow' has been interrupted, so that only the first
> insert has completed - which is exactly what you are seeing.
>
> I suspect that the 'problem' is actually the fact that you
> ARE using two copies, and that scraping the 'check' would
> actually fix the problem.
>
> IF you need to know that records ARE missing, simply use a
> generator, and look for missing numbers. ( 'Deleted' records
> are simply retained and MARKED deleted ;) )
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/Firebird-Java/
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>