求助:validateConnection false,
自己写了一个JDBC工具类,使用druid1.2.15版本,mysql-connector-java-8.0.30,使用junit进行测试可以使用,但是在web项目中启动报错如下面:
`
消息 Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: validateConnection false
描述 服务器遇到一个意外的情况,阻止它完成请求。
例外情况
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: validateConnection false
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:370)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:445)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
com.joker.demo8.dao.impl.UserDaoImpl.findAll(UserDaoImpl.java:17)
com.joker.demo8.service.impl.UserServiceImpl.findAll(UserServiceImpl.java:14)
com.joker.demo8.Servelet.UserListServlet.doGet(UserListServlet.java:18)
javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
根本原因。
java.sql.SQLException: validateConnection false
com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:632)
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:934)
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:930)
com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:102)
org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:370)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:445)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
com.joker.demo8.dao.impl.UserDaoImpl.findAll(UserDaoImpl.java:17)
com.joker.demo8.service.impl.UserServiceImpl.findAll(UserServiceImpl.java:14)
com.joker.demo8.Servelet.UserListServlet.doGet(UserListServlet.java:18)
javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
)
junit测试如下:
上图中都可以正确使用该工具类查找出正确的结果。
第一次发帖,还请各位大神指点。
问题已经解决:
解决方法,导入log4j解决,据说是druid有部分依赖log4j,不太懂