I'm attempting to connect to a Netezza server, and gettting an error. I've tried both the tNetezzaInput component, and the tJDBCInput connection, both generate the same error.
The error: when I run a simple job to retrieve data: "A connection error has occurred: Invalid - database name" (full text below)
I know that the underlying connection is good, as it is possible to create a new connection, then do "Import Schema" using both Netezza and JDBC options. The Import Schema correctly retreives various tables.
Any ideas?
Exception in component tNetezzaInput_2
org.netezza.util.PSQLException: A connection error has occurred: Invalid - database name
at org.netezza.core.PgHandshake.handshake(Unknown Source)
at org.netezza.core.PgHandshake.connect(Unknown Source)
at org.netezza.jdbc1.AbstractJdbc1Connection.handshake(Unknown Source)
at org.netezza.jdbc1.AbstractJdbc1Connection.openConnection(Unknown Source)
at org.netezza.Driver.getConnection(Unknown Source)
at org.netezza.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at testjava.testnetezza_0_1.testnetezza.tNetezzaInput_2Process(testnetezza.java:888)
at testjava.testnetezza_0_1.testnetezza.runJobInTOS(testnetezza.java:1547)
at testjava.testnetezza_0_1.testnetezza.main(testnetezza.java:1459)
I am now able to successfully run a simple job to extract and load tables in netezza. I'm not sure what the solution was, I re-created the job from scratch and it now works, in both tNetezzaInput/Output and ODBC components.
