Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app

by

The easiest is to configure the connection pool to specify the query to be run to test the connection before it is passed to the application:

validationQuery="select 1 as dbcp_connection_test"
testOnBorrow=true

This same “connection validation” query can be run on other events. I’m not sure of the defaults for these:

testOnReturn=true
testWhileIdle=true

There are also configuration settings that limit the “age” of idle connections in the pool, which can be useful if idle connections are being closed at the server end.

minEvictableIdleTimeMillis
timeBetweenEvictionRunsMillis

http://commons.apache.org/dbcp/configuration.html

More Related Contents:

  1. Am I Using JDBC Connection Pooling?
  2. If two columns are 1 then make new column
  3. Can we use CONCAT and JOIN together in MySQL? [closed]
  4. Truncate all tables in a MySQL database in one command?
  5. Retrieving the last record in each group – MySQL
  6. Cast from VARCHAR to INT – MySQL
  7. Find distance between two points using latitude and longitude in mysql
  8. How to convert result table to JSON array in MySQL
  9. CROSS/OUTER APPLY in MySQL
  10. How to extract two consecutive digits from a text field in MySQL?
  11. Solution to “subquery returns more than 1 row” error
  12. Adding multiple columns AFTER a specific column in MySQL
  13. Storing SHA1 hash values in MySQL
  14. Downloading MySQL dump from command line
  15. DOUBLE vs DECIMAL in MySQL
  16. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  17. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  18. Terminating idle mysql connections
  19. int(11) vs. int(anything else)
  20. ALTER TABLE to add a composite primary key
  21. MySQL – How to select data by string length
  22. SQL Order By Count
  23. ColdFusion Parameterizing a Query
  24. How to select the first row for each group in MySQL?
  25. What to do when you need integers larger than 20 digits on mysql?
  26. How to update JSON data type column in MySQL 5.7.10?
  27. mysql: connection refused when trying to connect to localhost using remote IP
  28. True/False vs 0/1 in MySQL
  29. Mysql stored procedure don’t take table name as parameter
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment