Installing and configuring JDBC

The JDBC specification defines an API for the Java™ programming environment that Java programmers can use to access relational databases and issue SQL statements.

Note:
  1. As compared to IBM® PureData® System for Analytics, 11.X drivers are based on RHEL 7 and require GLIBC_2.14.

  2. The JDBC driver does NOT support SSLv3 connection, as Java 8 update 31 disables SSLv3 support as default.

  3. Suffixes are not supported in the JDBC logs. For example, if version 11.2.1.7-IF1 specified in the configuration file, the logs print 11.2.2.7 instead. As a result, the drivers fail.

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

Before you use JDBC, verify that the Java runtime environment is installed on your system. You need Java 1.7 or later. For more information, go to the Java website, where you can test your system for Java software support and download the latest version for your system.