| Subject | Re: [firebird-support] force disconnect and replace db in use |
|---|---|
| Author | Dalton Calford |
| Post date | 2018-10-01T19:10:48Z |
Different versions of firebird, give you different options.
Some versions you just give it a forced or timed shutdown command via the api or command line tools, others you can view the monitor tables and see what various connections are doing and you can delete connections as needed.
Some versions you just give it a forced or timed shutdown command via the api or command line tools, others you can view the monitor tables and see what various connections are doing and you can delete connections as needed.
You can even create triggers on connect/transaction start that check a table and if a flag is set, disconnects the client.
BUT, before anyone can give help and guidence, perhaps a bit more information as in, what is the version of firebird? what is the connection string you are using? what is the OS you are on in case an OS level call is required?
Best regards
Dalton
On Mon, 1 Oct 2018 at 14:51, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:On 1-10-2018 19:45, Issam Boughanmi amigoface@...
[firebird-support] wrote:
> is there any programming api to force firebird connections and pools to
> disconnect .
Firebird itself has no 'pools', connection pools are driver specific.
> i have a database that run on a shared web hosting in embedded mode .
>
> i want to be able to force disconnect in order to be able to replace the
> database programatically .
You can shutdown a database through the services API, but depending on
how you connect, you may need to force connections to close, which may
lead to dataloss as transactions in progress will be terminated.
Mark
--
Mark Rotteveel