问题
在项目开发时,在本地正常运行,在测试环境中出现下面错误,吓尿了,顿时怀疑代码问题, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10' at line 1
网上google了一下说是mysql版本问题,在mysql5.6以下运行能正常执行,高版本出现异常。mysql5.6不再支持Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION.
原来是mysql版本问题,升级mysql-jdbc驱动到mysql-connector-java-5.1.25.jar后正常运行。
网络真是个好老师
参考:
stackoverflow
OPTION SQL_SELECT_LIMIT=DEFAULT java连接mysql错误