[resolved] Netezza driver not pickup in TOS 4.2.2

One Star

[resolved] Netezza driver not pickup in TOS 4.2.2

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.

Accepted Solutions
Community Manager

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Hi
It was a bug on component, our developer have offered a solution:
You can go in the folder:
plugins/org.talend.designer.components.localprovider_4.2.2.r63143/components/tNetezzaOutput
Then in the file NetezzaOutput_java.xml
There is at the end:
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="false" />
should change to:
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="true" />
save the file and copy the nzjdbc.jar file to the lib/java folder, restart studio!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Having the same issue. I will log it as a bug.

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

This is not a bug, but a request from IBM/Netezza that Talend not package the driver any longer. In your 4.2 installs, you will need to add the nzjdbc.jar to the /lib/java and all of the component folders.
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Did just that in tNetezzaInput component folder. Still not picking up.
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

It seems there is a reading comprehension issue here!
Hughxie and I have copied the nzjdbc.jar file to the lib/java folder (as he noted in his post), and I have also copied it to every component sub-folder, and am still receiving the same error. (Hughxie apparently did the same.)
I opened a ticket with support, noting that I had done the same, and they closed it saying "Not a bug. Please copy to lib/java." I have re-opened my ticket.

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Please excuse my mistake... A possible work-around could be to use a tLibraryLoad component to force loading of the Netezza driver.
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Force loading with tLibraryLoad works. I like know if this the behavior of furture releases. If yes, I need to add tLibraryLoad to all my jobs. Otherwise, I will skip 4.2.2.
Community Manager

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

It seems there is a reading comprehension issue here!
Hughxie and I have copied the nzjdbc.jar file to the lib/java folder (as he noted in his post), and I have also copied it to every component sub-folder, and am still receiving the same error. (Hughxie apparently did the same.)
I opened a ticket with support, noting that I had done the same, and they closed it saying "Not a bug. Please copy to lib/java." I have re-opened my ticket.

Hi esemeniuk
Please tell us your issue number on bugtracker.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Community Manager

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Hi
It was a bug on component, our developer have offered a solution:
You can go in the folder:
plugins/org.talend.designer.components.localprovider_4.2.2.r63143/components/tNetezzaOutput
Then in the file NetezzaOutput_java.xml
There is at the end:
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="false" />
should change to:
<IMPORT NAME="Driver-Netezza" MODULE="nzjdbc.jar" REQUIRED="true" />
save the file and copy the nzjdbc.jar file to the lib/java folder, restart studio!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

Thanks Shong!
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

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
Community Manager

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

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.
Community Manager

Re: [resolved] Netezza driver not pickup in TOS 4.2.2

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
----------------------------------------------------------
Talend | Data Agility for Modern Business