Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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.


JDBC Drivers - Netezza JDBC DriverImage Added

Contents

Table of Contents

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

No Format
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.