I think there ae some bugs in some versions of the server (including that
one) that produce this error for no apparent reason. I think (but could be
wrong) that most of these problems are fixed in 1.0.2 and 1.5.

Meanwhile, usually closing the connection and getting a new one works.

These operations usually only succeed if there is exactly one connection to
the db, in my experience.

david jencks

On 2003.01.06 07:32:57 -0500 Uwe Jäger wrote:
> 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
>
>
>
> 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/
>
>
>
>
>