begin_connection connection event

Invoked at the time the MobiLink server connects to the consolidated database server.

Parameters

None.

Default action

None.

Remarks

The MobiLink synchronization opens consolidated database connections on demand as synchronization requests come in. When a MobiLink client connects to the MobiLink server, the MobiLink server temporarily allocates one connection with the consolidated database server for all of the database activity for that synchronization. This event may not be called if the MobiLink server is using a connection from the connection pool.

Note This script is not generally used in Java or .NET, because instead of database variables you would use member variables in this class instance, and prepare the members in the constructor.

SQL example

The following SQL script works with a SQL Anywhere consolidated database. Two variables are created, one for the last_download timestamp, and one for employee ID.

CALL ml_add_connection_script(
    'custdb',
    'begin_connection',
    'create variable @LastDownload timestamp;
    create variable @EmployeeID integer;')