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