org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for

错误样式:

 

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction;

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long)

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException:

报错环境:

SSM增删改查练习项目报错

解决方案:

1. 检查连接数据库driver,user,password,url有没有写错的

2. 检查使用的数据库连接驱动包是否和本机的MySQL版本匹配

3. 检查Spring,SpringMVC,MyBatis配置文件关于数据库方面的配置是否正确

(一般都是这几个错误导致的,我一项一项排查下来的)