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.

If you are using Vertica client drivers for Windows that were released before Vertica 7.2.3, you must first uninstall the older drivers. This is true for the separate JDBC client driver download (the .jar file). This is also true for the client drivers included in the package, Client Drivers and Tools for Windows (an .exe file), which includes ODBC, vsql, ADO.NET, OLEDB, the Visual Studio plugin, and SQL Server integration components. Once you have installed client versions 7.2.3, you do not need to uninstall for upgrades that follow. For example, upgrading from 8.1.x to 9.2.x would not require that you uninstall before upgrade.

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.