topic Cannot connect to Netezza DB in Talend Studio

Cannot connect to Netezza DB

Anonymous — Wed, 28 Mar 2012 13:57:06 GMT

I cannot get a simple connection to Netezza to work. I have worked with TIS 3.x and have several jobs working with Netezza (tNetezzaBulkExec and tJDBCConnection). Now I am in TIS 4.2.3 and cannot get the tNetezzaConnection to work. I did import the nzjdbc.jar into the Modules screen. the only has the tNetezzaConnection in it, nothing else. Here is the error. Please let me know if you have any ideas.
Starting job test at 18:08 27/03/2012.
connecting to socket on port 4078
connected
Exception in component tNetezzaConnection_1
java.lang.NullPointerException
at org.netezza.internal.NzSocket.sendChar(NzSocket.java:89)
at org.netezza.sql.NzConnection.close(NzConnection.java:1113)
at org.netezza.sql.NzConnection.initSocket(NzConnection.java:2586)
at org.netezza.sql.NzConnection.open(NzConnection.java:253)
at org.netezza.datasource.NzDatasource.getConnection(NzDatasource.java:523)
at org.netezza.datasource.NzDatasource.getConnection(NzDatasource.java:510)
at org.netezza.Driver.connect(Driver.java:150)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at aci_engine_2.test_0_1.test.tNetezzaConnection_1Process(test.java:243)
at aci_engine_2.test_0_1.test.runJobInTOS(test.java:467)
at aci_engine_2.test_0_1.test.main(test.java:335)
disconnected
Job test ended at 18:08 27/03/2012.

Re: Cannot connect to Netezza DB

Anonymous — Thu, 29 Mar 2012 05:53:20 GMT

Hi
There isn't any different between tJDBCConnection and tNetezzaConnection judging from Java code aspect.
Can you connect to netezza with tJDBCConnection in TIS4.2.3?
I think maybe you didn't type all parameters correctly.
Regards,
Pedro

Re: Cannot connect to Netezza DB

Anonymous — Fri, 30 Mar 2012 00:01:59 GMT

I tried tJDBCConnection originally then went to the Netezza connection thinking that it may work. I can successfully connect via JaySQL which uses JDBC using the same parameters and jar file.

Re: Cannot connect to Netezza DB

Anonymous — Fri, 30 Mar 2012 02:54:57 GMT

Hi
Please report it on BugTracker.
Regards,
Pedro