Search code examples
networkingoracle11gibm-mobilefirstwebsphere-liberty

Details: java.sql.SQLRecoverableException: IO Error: Connection reset


I am trying to deploy the configuration and runtime using IBM Mobilfirst Server Configuration Tool for the server configuration, and I end up with a connection reset error. The error from the logfiles is Cannot access database: ServiceName. Details: java.sql.SQLRecoverableException: IO Error: Connection reset. Kindly help in resolving this issue. Which part is throwing the error? Is it DB side? Network Connectivity?


Solution

  • The ServerConfig Tool (SCT) creates the URL first by considering that the database name as SID. If the connection fails, it then connects using the database name as a service name.

    I see that you are seeing the error - 'Cannot access database: ServiceName. Details: java.sql.SQLRecoverableException: IO Error'.

    When SCT notices an unknown error while connecting it stops the connection process with the above error.

    I would recommend you to run the ANT tasks for configuring MFP to get detailed logs on why configuration is failing.