MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'
Options
![Paul_Masurel](https://us.v-cdn.net/6038231/uploads/userpics/H9ZWBZB81Z9A/nLALCDJ2XWXVM.jpeg)
Paul_Masurel
Registered Posts: 6 ✭✭✭✭✭
When running a mysql query through JDBC driver I get the following error.
check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'
check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'
Tagged:
Answers
-
It seems that this issue could come from a too old MySQL JDBC driver jar. From what I can see, it seems that this issue was fixed in mysql-connector-java 5.1.22.
Does upgrading fix the issue ? -
Yes! Thank you so much!