Hi,

we use firebirdsql jdbc driver to create tables and add data and
constraints. In order to make this easier we decided to first create the
tables, then add the data and later add the constraints. While this
works fine with other databases with firebird we run into the following
exception when trying to add the constraints:

ALTER TABLE CodeCategory_T ADD CONSTRAINT f800 FOREIGN KEY
(OIDCompany) REFERENCES Company_T ON DELETE CASCADE


--- SQLException ---
org.firebirdsql.jdbc.FBSQLException: GDS Exception. unsuccessful
metadata update
object COMPANY_T is in use

at
org.firebirdsql.jdbc.FBConnection.checkEndTransaction(FBConnection.java:1008)
at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:483)

We are using firebird 1.0.0.796 and the latest jdbc driver from cvs.

Any ideas?

Kind regards
Uwe