You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For our applications we use an Oracle database, and occasionally the connection to the database gets completely lost - network issue, database outage (planned or unplanned), etc. When these issues happen, we end up in the situation where HikariCP isn't able to recover database connectivity automatically, which seems to be the same issue that's been reported various times before (ie: #1056, #2179, #1815, #1736). The recommendation from #1056 is to set the driver's socketTimeout property, with the rest pointing to https://github.com/brettwooldridge/HikariCP/wiki/Rapid-Recovery, which lists PostgreSQL, MySQL, and SQL Server as supporting the socketTimeout property and for the others it says:
Each driver differs in how this timeout is set, but nearly all drivers support it.
The question: are these the correct properties to set? It sounds like they are, but I'm not an expert and was hoping I could get confirmation before I start using them.
The text was updated successfully, but these errors were encountered:
For our applications we use an Oracle database, and occasionally the connection to the database gets completely lost - network issue, database outage (planned or unplanned), etc. When these issues happen, we end up in the situation where HikariCP isn't able to recover database connectivity automatically, which seems to be the same issue that's been reported various times before (ie: #1056, #2179, #1815, #1736). The recommendation from #1056 is to set the driver's socketTimeout property, with the rest pointing to https://github.com/brettwooldridge/HikariCP/wiki/Rapid-Recovery, which lists PostgreSQL, MySQL, and SQL Server as supporting the
socketTimeout
property and for the others it says:From #2179 the suggested solution is to set the
oracle.net.CONNECT_TIMEOUT
andoracle.jdbc.ReadTimeout
connection properties which I found documentation for these at https://docs.oracle.com/en/database/oracle/oracle-database/19/jajdb/oracle/jdbc/OracleConnection.html forCONNECTION_PROPERTY_THIN_OUTBOUND_CONNECT_TIMEOUT
andCONNECTION_PROPERTY_THIN_READ_TIMEOUT
respectively.The question: are these the correct properties to set? It sounds like they are, but I'm not an expert and was hoping I could get confirmation before I start using them.
The text was updated successfully, but these errors were encountered: