Installing a Java Class or JAR File into a Sybase IQ Database

Install a Java class or JAR file to a Sybase IQ database. This enables the database to execute functions and procedures written in Java.

Prerequisites
Task

A Java external environment appears in the list of external environments in the Sybase Control Center Administration Console even when none of its classes or JAR files have been installed.

  1. From the application menu bar, select View > Open > Administration Console.
  2. In the Administration Console, expand IQ Servers > External Environments > Java.
  3. Select either:
    • Classes or
    • JARs
    Then click the drop-down arrow that appears to the right and select New.
  4. In the installation dialog, select a Sybase IQ resource on which to install the class or JAR.
  5. If you select a multiplex, the dialog displays a new menu. Use it to select the server in the multiplex on which to install the class or JAR.
  6. If the SCC agent on the selected server is not registered, click Register Agent and enter the required registration information.
    The Register Agent button is not active if the server has been registered.
  7. If the SCC agent on the selected server is not authenticated, click Authenticate Agent. Enter a user ID, password, and port for SCC to use when it logs in to the SCC agent.
    The Authenticate Agent button is not active if the server has been authenticated.
  8. Enter the path to the Java class file. It must be on a file system accessible to the Sybase IQ resource.
  9. If you are installing a JAR, enter its name.
  10. (Optional) Enter a comment describing the class or JAR.
  11. If you are installing a JAR, select classes to install.
  12. Click Finish to install the class or JAR.
Related tasks
Modifying the Properties of a Java Class or JAR File
Updating a Java Class or JAR File
Deleting a Java Class or JAR File
Testing the Configuration of a Java External Environment
Modifying the Properties of a Java External Environment
Registering and Authenticating a Sybase Control Center Agent