Preparing the HP Vertica Environment

How to:

In order to use the Adapter for HP Vertica, you must install the HP Vertica driver for whichever data source you would like to access, set its CLASSPATH value before server startup, and ensure that the JSCOM3 service is running.


Top of page

x
Procedure: How to Set Up the Environment on Windows and UNIX
  1. Identify the location of the HP Vertica Driver files by adding them to the environment variable CLASSPATH before server startup.

    For example, to set a UNIX or IBM i location for some HP Vertica Driver files to /usr/driver_files/mydriver.jar, issue the commands:

    CLASSPATH=/usr/driver_files/mydriver.jar;$CLASSPATH
    export CLASSPATH

    Similarly, on Windows, you would issue the command:

    set CLASSPATH=c:\usr\driver_files\mydriver.jar:%CLASSPATH%

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

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

  2. Start (or restart) the server.

    (Note that you also need to restart the server if the driver has changed.)

  3. Verify that the JSCOM3 service is active by issuing the following command in the server workspace
    edastart -show

    and checking that the special services section displays "JSCOM3 active".

    If the JSCOM3 service is not active, a "fail to start" message will typically also be in the server EDAPRINT log. To resolve the problem, review the HP Vertica listener requirements in the chapter for your operating system in the Server Installation manual.


WebFOCUS