Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

Druid Exception: Connection.clearWarnings

Shulou Source: shulou.com Published: 2022-06-03 04:21:22 10月02日 Update

Error message:

ERROR c.alibaba.druid.pool.DruidDataSource-recyle errorjava.sql.SQLException: Connection.clearWarnings cannot be called ona closed connectionat org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getSqlException (ExceptionMapper.java:271) at org.mariadb.jdbc.MariaDbConnection.clearWarnings (MariaDbConnection.java:1070) at com.alibaba.druid.filter.FilterChainImpl.connection_clearWarnings (FilterChainImpl.java:165) at com.alibaba.druid.filter.FilterAdapter.connection_clearWarnings (FilterAdapter.java:771) at com.alibaba.druid.filter.FilterChainImpl. Connection_clearWarnings (FilterChainImpl.java:161) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.clearWarnings (ConnectionProxyImpl.java:108) at com.alibaba.druid.pool.DruidConnectionHolder.reset (DruidConnectionHolder.java:295) at com.alibaba.druid.pool.DruidDataSource.recycle (DruidDataSource.java:1662)

Question:

Spring.datasource.druid.initial-size=1spring.datasource.druid.min-idle=1spring.datasource.druid.max-active=20spring.datasource.druid.test-on-borrow=truespring.datasource.druid.stat-view-servlet.allow=truespring.datasource.druid.max-wait=60000

Solution:

Spring.datasource.druid.initial-size=1spring.datasource.druid.min-idle=1spring.datasource.druid.max-active=20spring.datasource.druid.test-on-borrow=falsespring.datasource.druid.test-while-idle=truespring.datasource.druid.validation-query=select'X'

Because of less configuration of this, so get the connection does not check, cry dizzy.

Blame yourself for being too young.

Spring.datasource.druid.validation-query=select'X'

Tags: Youth Information Solutions Solutions problems Inspection configuration Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information MySQL Huawei Microsoft macOS