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.
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
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.
