CODEWITHSUNDEEP
netezza
The Awnry Bear
The Awnry Bear

Reputation: 4619

Invalid packet length when connecting

Another team in my company commissioned a new server and installed Netezza on it, along with a bunch of internal programs. All of their programs that connect to Netezza are now giving this error:

A connection error has occurred: Invalid packet length

Attempting to connect to the database using a GUI such as DbVisualizer or RazorSQL gives the same error. Connecting to the "old" server still works fine. One of the differences between the two boxes is the Java version, 1.5 on the old one and 1.7 on the new one... not sure if that is relevant. (I'm not a Netezza expert, not really a Netezza user either!)

Any ideas?

Upvotes: 0

Views: 1807

Answers (1)

The Awnry Bear
The Awnry Bear

Reputation: 4619

I was under the impression from the start that both NZ1 and NZ2 were running the same Netezza version. Apparently that was not the case.

The new NZ2 host was running against version 6.0 whereas NZ2 was running against 3.0. The JDBC driver we were using for NZ2 was 3 major versions too old. This also explains why the nzsql client on NZ1 couldn't connect to the NZ2 host.

We updated to the latest JDBC driver from IBM and can now connect just fine.

Upvotes: 1

Related Questions