Tomcat下面一个应用,启动时报错:
java.sql.SQLException: Cannot create PoolableConnectionFactory
at com.syscanhc.service.util.DBConnection.getConnection(DBConnection.java:53)
at com.syscanhc.service.ServiceServlet.process(ServiceServlet.java:102)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.syscanhc.service.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
开始经为是驱动或Jar包的问题,折腾了好久都没搞定,后来发现其它几个应用都可以正常创建数据库连接池,就这个不行,才发现原来是这个应用对应的数据库用户被锁定了,立马进数据库,将该数据库账号解锁,问题得到解决~~