Proxool连接池在reload web容器时出现HouseKeeper的空指针异常

Proxool连接池重启问题

最新推荐文章于 2020-09-07 14:49:26 发布

原创最新推荐文章于 2020-09-07 14:49:26 发布 · 129 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Web #Servlet #Tomcat #JVM #IDEA

DB_SQL 专栏收录该内容

12 篇文章

订阅专栏

本文介绍了解决Proxool连接池在Tomcat重启时出现空指针异常的方法。通过在Servlet的destroy()方法中调用ProxoolFacade.shutdown()来确保连接池正确关闭。

使用Proxool连接池，当在重启Tomcat容器时，出现

Exception in Thread "HouseKeeper" java.lang.NullPointerException

空指针异常错误。

原因是：

写道

This is because Proxool is not being shutdown properly. If the JVM stops then Proxool recognises that and shuts down gracefully, but if you redeploy Proxool into some environments (for example, a servlet container) then Proxool needs to be explicitly told so by calling ProxoolFacade.shutdown(). If you have a servlet container then you could put it in the servlet's destroy() method. Alternatively, use the ServletConfigurator to both configure and shutdown Proxool

解决方法如下：

1. 在Servlet的destroy()方法中显式地proxool关闭连接池：ProxoolFacade.shutdown();

public class ProxoolServlet extends HttpServlet { 
    public void init() throws ServletException { 
    } 

    public void destroy() { 
        ProxoolFacade.shutdown(); 
    } 

    public void doPost(HttpServletRequest request, HttpServletResponse response) throws 
        ServletException, IOException { 
        doGet(request,response); 
    } 
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws 
        ServletException, IOException { 
        
    } 

}

2. 将该Servlet配置到web.xml中：

  <servlet> 
    <servlet-name>proxoolServlet </servlet-name> 
    <servlet-class>xxx.ProxoolServlet</servlet-class> 
    <load-on-startup>1</load-on-startup> 
  </servlet>

3. OK