IBM Support

Database Connection Refused

Troubleshooting


Problem

Attempts to connect to the Derby database result in connection refused when initiated from IBM Tivoli Directory Integrator(TDI).

Symptom

java.sql.SQLNonTransientConnectionException: The connection was refused because the database 'c:\Program Files\IBM\TDI\V7.1/TDISysStore;create=true' was not found.

org.apache.derby.client.am.DisconnectException: The connection was refused because the database C:\Users\Administrator\Documents\TDI/TDISysStore;create=true was not found.

Cause

This is likely due to the TDI Server not knowing the location of the database.

Resolving The Problem

1. Stop ALL instances of Derby and TDI.

2. Locate the Directory Path specified in the 'com.ibm.di.store.database' parameter found in the solution.properties file. This path is the location where the Derby Database is located.


    Example:
    com.ibm.di.store.database=jdbc:derby://localhost:1527/C:\Program Files\IBM\TDI\V7.1/TDISysStore;create=true

3. Modify the 'derby.properties' file found in the following directories
  • [TDI_InstallDir]/etc
  • [TDI_SolutionDir]/etc


Add the following parameter to the files.

    derby.system.home=
    Example: derby.system.home=C:\Program Files\IBM\TDI\V7.1
[{"Product":{"code":"SSCQGF","label":"Tivoli Directory Integrator"},"Business Unit":{"code":"BU008","label":"Security"},"Component":"General","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0;7.1;7.1.1","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

More support for:
Tivoli Directory Integrator

Software version:
7.0, 7.1, 7.1.1

Document number:
708673

Modified date:
21 June 2018

UID

swg21496822

Page Feedback