Subject How to log everyone out of FB automatically?
Author phil_hhn
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