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 FAQ
Java error handling
Creating a Java class for use with SQL Anywhere
Java VMs
Installing the sample Java class
The CLASSPATH environment variable
Calling methods in the Java class
Installing Java classes into a database
Special features of Java classes in the database
Starting and stopping the Java VM
Shutdown hooks in the Java VM