This website uses cookies. By clicking OK, you consent to the use of cookies. Click Here to learn more about how we use cookies.
OK
Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Advanced Designer Learning Path is now live! Read More

MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'

Paul_Masurel
Level 2
‎06-12-2015 04:20 PM
MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'
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'
0 Kudos
Reply
2 Replies
Clément_Stenac
Dataiker
Dataiker
‎06-12-2015 05:33 PM
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 ?
Reply
Paul_Masurel
Level 2
Author
In response to Clément_Stenac
‎06-12-2015 07:07 PM
Yes! Thank you so much!
0 Kudos
Reply
Labels (1)
Labels
A banner prompting to get Dataiku DSS