Contents Index Configuring the UltraLite Java database Adding synchronization to your application pdf/preface.pdf

UltraLite User's Guide
  Developing UltraLite Java Applications

Including SQL statements in UltraLite Java applications


This section describes how to add SQL statements to your UltraLite application.

For information on SQL features that can and cannot be used in UltraLite application, see SQL features and limitations of UltraLite applications.

The SQL statements to be used in your application must be added to the reference database. The UltraLite generator writes out an interface that defines these SQL statements as public static final strings. You invoke the statements in your application by implementing the interface and referencing the SQL statement by its identifier, or by referencing it directly from the interface.

Defining the SQL statements for your application 

The SQL statements to be included in the UltraLite application, and the structure of the UltraLite database itself, are defined by adding the SQL statements to the reference database for your application.

For information on reference databases, see Preparing a reference database.

Defining projects 

Each SQL statement stored in the reference database is associated with a project. A project is a name, defined in the reference database, which groups the SQL statements for one application. You can store SQL statements for multiple applications in a single reference database by defining multiple projects.

For information on creating projects, see Creating an UltraLite project.

Adding statements to your project 

The data access statements you are going to use in your UltraLite application must be added to your project.

For information on adding SQL statements to your database, see Adding SQL statements to an UltraLite project.


Contents Index Configuring the UltraLite Java database Adding synchronization to your application pdf/preface.pdf