Installing the JDBC Client Driver for Windows

To install the Vertica JDBC driver on your Windows client system, you must first download the cross-platform JDBC driver .jar file to your system. Then, choose the method that the Windows Java installation will use to find it.

Download the JDBC Driver for Windows

  1. On your Windows client system, open a browser, and log in to the myVertica portal.
  2. Install the Vertica JDBC driver for Windows:
    1. Navigate to the Downloads tab, and scroll to the Client Software section.
    2. Click the download link for the JDBC Driver for Windows installer.
  3. Accept the license agreement, and wait for the download to complete.

Choose How Java Locates the JDBC Driver Library

For your Java client application to use the Vertica JDBC driver, the Java interpreter must be able to find the driver's library file. Choose one of these methods to tell the Java interpreter where to look for the library:

  • Copy the JDBC .jar file you downloaded to the system-wide Java Extensions folder (C:\Windows\Sun\Java).
  • Add the directory containing the JDBC .jar file to the CLASSPATH environment variable (see Modifying the Java CLASSPATH).
  • Specify the directory containing the JDBC .jar using the -cp argument in the Java command line you use to start your Java command line.