My Oracle Support Banner

JDBC Application Thread Hangs at pingDatabase() Call (Doc ID 2900648.1)

Last updated on OCTOBER 18, 2023

Applies to:

JDBC - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

A JDBC 19c application thread is found to hang at pingDatabase() call.

Exception stack
2022-09-07 05:32:39,033 GMT*8*::::::::::::::
java.lang.Object.wait(Native Method)
java.lang.Object.wait(Object.java:216)
java.lang.Thread.join(Thread.java:767)
java.lang.Thread.join(Thread.java:728)
oracle.jdbc.driver.PhysicalConnection.pingDatabase(PhysicalConnection.java:5722)
oracle.jdbc.driver.PhysicalConnection.isValid(PhysicalConnection.java:10225)
oracle.jdbc.driver.PhysicalConnection.isValid(PhysicalConnection.java:10197)
oracle.jdbc.OracleConnectionWrapper.isValid(OracleConnectionWrapper.java:1376)
:::::::::::::::::

Additional details
- This issue is consistent under load.
- It recovers automatically after a long pause time at the pingDatabase API.
- There is no firewall between the Java/JDBC application server and database server.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.