Hi,

> This is some test code:
> ...
> It always fails with:

> org.firebirdsql.jdbc.FBSQLException: Resource Exception. unsuccessful
> metadata update
> object TEST is in use
> ...
> Even when I just try to create the second table after having
> disconnected and reconnected the connection, I still get the same
> error. Any ideas how to make this work?

Works for me without any problems with Firebird 1.5.0.

Which version of the server do you use? There were some bugs in Firebird
1.0.x that might cause your test case to fail.

Roman