UltraLite User's Guide
  Tutorial: Build an Application Using Java
    Introduction

Overview

In the first lesson, you write and build an application that carries out the following tasks.

1. Connects to an UltraLite database, consisting of a single table. The table is a subset of the ULProduct table of the UltraLite Sample database.

2. Inserts rows into the table. Initial data is usually added to an UltraLite application by synchronizing with a consolidated database. Synchronization is added later in the chapter.

3. Writes the rows of the table to standard output.

In order to build the application, you must carry out the following steps:

1. Create an Adaptive Server Anywhere reference database.

   Here we use the UltraLite sample database (CustDB).

2. Add the SQL statements to be used in your application to the reference database.

3. Run the UltraLite generator to generate the Java code and also an additional source file for this UltraLite database.

   The generator writes out a .java file holding the SQL statements, in a form you can use in your application, and a .java file holding the code that executes the queries.

4. Write source code that implements the logic of the application.

   Here, the source code is a single file, named Sample.java.

5. Compile and run the application.

In the second lesson you add synchronization to your application.