Installing the JDBC driver (Windows)

The JDBC driver processes the JDBC API interfaces, classes, and methods in the Java™ application. The Java application uses the JDBC driver to access the required data. The driver also returns results to the Java virtual machine.

Before you begin

Install the appropriate Netezza® appliance client tools. See Installing and uninstalling the client tools software.

About this task

You can have only one JDBC driver installed on your system at a time. If you need a different driver, you must remove the installed driver before you install the different one.

Procedure

  1. Start the installation program by double-clicking the nzjdbcsetup.exe file in the /drivers directory of the Windows installation kit.
  2. In the language option window, accept the default of English.
    The language option window controls the language for the installation program.
  3. In the Introduction window, review the information and click Next.
  4. If you want to change the installation folder from the IBM Netezza default, change the folder in the Choose Install Folder window. Click Next.
  5. In the Pre-Installation Summary window, review the summary of installation choices. You can also review and change selections by clicking Previous.
  6. Click Install.
  7. In the Installation Completed window, click Done.
    The Installation Completed window indicates that the Netezza JDBC driver installation process was completed successfully.

What to do next

Configure the JDBC data source. See Configuring the JDBC data source (Windows).

After installation, when you run an application that tries to use JDBC, you are prompted for a value called Class Name. For the IBM Netezza driver, enter org.netezza.Driver.