DBCP – validationQuery for different Databases

by

There is not only one validationQuery for all databases. On each database you have to use different validationQuery.

After few hours of googling and testing I have collected this table:

Database validationQuery notes

  • hsqldb – select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
  • Oracle – select 1 from dual
  • DB2 – select 1 from sysibm.sysdummy1
  • mysql – select 1
  • microsoft SQL Server – select 1 (tested on SQL-Server 9.0, 10.5 [2008])
  • postgresql – select 1
  • ingres – select 1
  • derby – values 1
  • H2 – select 1
  • Firebird – select 1 from rdb$database
  • MariaDb – select 1
  • Informix – select 1 from systables
  • Hive – select 1
  • Impala – select 1

I wrote about it on my blog – validation query for various databases.

In advance there is an example of class, which return validationQuery according to JDBC driver.

Or does anybody have better solution?

More Related Contents:

  1. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  2. Spring JDBC connection pool best practices
  3. How to establish a connection pool in JDBC?
  4. JDBC MySql connection pooling practices to avoid exhausted connection pool
  5. Closing JDBC Connections in Pool
  6. Where do I have to place the JDBC driver for Tomcat’s connection pool?
  7. Configure hibernate to connect to database via JNDI Datasource
  8. tomcat-dbcp vs commons-dbcp
  9. Connection pooling in java using HttpClient [closed]
  10. Correct way to implement HTTP Connection Pooling
  11. Need Code to create Connection Pool in java
  12. While you save a file in .csv,how to remove the hyphen in the file name
  13. How to call a SOAP web service on Android [closed]
  14. Android: How to stretch an image to the screen width while maintaining aspect ratio?
  15. Removing Java 8 JDK from Mac
  16. Is there an easy way to output two columns to the console in Java?
  17. How to find an available port?
  18. How to get response body using HttpURLConnection, when code other than 2xx is returned?
  19. Mock Instant.now() without using Clock into Constructor or without Clock Object
  20. How to implement setOnScrollListener in RecyclerView
  21. Where to close java PreparedStatements and ResultSets?
  22. How to handle requests that includes forward slashes (/)?
  23. LocalDate to java.util.Date and vice versa simplest conversion? [duplicate]
  24. Is gzip format supported in Spark?
  25. Java – Storing SQL statements in an external file [closed]
  26. How do I parse EDIFACT in Java? [closed]
  27. Encoded password does not look like BCrypt
  28. android.database.sqlite.SQLiteException: no such column
  29. EclipseLink 2.7.0 and JPA API 2.2.0 – signature mismatch
  30. Accessing Spring beans from a Tiles view (JSP)

Leave a Comment