Wisdomforce reports that Netezza Driver cannot be loaded.

After dumping the jdbc driver file in all different locations in the hope that one would be picked up, this failed. The reason is that the gui.cmd sets the environment each time before execution.

Wisdomforce reports that Netezza Driver cannot be loaded.

After dumping the jdbc driver file in all different locations in the hope that one would be picked up, this failed. The reason is that the gui.cmd sets the environment each time before execution.

Here’s the gui.cmd file :

@ECHO OFF
 ECHO Java version:
 java -version
 SET MYSQL_JDBC_DRIVER_LIB=lib/mm.mysql-2.0.14-bin.jar
 SET POSTGRESQL_JDBC_DRIVER_LIB=lib/postgresql-8.2-505.jdbc2.jar
 SET TERADATA_JDBC_DRIVER_HOME=
java -cp ./;lib/reader_gui.jar;lib/classes12.jar;%MYSQL_JDBC_DRIVER_LIB%;%POSTGRESQL_JDBC_DRIVER_LIB%;lib/jtds.jar;lib/db2jcc.jar;%TERADATA_JDBC_DRIVER_HOME%/terajdbc4.jar;%TERADATA_JDBC_DRIVER_HOME%/tdgssconfig.jar;%TERADATA_JDBC_DRIVER_HOME%/tdgssjava.jar;lib/db2jcc_license_cu.jar;lib/jvftp.jar com.wisdom.client.Main %1 %2

This is fine if you are working with one of the listed jar files above. However, we were looking for nzjdbc.jar. Create a netezza.cmd file containing the following:

@ECHO OFF
 ECHO Java version:
 java -version
 SET MYSQL_JDBC_DRIVER_LIB=lib/mm.mysql-2.0.14-bin.jar
 SET POSTGRESQL_JDBC_DRIVER_LIB=lib/postgresql-8.2-505.jdbc2.jar
 SET TERADATA_JDBC_DRIVER_HOME=
 SET NETEZZA_JDBC_DRIVER_LIB=lib/nzjdbc.jar
java -cp ./;lib/reader_gui.jar;lib/classes12.jar;%NETEZZA_JDBC_DRIVER_LIB%;%MYSQL_JDBC_DRIVER_LIB%;%POSTGRESQL_JDBC_DRIVER_LIB%;lib/jtds.jar;lib/db2jcc.jar;%TERADATA_JDBC_DRIVER_HOME%/terajdbc4.jar;%TERADATA_JDBC_DRIVER_HOME%/tdgssconfig.jar;%TERADATA_JDBC_DRIVER_HOME%/tdgssjava.jar;lib/db2jcc_license_cu.jar;lib/jvftp.jar com.wisdom.client.Main %1 %2

This worked for me. Now to just resolve the oracle issues with TNS errors……..

* FastReader, Version 6.6.3
 * This copy of FastReader is registered to ME:)
 * (This license will expire in 5 days)
 * Copyright (c) 2011 WisdomForce Technologies, Inc.
 * All rights reserved
 * We'd appreciate if you could send your feedback
 * and suggestions to info@wisdomforce.com
 * Contact support at support@wisdomforce.com
 * FastReader is running on host [********] system [Win32]
 * Release [Windows NT 5.1] version [Build 2600 Service Pack 2]
 * Machine [Intel Pentium Pro]
Warning: Unable to connect to DB using normal connection string, retrying with secondary connection string
 [12514] msg ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

That’s an oracle problem :)

Email

Leave a Reply