Lesson 2: Register your Java or .NET scripts for the authenticate

Lesson 2: Register your Java or .NET scripts for the authenticate_user event

In this lesson, you register the MobiLinkAuth authenticateUser method for the authenticate_user synchronization event. You add this script to CustDB, the MobiLink sample database.

MobiLink database sample

SQL Anywhere ships with a SQL Anywhere sample database (CustDB) that is already set up for synchronization. The CustDB ULCustomer table, for example, is a synchronized table supporting a variety of table-level scripts.

CustDB is designed to be a consolidated database server for both UltraLite and SQL Anywhere clients. The CustDB database has a DSN named SQL Anywhere 12 CustDB.

♦ To register the authenticateUser method for the authenticate_user event

Connect to the sample database using Interactive SQL.

Run the following command:
dbisql -c "dsn=SQL Anywhere 12 CustDB"

Use the ml_add_java_connection_script or ml_add_dnet_connection_script stored procedure to register the authenticateUser method for the authenticate_user event.

For Java, run the following SQL script:

CALL ml_add_java_connection_script(
    'custdb 12.0',
    'authenticate_user',
    'MobiLinkAuth.authenticateUser');

COMMIT;

For .NET, run the following SQL script:

CALL ml_add_dnet_connection_script(
    'custdb 12.0',
    'authenticate_user',
    'MobiLinkAuth.authenticateUser');

COMMIT;

In the next lesson, you start the MobiLink server and load your class file or assembly.