Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save asd1245dss/ad2f3782b59160477c3b59de6b262cdb to your computer and use it in GitHub Desktop.
Save asd1245dss/ad2f3782b59160477c3b59de6b262cdb to your computer and use it in GitHub Desktop.
Tomcat 关闭jdbc的正确姿势
经过摸索,我解决了上面的警告。
对于第二个警告,我把pom.xml中的JDBC 修改为provided,然后再tomcat的./lib/下增加对应的jar。
对于第一个警告,我的解决方案是:实现ServletContextListener,然后再contextDestroyed()方法中添加如下代码:
Enumeration drivers = DriverManager.getDrivers();
while (drivers.hasMoreElements()) {
Driver driver = drivers.nextElement();
try {
DriverManager.deregisterDriver(driver);
logger.info(String.format("deregistering jdbc driver: %s", driver));
} catch (SQLException e) {
e.printStackTrace();
logger.error(String.format("deregistering jdbc driver: %s", driver));
}
}
最后在web.xml中注册自己的监听器,问题解决。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment