Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: MYSQL Error with CDE 7.1

  1. #1
    Join Date
    Jun 2017
    Posts
    4

    Default MYSQL Error with CDE 7.1

    Hi guys,

    I've just downloaded the new CDE and I'm trying to connect it to a mysql database.

    The challenge I'm having is when I create a new connection, it does the test fine. It is when I get to the select tables that I get in to trouble.

    I add the table I want and select the fact table, and push "Finish". The next screen tells me that is processing, but gets stuck.

    The catalina.log displays the following error;

    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

    I'm on a Mac system and the mysql version is 5.7.18.

    Can you guys help me with this one?

    Thanks

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    Are you sure you're using the correct jdbc driver?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3
    Join Date
    Jun 2017
    Posts
    4

    Default

    Hi Pedro,

    Thanks for coming back to me.

    So to answer your question, the jdbc drive is the one that comes with the community version and it says "mysql-connector-java-5.1.17.jar".

    The version of the Mysql I have is 5.7.18. So not sure that
    this is the problem.

    I've tried to download the latest library from mysql, which is "
    mysql-connector-java-5.0.8-bin.jar" and I still get the same error.

    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

    I hope this is what you were asking, but if not, please let me know.

    Regards

  4. #4
    Join Date
    Nov 2009
    Posts
    688

    Default

    The latest driver is 5.1.42. You can download that version here : https://dev.mysql.com/downloads/connector/j/

  5. #5
    Join Date
    Jun 2017
    Posts
    4

    Default

    Hi guys,

    Thanks for the help. It is now working with the latest drivers.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.