Lesson 1: Compile the CustdbScripts Java class with MobiLink references

Java classes encapsulate synchronization logic in methods.

In this lesson, you compile a class associated with the CustDB sample database.

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, for example, is a synchronized table that supports a variety of table-level events.

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.

Create a CustdbScripts class

In this section, 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.

To create a CustdbScripts class

Create a directory for the Java class and assembly.

This tutorial assumes the path c:\mljava.

Using a text editor, enter the following code:

Note

The sample code in this tutorial illustrates a deprecated coding practice. It is recommended that you do not return SQL code when writing Java or .NET scripts. You should use make changes to the consolidated database directly from Java or .NET.

For more information, see Direct row handling.

public class CustdbScripts {
    public static String UploadInsert() {
        return("INSERT INTO ULCustomer(cust_id,cust_name) values (?,?)");
    }
    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 Java source code

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.

To compile the Java source code

At a command prompt, navigate to the folder containing CustdbScripts.java (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.