[resolved] Netezza driver not pickup in TOS 4.2.2

[Anonymous]

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.

[_AnonymousUser]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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