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

[resolved] Netezza driver not pickup in TOS 4.2.2

Anonymous — Sat, 16 Nov 2024 12:49:03 GMT

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.

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

_AnonymousUser — Fri, 15 Jul 2011 18:29:52 GMT

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

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

Anonymous — Fri, 15 Jul 2011 19:20:33 GMT

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.

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

Anonymous — Fri, 15 Jul 2011 20:37:46 GMT

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

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

Anonymous — Mon, 18 Jul 2011 13:27:02 GMT

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

Anonymous — Mon, 18 Jul 2011 14:12:38 GMT

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

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

Anonymous — Mon, 18 Jul 2011 14:35:16 GMT

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.

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

Anonymous — Mon, 18 Jul 2011 14:47:04 GMT

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

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

Anonymous — Mon, 18 Jul 2011 16:13:55 GMT

http://www.talendforge.org/bugs/print_bug_page.php?bug_id=23305

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

Anonymous — Tue, 19 Jul 2011 07:21:40 GMT

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

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

Anonymous — Tue, 19 Jul 2011 14:45:04 GMT

Thanks Shong!

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

Anonymous — Wed, 20 Jul 2011 20:53:40 GMT

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

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

Anonymous — Thu, 21 Jul 2011 02:49:24 GMT

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

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

Anonymous — Thu, 21 Jul 2011 20:39:33 GMT

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.

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

Anonymous — Fri, 22 Jul 2011 05:27:24 GMT

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