/
How to resolve a network error due to invalid database port - 10.x

How to resolve a network error due to invalid database port - 10.x

Owned by Smita Nair
Feb 18, 2020

Symptoms

One or more SQL macros return the following error:

org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Network error IOException: Connection refused)

Cause

The data source configuration is unable to connect to the specified database because of an invalid port.

Resolution

Ensure that the database is listening to the requested port, and, verify the port configurations on server.xml and database.