Tech Tips: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1528 with message Connection refused.

Document created by MarcyNunns Employee on Oct 5, 2017
Version 1Show Document
  • View in full screen mode

Issue:
Getting this error when running any report from the DevTest Portal:


JasperReports encountered an error on context creation!
java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1528 with message Connection refused.

Environment:
Reported in DevTest 9.5.1, but can apply to any supported DevTest release.


Cause:
This property was changed in the lisa.properties file:
From:
lisadb.internal.host=0.0.0.0
To:
lisadb.internal.host=<hostname of computer running Registry>

This property configures the Derby database to be accessible from all network interfaces present on the machine, which is why it should never be changed.

Derby is not supported in a production environment, only verifying the product out of the box.


Resolution:
Setting value back in the lisa.properties file to:

lisadb.internal.host=0.0.0.0

 

Additional Information:
It is recommended to never change the lisa.properties file properties to other values.

 

KB: TEC1935105

Attachments

    Outcomes