This website uses cookies. By browsing this website, you consent to the use of cookies. Learn more.
OK
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:ย 
Join us, on May 27th, for an introduction to the new Dataiku Academy Learn 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
โ€Ž06-12-2015 07:07 PM
Yes! Thank you so much!
0 Kudos
Reply
Labels (1)
Labels