Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Error disconnecting from database

  1. #1

    Question Error disconnecting from database

    What could cause this?
    Thanks

    PDI CE 4.3.0
    MySQL 5.6.6m9 (DEV)
    Windows XP Pro 32-bit OS


    INFO 02-09 18:00:40,136 - _etl_stage1 - Finished reading query, closing connect
    ion.
    ERROR 02-09 18:00:40,151 - LoadListings - Errors detected!
    ERROR 02-09 18:00:40,167 - CTC - Error disconnecting from database:


    Error disconnecting from database 'CTC'
    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=D
    EFAULT' at line 1


    ERROR 02-09 18:00:40,198 - CTC - org.pentaho.di.core.exception.KettleDatabaseExc
    eption:
    Error disconnecting from database 'CTC'
    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=D
    EFAULT' at line 1


    at org.pentaho.di.core.database.Database.closeConnectionOnly(Database.ja
    va:602)
    at org.pentaho.di.core.database.Database.disconnect(Database.java:569)
    at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dispose(Di
    mensionLookup.java:1657)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:79)
    at java.lang.Thread.run(Unknown Source)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have a
    n error in your SQL syntax; check the manual that corresponds to your MySQL serv
    er version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at
    line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

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

    Default

    MySQL complains about a syntax error.
    Test your statement in MySQL Workbench.
    If it passes there for good, tell how and where you entered the statement in PDI.

    What do you expect from that particular statement, anyway?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2013
    Posts
    19

    Default

    2archi:
    Use latest driver and all will be ok:
    http://dev.mysql.com/downloads/connector/j/
    Last edited by Kamapcuc; 04-09-2013 at 06:49 AM.

  4. #4
    Join Date
    Apr 2015
    Posts
    1

    Cool Resolved

    Quote Originally Posted by Kamapcuc View Post
    2archi:
    Use latest driver and all will be ok:
    http://dev.mysql.com/downloads/connector/j/
    Thanks for help!

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.