www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Database Event Hooks

Database Startup
Database Connections
Database Logins
Database Disconnections
Database Shutdown
SQL Statement Preparation
SQL Parse Tree
WebDAV Logins
Associating Auxiliary Data With A Connection

11.1. Database Startup

DB.DBA.DBEV_STARTUP()

If defined, this is called after the server initialization, including roll forward of transaction logs, compilation of stored procedures, etc..., but before starting to listen for clients. Hence this is guaranteed to run before any clients connect or any HTTP messages are serviced.

The procedure will run in its own transaction, which will be automatically committed upon return, regardless of run time errors. Result sets are not allowed and return values are discarded. All custom Virtuoso Server Extensions (VSEs) will be defined when calling this procedure.

Sample Startup Procedure Hook
create procedure DB.DBA.DBEV_STARTUP ()
{
  dbg_obj_print (' server started ');
}