Java JDBC connection status

by

UPDATE

Oh, I just saw there is a new method available since 1.6:

java.sql.Connection.isValid(int timeoutSeconds):

Returns true if the connection has not been closed and is still valid.
The driver shall submit a query on the connection or use some other
mechanism that positively verifies the connection is still valid when
this method is called. The query submitted by the driver to validate
the connection shall be executed in the context of the current
transaction.

ORIGINAL ANSWER

Your best chance is to just perform a simple query against one table, e.g.:

select 1 from SOME_TABLE;

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Simulate Result set closing failed [closed]
  3. Multiple queries executed in java in single statement
  4. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  5. Using setDate in PreparedStatement
  6. Efficient way to do batch INSERTS with JDBC
  7. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  8. How do I get the size of a java.sql.ResultSet?
  9. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  10. How does a PreparedStatement avoid or prevent SQL injection?
  11. Variable column names using prepared statements
  12. MySQL and JDBC with rewriteBatchedStatements=true
  13. java.sql.SQLException: Exhausted Resultset
  14. How to enable logging for SQL statements when using JDBC
  15. Getting output from dbms_output.get_lines using JDBC
  16. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  17. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  18. JDBC ResultSet get columns with table alias
  19. Java – Can’t use ResultSet after connection close
  20. Timezones in SQL DATE vs java.sql.Date
  21. SQL prepared statement how to select via multiple possible menu selections?
  22. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  23. dll missing in JDBC
  24. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  25. Inserting null to an Integer column using JDBC
  26. How to use prepared statement for select query in Java?
  27. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  28. MS SQL Exception: Incorrect syntax near ‘@P0’
  29. MyBatis executing multiple sql statements in one go, is that possible?
  30. Searching between dates in SQL with JDBC?

Leave a Comment