[已解决] mysql8 Could not get JDBC Connection
问题描述、简单贴下报错信息### Error querying database.Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedExce...
·
问题描述、简单贴下报错信息
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
### The error may exist in mappers/BizzStepMapper.xml
### The error may involve utry.iusher.dao.BizzStepMapper.selectByBizzId
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)] with root cause
java.lang.NullPointerException
at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3303)
at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1987)
主要问题还是在 Could not get JDBC Connection
我在网上试过一些方法、但没啥效果、贴出来给大家参考参考把...
1、注意jdbc.properties中不能有空格,如果你是从网上直接拷贝过来的,留意下
2、注意jdbc.properties中的key变量和databases.xml中配置是否相同
比如: jdbc.properties中的
"jdbc.userName = root"
在databases.xml却引用错误了
<property name="username" value="${jdbc.user}" />
3、注意jdbc.properties资源文件是否被加载
4、注意jdbc.properties中的key是否和jvm中的环境变量起冲突了
我的问题是出在 mysql的驱动上了 --------> mysql:mysql-connector-java:5.1.29
这个驱动对于mysql8来讲,不管用,所以卡了我一下午...唉...也是能力有限啊
我试着重新安装了一个mysql5.7版本,顺利跑通
至于mysql8应该用哪个驱动,我也没花时间去找,我是直接降了mysql的版本,等周末有时间的时候我再补充下吧....
更多推荐
已为社区贡献2条内容
所有评论(0)