Dbvis MySQL Server version for the right syntax to use near ' OPTION Sql_select_limit=default ' on line 1

Transferred from: http://www.cnblogs.com/_popc/p/4053593.html

Today, when using the database query tool Dbvis to link the MySQL database, we find that the SQL statements are executed with the following error:

Later thought should be the MySQL driver package version is not the cause, how you and I like, is also the problem, then now know what is going on.

My version is as follows:

Workaround:

Go to the MySQL website to download the latest JAR driver package and update on the line.

url:http://dev.mysql.com/downloads/connector/j/

Select Platform, download (mysql-connector-java-5.1.33.tar.gz)

Last update to the Dbvis jar package to the appropriate directory on the line, delete the original, restart Dbvis startup, will automatically detect and load using:

The jar package directory is as follows: D:\Program Files\dbvis\dbvis_windows_8_0_9\dbvisualizer-8.0.9\jdbc\mysql

Tools-->driver Manager---> left to find MySQL-driven directory, update on the line

The following is the address of the latest MySQL driver jar package:

Http://pan.baidu.com/s/1m2NE2

Dbvis MySQL Server version for the right syntax to use near ' OPTION Sql_select_limit=default ' on line 1