Java in the database

SQL Anywhere provides a mechanism for executing Java classes from within the database server environment. Using Java methods in the database server provides powerful ways of adding programming logic to a database.

Java support in the database offers the following:

  • Reuse Java components in the different layers of your application—client, middle-tier, or server—and use them wherever it makes the most sense to you. SQL Anywhere becomes a platform for distributed computing.

  • Java provides a more powerful language than the SQL stored procedure language for building logic into the database.

  • Java can be used in the database server without jeopardizing the integrity, security, or robustness of the database and the server.

 The SQLJ standard

Learning about Java in the database
Java in the database Q & A
Java error handling
Creating a Java class for use with SQL Anywhere
Choosing a Java VM
Install the sample Java class
Using the CLASSPATH variable
Accessing methods in the Java class
Accessing fields and methods of the Java object
Installing Java classes into a database
Special features of Java classes in the database
Starting and stopping the Java VM