ASA Programming Guide
Introduction to Java in the Database
Tutorial: A Java in the database exercise
Java classes must be installed into a database before they can be used. You can install classes from Sybase Central or Interactive SQL. This section provides instructions for both. Choose whichever you prefer.
To install the class to the sample database ( Sybase Central )
Start Sybase Central and connect to the sample database.
Open the Java Objects folder and double-click Add Java Class. The Java Class Creation wizard appears.
Use the Browse button to locate Invoice.class in the Samples\ASA\JavaInvoice subdirectory of your SQL Anywhere installation directory.
Click Finish to exit the wizard.
To install the class to the sample database ( Interactive SQL )
Start Interactive SQL and connect to the sample database.
In the SQL Statements pane of Interactive SQL, type the following command:
INSTALL JAVA NEW FROM FILE 'path\\samples\\ASA\\JavaInvoice\\Invoice.class'
where path is your SQL Anywhere directory.
The class is now installed into the sample database.
At this point no Java in the database operations have taken place. The class has been installed into the database and is ready for use as the data type of a variable or column in a table.
Changes made to the class file from now on are not automatically reflected in the copy of the class in the database. You must re-install the classes if you want the changes reflected.
For more information on installing classes, and for information on updating an installed class, see Installing Java classes into a database.