Skip to content

Instantly share code, notes, and snippets.

@jrichardsz

jrichardsz/sql connection validation snippets - java.md

Last active December 23, 2024 15:18
Show Gist options
  • Save jrichardsz/702346ef7e26cd3118bbdc2c49e2bc3d to your computer and use it in GitHub Desktop.
Save jrichardsz/702346ef7e26cd3118bbdc2c49e2bc3d to your computer and use it in GitHub Desktop.
Download ZIP
sql connection validation snippets
Raw
sql connection validation snippets - java.md

Java

C3P0

https://stackoverflow.com/a/30523273/3957754

DBCP

setValidationQuery(String validationQuery)

https://commons.apache.org/proper/commons-dbcp/api-2.4.0/org/apache/commons/dbcp2/PoolableConnectionFactory.html#setValidationQuery-java.lang.String-

Query validation of all db engines

https://stackoverflow.com/a/10684260/3957754

Disadvantages

  • The only disadvantage is that some milliseconds are added to the response time.
    • In background and not direct user flows, this could not be a problem

Advantages

  • The application can connect to the database automatically
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment