Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table Output to MySQL5 creates "INSERT INTO" SQL syntax error

  1. #1
    Join Date
    Aug 2006
    Posts
    7

    Default Table Output to MySQL5 creates "INSERT INTO" SQL syntax error

    Hi,

    I use

    Spoon 2.3.0 and MySQL 5.0.45.
    DB-Connection is type MySQL Native(JDBC)

    A "Table Output" created the db-table properly, using the SQL-button.

    When starting the transformation to fill the table, I get an error

    "Error inserting row"
    "you have an error in your SQL syntax; check...MySQL.. near..

    The full logging says that Spoon fired this command:
    INSERT INTO dbname(col1,col2) VALUES (12, 'haha')

    And this is definitely wrong - the blank is missing after dbname.

    I verified this by copy/paste into SQL query browser - add a blank and it works!

    Is MySQL 5 special, does it need special settings somewhere or is it unsupported ?

    Regards

    Peter

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    I doubt whether you're right... I don't use Mysql, bug I know people who've given presentations using Kettle and MySQL and it would be strange that it wouldn't be supported. If you're sure raise a tracker at http://jira.pentaho.org

    BTW No backport will happen to 2.3.0 anymore... latest version is 2.5.0

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2006
    Posts
    7

    Default Re: problem gone

    posting the phenomene seems to cure it...

    I swear I spent hours on debugging - now it works.

    After 20 years in IT I stopped wondering about things like this...

    But to be sure I will step up to 2.5.0

    Thanks!

    Peter

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.