Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: MySQl-Connector-java problem

  1. #1

    Default MySQl-Connector-java problem

    every time when i click on "Get fields to change" in the icon "Select values" I face the error:

    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

    some say it's the problem of mysql-connector-java jar file.
    I am using PDI 5.0.1
    jdk: 7.0
    Mysql-connector-java 5.0.8

    someone knows the problem? there is no problem when testing the mysql connection. thanks in advance

  2. #2

    Default

    Alright!! I find that mysql-connection-java 5.1.29 works with PDI 5.0.1

  3. #3
    Join Date
    Feb 2016
    Posts
    4

    Default

    I have the same problem of #nickaquisio

    whene I try MySQL-connector-java 5.0.8 can't check columns of tables
    whene try MSql-connector-java 5.1.29 I can't success connexion

    I use PDI 5.0.1

    Any help please !

  4. #4
    Join Date
    Aug 2011
    Posts
    360

    Default

    What is your MySQL version? And java?
    And what means cant success connection?

  5. #5
    Join Date
    Feb 2016
    Posts
    4

    Default

    jdk1.7.0_09
    version nde MySQL : 5.6.12

  6. #6
    Join Date
    Aug 2011
    Posts
    360

    Default

    I have java7, pdi 5.4, MySQL 5.6 and connector-j 5.1.35 works Ok.
    Try with the last comnector version

  7. #7
    Join Date
    Feb 2016
    Posts
    4

    Default

    I think the last one is MySQL-connector 5.1.38 not works with pdi 5.0.1 !
    any solution?

  8. #8
    Join Date
    Feb 2016
    Posts
    4

    Default

    wih MySQL conncector 5.0.8 it's ok but can't check my columns .how can I solve this problem?

  9. #9
    Join Date
    Aug 2011
    Posts
    360

    Default

    That s weird, how did you configure your pdi connection?

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.