| Subject | Re: [firebird-support] Stored procedure on database start |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-12-08T01:50:40Z |
At 12:40 AM 8/12/2005 +0000, you wrote:
On Superserver, the database comes online when the first connection request
succeeds. It won't be offline again until every connection has detached.
On Classic, there no such thing as a "server running", with or without
connections. Each connection has its own instance of the server connected
to one or more databases.
Furthermore, executing a stored procedure (like any other SQL statement)
occurs as the result of a client request.
./heLen
>Is there a way to auto execute a stored procedure when the databaseDo you know what you mean by "database restarts"?
>starts up ? I'd like to increment a generator when the database restarts.
On Superserver, the database comes online when the first connection request
succeeds. It won't be offline again until every connection has detached.
On Classic, there no such thing as a "server running", with or without
connections. Each connection has its own instance of the server connected
to one or more databases.
Furthermore, executing a stored procedure (like any other SQL statement)
occurs as the result of a client request.
./heLen