--- In firebird-support@yahoogroups.com, "phil_hhn" <time_lord@...> wrote:

>
> Hi,
> I'm trying to do a metadata update on the database in an overnight
> server task. The problem is there maybe one or more client machines
> (or web server) still connected to the database, so we get the error
> "unsuccessful metadata update.... object is in use".
> I already handle this if running a gui (tell the user to stop other
> PCs and services). But I want to automate this (both for the gui
> and/or for the overnight server task). Can I somehow tell FB to drop
> all connections except the one I'm on?
>
> We are using FB 1.5.2/1.5.3 Superserver on Windows, 1.5.2(?) Classic
> on the Mac. We are running Java and using the 1.5 Jaybird JDBC driver.
> We cannot go to FB 2.0 yet (we have many customers), but CAN update to
> the 2.1 Jaybird driver automatically and easily.
>
> So given these setups, can I somehow tell FB to drop all connections
> except the one I'm on? (And will the Jaybird 2.1 driver help here?)
>
> Thanks in advance,
> Phil
>

Using gfix you can put the database into shutdown state. This will
prevent connections from anyone other than SYSDBA and the database owner.

Adam