mysql-connector-java和MySQL兼容问题：Caused by: java.sql.SQLException: Unknown system variable 'language'

搭建的老框架：

spring 4 + Mybatis 3 + MySql(老服务器版本：5.0.8)

报错截图：

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown system variable 'language')

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown system variable 'language')

 

原因: 由于mysql-connector-java包用的版本是 5.1.36，测试服务器上面安装是MySql(老服务器版本：5.0.8)。

原来：

<dependency>  
    <groupId>mysql</groupId>  
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.36</version>
</dependency>

修改后版本：

<dependency>  
    <groupId>mysql</groupId>  
    <artifactId>mysql-connector-java</artifactId>  
    <version>5.0.8</version>
</dependency>

后测试成功。。。。。