Skip to content

Instantly share code, notes, and snippets.

@kabronkline
Created April 13, 2015 01:35
Show Gist options
  • Select an option

  • Save kabronkline/e3b2a38bc788deb15b58 to your computer and use it in GitHub Desktop.

Select an option

Save kabronkline/e3b2a38bc788deb15b58 to your computer and use it in GitHub Desktop.
Tomcat JDBC Resilient Configuration
datasource.appdb.url=jdbc:hsqldb:hsql://localhost/xdb
datasource.appdb.user=sa
datasource.appdb.name=EmbeddedDatabaseConnectionPool
datasource.appdb.validationQuery=select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
datasource.appdb.testOnBorrow=true
datasource.appdb.testOnConnect=true
datasource.appdb.validationInterval=15000
datasource.appdb.maxActive=5
datasource.appdb.initialSize=1
datasource.appdb.logValidationErrors=true
@kabronkline

Copy link
Copy Markdown
Author

Using spring-boot and connecting to hsqldb. Connections are validated on initial connection and when they are borrowed (at most once every 15 seconds on borrow).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment