One Star

[resolved] Cannot connect using Netezza driver

Hi,
I am doing some oracle (10g)->netezza integrations.
I have the Netezza OLEDB, ODBC and JDBC adapters installed.
TOS 3.2.2.r33000
I can connect to both Oracle or Netezza from TOS without problems using ODBC DSNs.

If I try to connect to Netezza using the Netezza driver with credentials that work in both ODBC and Aginity I get:
Connection failure. You must change the database settings
under Details>> I get
org.netezza.Driver

FWIW I also find I cannot connect to Oracle OR Netezza using generic JDBC although I can connect to a localhost ORCL instance without problems.
If I run nzjdbc.jar to run a config I can connect OK to the Netezza server.
Any ideas why I cannot get TOS to talk natively (?) to Netezza or how I can debug the JDBC connections?
BTW do we need a standard Netezza tag on the forums?
T
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Cannot connect using Netezza driver

Resolved after ticket raised - appears to be a combination of nzjdbc.jar version conflict (less likely) and lack of nzjdbc.jar in a lib/java folder (which had not been created by the installer)
4 REPLIES
One Star

Re: [resolved] Cannot connect using Netezza driver

I have also now written a simple JDBC test harness in Java and run it to determine that I can connect to Netezza OK independently of TOS and it works fine.
So the problem remains - how come TOS cannot make the JDBC connection?
T
Community Manager

Re: [resolved] Cannot connect using Netezza driver

Hello
Can you report a bug on our bugtracker?
Thanks for your support!
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Cannot connect using Netezza driver

Done - Issue 10407 raised
One Star

Re: [resolved] Cannot connect using Netezza driver

Resolved after ticket raised - appears to be a combination of nzjdbc.jar version conflict (less likely) and lack of nzjdbc.jar in a lib/java folder (which had not been created by the installer)