Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: HELP with the get fields function

  1. #1
    Join Date
    Dec 2013
    Posts
    14

    Default HELP with the get fields function

    Hi everybody!

    Im using a Mysql conection and when I push the "get fields" button from the "select values" transformation, the next message appear:

    Unable to close prepared statement after determining SQL layout
    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

    Im using the new PDI 5.0.1 and I never had this problem with the previous version.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The OPTION keyword in SET OPTION SQL_SELECT_LIMIT=DEFAULT was deprecated since MySQL 5.1 and support was removed in 5.6.
    Are you sure you use a JDBC driver compatible with your MySQL version?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Dec 2013
    Posts
    14

    Default

    Thanks you very much marabu, that solved my problem I was using an old jdbc driver.

  4. #4

    Default

    Hi edgardlt:

    which version of the driver you used to solve the problem?
    my PDI: 5.0.1
    if i use mysql-connector-java 3.1.14 I have the same error you mentioned
    else if I use mysql-connector-java 5.0.8, i can't even succeed with the testing the connnection

Tags for this Thread

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.