純原生JAVA項目中，Druid作為MySQL連接池時(MySQL默認為8小時沒操作就斷開)，測試場景為10小時不進行任何查詢，就算配置了testWhileIdle=true，也不能保持連接，配置如下:

source.mysql.url=jdbc:mysql://127.0.0.1:3306/xxx

source.mysql.username=root

source.mysql.password=xxx

source.mysql.driver=com.mysql.jdbc.Driver

source.mysql.initialSize=10

source.mysql.minIdle=10

source.mysql.maxActive=100

source.mysql.maxWait=60000

source.mysql.timeBetweenEvictionRunsMillis=10000

source.mysql.minEvictableIdleTimeMillis=300000

source.mysql.validationQuery=select 1

source.mysql.testWhileIdle=true

source.mysql.testOnBorrow=false

source.mysql.testOnReturn=false

source.mysql.removeAbandoned=true

source.mysql.removeAbandonedTimeout=1800

source.mysql.logAbandoned=false

source.mysql.poolPreparedStatements=false

source.mysql.maxPoolPreparedStatementPerConnectionSize=20

source.mysql.filters=stat,wall

10小時后查詢，報：

java.sql.SQLException: The last packet successfully received from the server was 63,920,837 milliseconds ago. The last packet sent successfully to the server was 63,920,858 milliseconds ago.

總結

以上是生活随笔為你收集整理的druid不能close mysql连接_druid长时间无操作无法保持连接！！的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。