Facing below issue while trying to enable the JBDC adapter connection -
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource jdbc:databaseConnection.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection jdbc:databaseConnection: after 1 attempt(s).
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
IO Error: Got minus one from a read call
Kindly provide the details below:
1> JDBC Adapter version with fix levels
2> DB version with JDBC driver details
3> Connection params from JDBC adapter connection (screen shot)
4> Is issue permanent or intermittent?
IMO, The error message “Io error:
Got
minus
one
from a read
call” is returned by the database communication layer and most possible root cause is an unexpected communication issue between the client database driver and the back-end (Oracle database) system, due the TCP socket is being closed.
The problem can be located also at the database side, the Oracle administrators can check if there is any kind of error recorded at database side when the connection issue at JDBC Adapter side is detected. The error can be due to any resource issue at database side like maximum number of connections, processes, an Oracle listener (TNS) issue, etc.
To isolate the issue from wM side you have the latest fix levels installed on your JDBC version and have the correct JDBC driver installed with it.