Subject Re: [Firebird-Java] Re: Unsuccessful metadata update - Solution
Author Roman Rokytskyy
> I read both topic you've mentioned and FAQ. The problem of my
> example do was consisted in the IBConsole opened to the same server.
> But the point is that I want to use driver's connection pooling
> future. So I can't provide the exclusive connection in a real
> application.
>
> Is there some workaround for this case (connection pooling and
> foreign key making/changing at the same time)?

Exclusive connection is an exclusive connection. :) You have to either
shutdown the pool (there's a corresponding method) or you have to shutdown
the database by using gfix -shut -force, and be sure that pool does not use
SYSDBA account. Then you can connect as SYSDBA, do you metadata change, and
use gfix -online to bring the database back.

Roman