Tomcat停止时为了防止内存泄漏，JDBC驱动程序被强制取消注册

1、问题

我的Tomcat版本是8.5，数据源用的是Druid，当把Tomcat停止时候，报错如图：

提取其中报错信息：

15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [squirrel] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [squirrel] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [squirrel] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
 java.lang.Object.wait(Native Method)
 java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
 com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:64)
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 java.lang.Thread.run(Thread.java:748)

大概意思：

web应用程序注册了JDBC驱动程序[com.alibaba.druid.proxy.DruidDriver]。
但是当web应用程序被停止时，无法取消注册。
为了防止内存泄漏，JDBC驱动程序被强制取消注册。
web应用程序似乎启动了一个名为[connection cleanup thread]的线程，但未能停止它。

2、解决方案

手动配置监听器，用来在Tomcat关闭时取消注册JDBC驱动程序，并将线程停止。需要做两件事：
1、编写自定义监听侦

package com.ldu.util;

/**
 * @Description 监听侦：用于解决tomcat停止出现内存泄漏。
 * @Author ICHENY
 */
 
import com.mysql.jdbc.AbandonedConnectionCleanupThread;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MyContextListener implements ServletContextListener {

    @Override
    public void contextInitialized(ServletContextEvent arg0) {
        System.out.println("webService start");
    }

    @Override
    public void contextDestroyed(ServletContextEvent arg0) {
        System.out.println("webService stop");
        try {
            while(DriverManager.getDrivers().hasMoreElements()) {
                DriverManager.deregisterDriver(DriverManager.getDrivers().nextElement());
            }
            System.out.println("jdbc Driver close");
            AbandonedConnectionCleanupThread.shutdown();
            System.out.println("clean thread success");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

2、在web.xml中注册监听侦

<!--监听侦-->
<listener>
	<listener-class>com.ldu.util.MyContextListener</listener-class>  
</listener>

3、运行结果

参考博客:https://blog.51cto.com/11364212/2134469?cid=712360