tELTNetezzaOutput and Netezza JDBC Driver

One Star

tELTNetezzaOutput and Netezza JDBC Driver

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
Moderator

Re: tELTNetezzaOutput and Netezza JDBC Driver

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tELTNetezzaOutput and Netezza JDBC Driver

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

Re: tELTNetezzaOutput and Netezza JDBC Driver

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tELTNetezzaOutput and Netezza JDBC Driver

ok. Thanks for your help.
Moderator

Re: tELTNetezzaOutput and Netezza JDBC Driver

Hi,
You are welcome. I think it may be more elegant than using a tLibraryLoad in job design.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.