Hy!
I'm using Firebird 1.0.3.972 with Jaybird 1.0.0 or Jaybird 1.0.1
(depends on where)
There are multiple java clients, each connecting to two databases:
the "normal" database
and for the heck of it a "check" database

The functionality of the check database is to always have the same
content (except for some config content only in "normal") as the normal
database, and if by any chance the contents differ (checked loads of
times in code :) ) it alerts

In about 8 months of daily firebird dbserver usage I got this alert two
times from two different places (there are about 4 seperate places ~4-5
comps/place that use these systems (each system is seperate with own
fbserver and dbase))
At one of these alerts, I was unable to check it, because they replaced
among others, the datafiles.
Other I checked and the normal dbase was indeed missing two records (the
two records that were entered that day), whilst the check dbase had them.
The code that enters the data:
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}

there are no checks/keys/trigger etc on the table I want to insert in
So I just don't get it why it can insert into the check database and not
into the normal one....
I was just wondering:
could this be because of older jaybird?
or is it absolutely sure, that it's in my code?

Thanks!
Nagypapi