We're excited to announce that we're launching the second installment of Dataiku Product Days Register Now

MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'

Paul_Masurel
Level 2
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
2 Replies
Clément_Stenac
Dataiker
Dataiker
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 ?
Paul_Masurel
Level 2
Author
Yes! Thank you so much!
0 Kudos

Labels

?
A banner prompting to get Dataiku DSS