Subject | Re: [Firebird-Java] Re: Unsuccessful metadata update - Solution |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-11-16T14:08:54Z |
> I read both topic you've mentioned and FAQ. The problem of myExclusive connection is an exclusive connection. :) You have to either
> 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)?
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