Hello

If I understand you well, you try this SQL command inmediately after
database restart and before any other DDL command, and with CARD_QUERY table
created before the restart, and you got the same error.


Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "Rashid Motala" <rashidm@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, September 27, 2002 11:58 AM
Subject: [Firebird-Java] Jaybird 'object in use' error adding ref integrity
constraint


Thank you for your prompt reply Blas.

While the bug you describe may be a bug in FB/IB, it does not fully
explain this scenario. The script in question fails to run using Jaybird
- forever. You can shutdown the app after it fails, shutdown Interbase,
restart everything, and let the app start with this particular script -
it will fail, it always fails.

Regards,
Rashid.

> ؟Do you create the table CARD_QUERY in the previous SQL statement?

> It seems this is an old error in IB (some years old). If you create a
> table, and inmediately try to create a table that references to the
first
> one, sometimes depending on the database status this error is
returned.

> Recently I read a mail in the firebird-devel list about this bug,
> finally someone found the problem (Nicolay Samofatov 14 Sept). Perhaps
in
> the near future the problem can be solved.

> Regards
> Blas Rodriguez Somoza



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/