Lesson 1: Compiling the CustdbScripts Java class with MobiLink references

In this lesson, you compile a class associated with the CustDB sample database. You create a Java class called CustdbScripts with logic to handle the ULCustomer upload_insert and download_cursor events. You enter the CustdbScripts code in a text editor and save the file as CustdbScripts.java.

MobiLink database sample

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

CustDB is designed to be a consolidated database for UltraLite and SQL Anywhere clients. The CustDB database has an ODBC data source named SQL Anywhere 12 CustDB.

Create a CustdbScripts class

To execute Java synchronization logic, the MobiLink server must have access to the classes in mlscript.jar. This JAR file contains a repository of MobiLink server API classes to use in your Java methods.

When compiling Java source code for MobiLink, you must include mlscript.jar to make use of the MobiLink server API. In this section, you use the javac utility's -classpath option to specify mlscript.jar for the CustdbScripts class.

Create a CustdbScripts class

Create a directory for the Java class and assembly.

This tutorial assumes the path c:\mljava.

In a text editor, write the following code:

public class CustdbScripts {
    public static String UploadInsert() {
        return("INSERT INTO ULCustomer(cust_id,cust_name) VALUES ({ml r.cust_id}, {ml r.cust_name})");
    }
    public String DownloadCursor(java.sql.Timestamp ts,String user ) {
        return("SELECT cust_id, cust_name FROM ULCustomer WHERE last_modified >= ' " + ts + " ' ");
    }
}

Note

When creating your own custom scripts, make sure that the classes and associated methods are defined as public.

Save the file as CustdbScripts.java in c:\mljava.

Compile the file.

Run the following command:

javac custdbscripts.java -classpath "C:\Program Files\SQL Anywhere 12\java\mlscript.jar"

Replace C:\Program Files\SQL Anywhere 12 with the location of your SQL Anywhere installation.

The CustdbScripts.class file is generated.

Proceed to Lesson 2: Creating a MobiLink project.