IBM Support

JDBC Driver Error "Unable to Connect:  Unexpected error during test connection: Connection refused: connect"

Troubleshooting


Problem

When trying to connect using WebSphere Cast Iron to IBM Netezza with JDBC Driver using nzjdbc3.jar, the error SQLSTATE: 08001  ERRORCODE: 1114 Error Message: Connection refused: connect  occurs

Symptom

SEVERE: An error occurred while processing the message for the parameterized query activity at row number 0. The error is: Connection error while getting connection out of the pool. SQLSTATE: 08001  ERRORCODE: 1114 Error Message: Connection refused: connect 

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"IBM Netezza Analytics","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"Workstation","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSUSQ8","label":"IBM Netezza Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"Workstation","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 June 2022

UID

swg21977631