Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » Java in the Database » Java in the database Q & A

What are the key features of Java in the database? Next Page

How do I store Java classes in the database?


Java is an object-oriented language, so its instructions (source code) come in the form of classes. To execute Java in a database, you write the Java instructions outside the database and compile them outside the database into compiled classes (byte code), which are binary files holding Java instructions.

You then install these compiled classes into a database. Once installed, you can execute these classes in the database server as a stored procedure. For example, the following statement creates a Java stored procedure:

CREATE PROCEDURE insertfix() 
EXTERNAL NAME 'JDBCExample.InsertFixed ()V' 
LANGUAGE JAVA;

SQL Anywhere is a runtime environment for Java classes, not a Java development environment. You need a Java development environment, such as the Sun Microsystems Java Development Kit, to write and compile Java.

For more information, see Installing Java classes into a database.