topic Re: tELTNetezzaOutput and Netezza JDBC Driver in Talend Studio

tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Sat, 16 Nov 2024 12:00:28 GMT

Using tELTNetezzaOutput component, I'm facing the following issue when running my job from TOSDI 5.3 :
Exception in component tELTNetezzaOutput_1
java.lang.ClassNotFoundException: org.netezza.Driver
nzjdbc.jar is located in java.library.path directory
Does someone face this kind of issue ?
Many thanks for your help

Re: tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Fri, 07 Jun 2013 03:46:57 GMT

Hi,
What's your work flow? Is there any compile error under the "Code" tab?
Could you paste your job design screenshot into forum.
Best regards
Sabrina

Re: tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Fri, 07 Jun 2013 11:26:29 GMT

Hi,
Thanks for your answer.
Adding a tLibraryLoad node fixes the problem, but it's not very elegant ...

Re: tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Fri, 07 Jun 2013 12:04:13 GMT

Hi,
It is a missing DB driver issue for JDBC. So need import .jar into studio using tLibraryLoad.
How about using ODBC connection? Set the Data Source(ODBC) first.
Best regards
Sabrina

Re: tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Fri, 07 Jun 2013 12:25:45 GMT

ok. Thanks for your help.

Re: tELTNetezzaOutput and Netezza JDBC Driver

Anonymous — Sat, 08 Jun 2013 05:17:34 GMT

Hi,
You are welcome. I think it may be more elegant than using a tLibraryLoad in job design.
Best regards
Sabrina