java HikariCP丢失连接

Question

我有一个更老的使用：

• Spring MVC（4.0.6版本）

• Spring数据jpa（1.7.0.RELEASE）

• JDBC（1.3.1）

• 希卡里（2.5.1）

  我们注意到一些联系离开了游泳池，再也没有回来。我已经启用了连接日志记录，我们正在试图找出为什么这些连接永远不会回到池中。同时，是否有任何方式可以告诉Hikari放弃/更换连接？似乎侵蚀连接的调用是一个简单的JPA“findOne（UUID）”查找

谢谢你的帮助

编辑

2017-02-24 15:12:12,328 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - nGenDbPool - configuration:
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - allowPoolSuspension.............false
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - autoCommit......................true
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - catalog.........................null
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - connectionInitSql...............null
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - connectionTestQuery............."SELECT 1"
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - connectionTimeout...............30000
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - dataSource......................null
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - dataSourceClassName.............null
2017-02-24 15:12:12,332 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - dataSourceJNDI..................null
2017-02-24 15:12:12,333 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - dataSourceProperties............{password=<masked>}
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - driverClassName................."net.sourceforge.jtds.jdbc.Driver"
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - healthCheckProperties...........{}
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - healthCheckRegistry.............null
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - idleTimeout.....................600000
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - initializationFailFast..........true
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - isolateInternalQueries..........false
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - jdbc4ConnectionTest.............false
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - jdbcUrl........................."jdbc:jtds:sqlserver://my-server/myDB;appName={context_info};prepareSQL=0;sendStringParametersAsUnicode=false"
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - leakDetectionThreshold..........5000
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - maxLifetime.....................1800000
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - maximumPoolSize.................40
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - metricRegistry..................null
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - metricsTrackerFactory...........null
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - minimumIdle.....................40
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - password........................<masked>
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - poolName........................"nGenDbPool"
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - readOnly........................false
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - registerMbeans..................false
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - scheduledExecutorService........null
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - threadFactory...................null
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - transactionIsolation............"TRANSACTION_READ_UNCOMMITTED"
2017-02-24 15:12:12,334 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - username........................"myLogin"
2017-02-24 15:12:12,335 | DEBUG | UNKNOWN_USER | com.zaxxer.hikari.HikariConfig - validationTimeout...............5000
2017-02-24 15:12:12,336 | INFO  | UNKNOWN_USER | com.zaxxer.hikari.HikariDataSource - nGenDbPool - Started.