ASA Programming Guide
  Using Java in the Database
    Java-enabling a database

Java-enabling a database

If you have created a database, or upgraded a database to standards, but have chosen not to Java-enable the database, you can add the necessary Java classes at a later date, using either Sybase Central or Interactive SQL.

To add the Java runtime classes to a database (Sybase Central)

1. Connect to the database from Sybase Central as a user with DBA authority.

2. Right-click the database and choose Upgrade Database.

3. Click Next on the introductory page of the wizard.

4. Select the database you want to upgrade from the list.

5. You can choose to create a backup of the database if you wish. Click Next.

6. You can choose to install jConnect meta-information support if you wish. Click Next.

7. Select the Install Java Support option. You must also choose which version of the JDK you want to install. The default classes are the JDK 1.3 classes.

8. Follow the remaining instructions in the wizard.

To add the Java runtime classes to a database (SQL)

1. Connect to the database from Interactive SQL as a user with DBA authority.

2. Execute the following statement:

   ALTER DATABASE UPGRADE JAVA ON

   For more information, see ALTER DATABASE statement.

3. Restart the database for the Java support to take effect.