tELTNetezzaOutput and Netezza JDBC Driver

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

ok. Thanks for your help.

[Anonymous]

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