I have a Java thread that connects to Oracle when triggered by input. As soon as the thread starts, there are no connection issues with Oracle. However, after a while, when there is input trigger, the connection to Oracle throws the following exception. Please guide me on how to identify the cause and fix this bug.
Details: App server: centos-linux-release-8.5-1.2111.el8.noarch Oracle Db version: Oracle 11.2.0.3.0, ojdbc14.jar Java: OpenJDK version "1.8.0_312"
java.sql.SQLException: Io exception: Connection timed out (Read failed)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:817)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
