Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Table output with MySQL

  1. #1

    Default Table output with MySQL

    Hi,

    I want to use the table output to put data into a mysql database.

    However it will not allow me to do field mapping and when I press the SQL button I get this error:

    Name:  SQL error.PNG
Views: 50
Size:  22.1 KB

    Does anyone know how to fix this?

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    It looks like you cannot connect to the database.
    Have you tested your connection?
    -- Mick --

  3. #3

    Default

    Hi Mick,

    Yes I have tested the connection and it says that the connection is OK.

    I have downloaded the most recent version of the J connector and now I still can't do field mapping but when I press SQL is asks if I want to edit the table.

    Name:  new.jpg
Views: 50
Size:  20.1 KB

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

    Default

    So long, and thanks for all the fish.

  5. #5
    Join Date
    Mar 2016
    Posts
    1

    Default

    Obviously not what you're looking for but I had problems with mysql5.6 too, everything worked fine since I downgraded to mysql5.5 though.

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.