Preparing for the examples

Sample code

The code fragments in this section are taken from the complete class in samples-dir\SQLAnywhere\JDBC\JDBCExample.java.

To install the JDBCExample class

  1. Compile the JDBCExample.java source code.

  2. Using Interactive SQL, connect to the sample database as the DBA.

  3. Install the JDBCExample.class file into the sample database by executing the following statement in Interactive SQL (samples-dir represents the SQL Anywhere samples directory):

    INSTALL JAVA NEW
    FROM FILE 'samples-dir\SQLAnywhere\JDBC\JDBCExample.class'

    You can also install the class using Sybase Central. While connected to the sample database, open the Java subfolder under External Environments and choose File » New » Java Class. Follow the instructions in the wizard.