Solutions to problems related to the Mysql JDBC driver version and Mysql version

I have not used Mysql for a long time. Yesterday, my friend had no problem with running a small project on my machine, but reported an internal server error (500) on his machine ), using QQ for Remote Assistance (too slow), it took me half a day to finally find the reason because Mysql5 was used on a friend's machine and the Connector/J 3.0 was used as the driver, finally, switch to the Connector/J 3.1 Driver to solve the problem.

The Mysql version corresponds to the Mysql JDBC driver version and has made such an error before! Go to the official Mysql website and check that Connector/J 5.1 has been released.

Connector/J 5.1 supports Mysql 4.1, Mysql 5.0, Mysql 5.1, and Mysql 6.0 alpha versions.

Connector/J 5.0 supports MySQL 4.1, MySQL 5.0 servers, and distributed transaction (XA ).

Connector/J 3.1 supports MySQL 4.1, MySQL 5.0 servers, and MySQL 5.0 distributed t distributed transaction (XA) support.

Connector/J 3.0 supports MySQL 3.x or MySQL 4.1.

Connector/J 5.1: http://dev.mysql.com/downloads/connector/j/5.1.html