Repository: aurora Updated Branches: refs/heads/master de0029bb6 -> 6c539fe5a
Enable ping query to prevent use of invalid pooled connections. Bugs closed: AURORA-1596 Reviewed at https://reviews.apache.org/r/42979/ Project: http://git-wip-us.apache.org/repos/asf/aurora/repo Commit: http://git-wip-us.apache.org/repos/asf/aurora/commit/6c539fe5 Tree: http://git-wip-us.apache.org/repos/asf/aurora/tree/6c539fe5 Diff: http://git-wip-us.apache.org/repos/asf/aurora/diff/6c539fe5 Branch: refs/heads/master Commit: 6c539fe5ae47f7504691cb9469cacef9af88c2b0 Parents: de0029b Author: Zameer Manji <zma...@apache.org> Authored: Mon Feb 1 13:59:46 2016 -0800 Committer: Zameer Manji <zma...@apache.org> Committed: Mon Feb 1 13:59:46 2016 -0800 ---------------------------------------------------------------------- .../java/org/apache/aurora/scheduler/storage/db/DbModule.java | 5 +++++ 1 file changed, 5 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/aurora/blob/6c539fe5/src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java ---------------------------------------------------------------------- diff --git a/src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java b/src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java index 8b8c54a..a0344f7 100644 --- a/src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java +++ b/src/main/java/org/apache/aurora/scheduler/storage/db/DbModule.java @@ -225,6 +225,11 @@ public final class DbModule extends PrivateModule { bind(new TypeLiteral<Amount<Long, Time>>() { }).toInstance(SLOW_QUERY_LOG_THRESHOLD.get()); + // Enable a ping query which will prevent the use of invalid connections in the + // connection pool. + bindProperties(binder(), ImmutableMap.of("mybatis.pooled.pingEnabled", "true")); + bindProperties(binder(), ImmutableMap.of("mybatis.pooled.pingQuery", "SELECT 1;")); + // Exposed for unit tests. bind(TaskConfigManager.class); expose(TaskConfigManager.class);