How to troubleshoot a database connection?

Question

Java

In fact, I need to carry out the following actions:
Connecting, disconnecting and searching for signs of life in the database.
The question is how it is done in hibernate.

Answer 1

In JDBC4, the driver does this by implementing the Connection#isValid() method.
Earlier versions use (at least in connection pool libraries) validation queries like SELECT 1;
By the way, I'm not sure that hibernate checks connections. Most likely this is usually done by pools.