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
All community
This category
This board
Knowledge base
Users
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:
Browse
Discussions
Setup & Configuration
Using Dataiku DSS
Plugins & Extending Dataiku DSS
General Discussion
Job Board
Community Resources
Knowledge
Getting Started
Knowledge Base
Documentation
Academy
Course Catalog
Learning Paths
Certifications
Academy Discussions
Community Programs
User Groups
User Groups Resources
Dataiku Neurons
Upcoming User Events
Past User Events
Online Events
Community Conundrums
Banana Data Podcast
What's New
Sign In
Advanced Designer Learning Path is now live!
Read More
Community
»
Discussions
»
Using Dataiku DSS
»
Options
Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page
MySQL server not compatible with 'OPTION SQL_SELECT_LIMIT=DEFAULT'
Paul_Masurel
Level 2
06-12-2015
04:20 PM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content
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
All discussion topics
Previous Topic
Next Topic
2 Replies
Clément_Stenac
Dataiker
06-12-2015
05:33 PM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content
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 ?
1
Kudo
Reply
Paul_Masurel
Level 2
Author
In response to
Clément_Stenac
06-12-2015
07:07 PM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content
Yes! Thank you so much!
0
Kudos
Reply
Post Reply
Labels
(1)
Labels
Labels:
SQL