I have a 1.0.2 server running on linux that produces the same result/error.

I will try to close the connection.

Kind regards
Uwe

David Jencks wrote:

> 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/
>>
>>
>>
>>
>>
>
>
>
> 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/
>