Hi, When switched from TOS 4.2.2 from 4.2.1, I copied nzjdbc.jar to lib/java just like I did before. The connections and queries (imported from 4.2.1) test OK, but the jobs imported from 4.2.1 got a netezza drive not found error. Also when I re-export the same job from 4.2.2, nzjdbc.jar is missing from the zip file. Please help.
Shong, I'm having this same problem and editing the tNetezzaConnection_java.xml file does'nt solved.
I have followed the steps you said, but it only works using the tLibraryLoad component.
Otherwise I get the exception: Exception in component tNetezzaConnection_1
java.lang.ClassNotFoundException: org.netezza.Driver
Regards
Shong, I'm having this same problem and editing the tNetezzaConnection_java.xml file does'nt solved. I have followed the steps you said, but it only works using the tLibraryLoad component. Otherwise I get the exception: Exception in component tNetezzaConnection_1 java.lang.ClassNotFoundException: org.netezza.Driver Regards
Have you restarted studio after you modify the component? We tested before and it works! Simply add the driver, then later change the .xml file and restart.
Best regards
Shong
Yes, I've edited the tNetezzaConnection_java.xml file changing the line
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="false" />
to
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="true" />
With TOS closed, then I opened the suite so it could do the component regeneration, but it doesn't worked.
I've also tested creating another workspace, but nothing changed.
When I use the tNetezzaConnection component I get the following exception:
Exception in component tNetezzaConnection_1
java.lang.ClassNotFoundException: org.netezza.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at pbh.netezza_0_1.NETEZZA.tNetezzaConnection_1Process(NETEZZA.java:1082)
at pbh.netezza_0_1.NETEZZA.tPrejob_1Process(NETEZZA.java:48921)
at pbh.netezza_0_1.NETEZZA.runJobInTOS(NETEZZA.java:49105)
at pbh.netezza_0_1.NETEZZA.main(NETEZZA.java:48981)
The nzjdbc.jar file is on lib/java directory.
The only solution for me was using the tLibraryLoad component, then it works.
Hi anselmo
I tested the tNetezzaConnection component again and got the same problem! To install manually the driver does not work on v4.2.2, we will investigate the problem and fix it asap!
Best regards
Shong
