Preparing the Sybase Environment (JDBC)

How to:

In order to use the JDBC Adapter for Sybase, you must install the JDBC driver and its CLASSPATH value before server startup and ensure that the JSCOM3 service is running.

Procedure: How to Set Up the JDBC Environment on Windows and UNIX

  1. Identify the location of the JDBC Driverfiles by adding them to the CLASSPATH environment variable before server startup.

    For example, to set the JDBC Driver files to /qas/sybase_ASE/jconn4.jar on UNIX, issue the following commands:

    CLASSPATH=/qas/sybase_ASE/jconn4.jar;$CLASSPATH
    export CLASSPATH

    On UNIX, to ensure that the variable is set before server startup, add the CLASSPATH setting in your UNIX profile.

    On Windows, you would issue the following commands:

    set CLASSPATH=%c:\qas\sybase_ASE\jconn4.jar:
    %CLASSPATH%
    

    Note that if you run the server workspace as a Windows service, you must set CLASSPATH as a system-wide environment variable.

  2. Start, or Restart, the server.

WebFOCUS

Feedback