Netezza JDBC Drivers

The Netezza JDBC Driver nzjdbc.jar file must be downloaded from vendor and is not bundled within Aqua Data Studio. Copy the driver into the Aqua Data Studio/lib/drivers folder.

Netezza server releases are frequent, and may sometimes require updating the JDBC driver.

Contents

• Driver Location
• Updating Driver Contents for use with Netezza

Driver Location

You may locate the latest Netezza JDBC drivers at the following location ...

Vendor: IBM
Driver URL: Contact your Netezza Representative
Database Product: Netezza

Updating Driver Contents for use Netezza

To update the Aqua Data Studio JDBC drivers for Netezza you need to overwrite the Aqua Data Studio nzjdbc.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\nzjdbc.jar

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers

11/23/2012  08:58 AM    <DIR>          .
11/23/2012  08:58 AM    <DIR>          ..
12/21/2012  10:24 AM            35,701 cassandra-clientutil.jar
12/21/2012  10:24 AM            64,465 cassandra-jdbc.jar
12/21/2012  10:24 AM           948,351 cassandra-thrift.jar
12/21/2012  10:24 AM         1,146,367 db2java.jar
12/21/2012  10:24 AM         3,348,681 db2jcc.jar
12/21/2012  10:24 AM             1,015 db2jcc_license_cu.jar
12/21/2012  10:24 AM         2,703,892 derby.jar
12/21/2012  10:24 AM           535,985 derbyclient.jar
12/21/2012  10:24 AM           242,891 derbynet.jar
12/21/2012  10:24 AM           812,386 ifxjdbc.jar
12/21/2012  10:24 AM         1,660,765 jconnect70.jar
12/21/2012  10:24 AM           141,648 jsqlparser-src.zip
12/21/2012  10:24 AM           142,861 jsqlparser.jar
12/21/2012  10:24 AM         4,581,825 jt400.jar
12/21/2012  10:24 AM           349,542 jtds-src.jar
12/21/2012  10:24 AM           330,688 jtds.jar
12/21/2012  10:24 AM           388,540 mongo.jar
12/21/2012  10:24 AM           651,205 mysql-src.jar
12/21/2012  10:24 AM           745,416 mysql.jar
12/21/2012  10:24 AM           445,188 ncluster.jar
12/03/2012  02:56 PM           340,338 nzjdbc.jar
12/21/2012  10:24 AM         2,714,189 ojdbc6.jar
12/21/2012  10:24 AM         1,656,248 orai18n.jar
12/21/2012  10:24 AM           346,944 paraccel-jdbc.jar
12/21/2012  10:24 AM           561,969 postgresql.jar
12/21/2012  10:24 AM         3,516,830 sqlite-jdbc.jar
12/21/2012  10:24 AM           286,773 util400.jar
12/21/2012  10:24 AM           262,740 xdb6.jar
12/21/2012  10:24 AM           839,982 xmlparserv2.jar
              29 File(s)     29,803,425 bytes
               2 Dir(s)  86,583,730,176 bytes free

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>

Linux

[ADS_INSTALL]/lib/drivers/nzjdbc.jar

OSX

Aqua Data Studio.app/Contents/Java/drivers/nzjdbc.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.