{"action":"closed","issue":{"url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/587","repository_url":"https://api.github.com/repos/brettwooldridge/HikariCP","labels_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/587/labels{/name}","comments_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/587/comments","events_url":"https://api.github.com/repos/brettwooldridge/HikariCP/issues/587/events","html_url":"https://github.com/brettwooldridge/HikariCP/issues/587","id":137391660,"number":587,"title":"connectionTestQuery empty and jdbc4ConnectionTest = false at the same time by default","user":{"login":"norbertpotocki","id":1217729,"avatar_url":"https://avatars.githubusercontent.com/u/1217729?v=3","gravatar_id":"","url":"https://api.github.com/users/norbertpotocki","html_url":"https://github.com/norbertpotocki","followers_url":"https://api.github.com/users/norbertpotocki/followers","following_url":"https://api.github.com/users/norbertpotocki/following{/other_user}","gists_url":"https://api.github.com/users/norbertpotocki/gists{/gist_id}","starred_url":"https://api.github.com/users/norbertpotocki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/norbertpotocki/subscriptions","organizations_url":"https://api.github.com/users/norbertpotocki/orgs","repos_url":"https://api.github.com/users/norbertpotocki/repos","events_url":"https://api.github.com/users/norbertpotocki/events{/privacy}","received_events_url":"https://api.github.com/users/norbertpotocki/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-29T22:04:08Z","updated_at":"2016-03-02T19:37:08Z","closed_at":"2016-03-02T19:37:07Z","body":"Hi,\r\n\r\nI have noticed that if you don't set up connectionTestQuery and use latest mysql driver both connectionTestQuery is empty and jdbc4ConnectionTest = false. Is that how it should be?\r\n\r\nI'm using version 2.4.2\r\n\r\n```\r\n2016-02-29 13:57:40.091 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : allowPoolSuspension.............false\r\n2016-02-29 13:57:40.091 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : autoCommit......................true\r\n2016-02-29 13:57:40.091 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : catalog.........................\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : connectionInitSql...............\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : connectionTestQuery.............\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : connectionTimeout...............5000\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : dataSource......................\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : dataSourceClassName.............\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : dataSourceJNDI..................\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : dataSourceProperties............{password=<masked>}\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : driverClassName.................\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : healthCheckProperties...........{}\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : healthCheckRegistry.............\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : idleTimeout.....................0\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : initializationFailFast..........true\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : isolateInternalQueries..........false\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : jdbc4ConnectionTest.............false\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : jdbcUrl.........................jdbc:mysql://localhost:3307/UserShard?logger=Slf4JLogger&profileSQL=true&gatherPerfMetrics=true&dumpQueriesOnException=true&logSlowQueries=true&traceProtocol=true\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : leakDetectionThreshold..........2000\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : maxLifetime.....................600000\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : maximumPoolSize.................1\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : metricRegistry..................HdrMetricRegistry@12608986\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : metricsTrackerFactory...........\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : minimumIdle.....................1\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : password........................<masked>\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : poolName........................UserShardPool:jdbc:mysql://localhost:3307/UserShard\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : readOnly........................false\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : registerMbeans..................false\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : scheduledExecutorService........\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : threadFactory...................\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : transactionIsolation............\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : username........................tools\r\n2016-02-29 13:57:40.092 DEBUG 54470 --- [           main] com.zaxxer.hikari.HikariConfig           : validationTimeout...............5000\r\n```"}}