Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: mySQL - Unknown character set index for field / Kettle versions

  1. #1
    Join Date
    Nov 1999
    Posts
    459

    Default mySQL - Unknown character set index for field / Kettle versions

    Hi all,

    the following (interesting) problem has been described:

    ODBC driver to mySQL: all is o.k.

    JDBC driver to mySQL:
    - Kettle 2.2.2: on some tables no rows where returned, no error is given
    - Kettle 2.3: on some tables the following error raises:

    2006/05/30 11:40:25 - prokas_joy_jdbc - ERROR : Error disconnecting from database:
    2006/05/30 11:40:25 - prokas_joy_jdbc - ERROR :
    2006/05/30 11:40:25 - prokas_joy_jdbc - ERROR : Error comitting connection
    2006/05/30 11:40:25 - prokas_joy_jdbc - ERROR : Unknown character set index for field '8224' received from server.
    or:
    2006/05/30 11:40:51 - prokas_joy_jdbc - ERROR : Unknown character set index for field '334' received from server.

    When the query is limited to some rows there is no problem.

    So it seems there are some fields in certain rows that makes this trouble.

    The exception source is here: http://www.kickjava.com/src/com/mysq...ction.java.htm
    Method: getCharsetNameForIndex()

    We already used different JDBC mySQL drivers: the same behavior.

    What are the changes to Kettle that makes this behavior different?
    Is this a Kettle issue or mySQL?
    Does someone has a circumvention or solution?

    Thanks in advance,
    Jens

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: mySQL - Unknown character set index for field / Kettle versions

    Hi Jens,

    It's a specific MySQL problem. Other drivers automatically convert from Unicode (UTF-8) to the database codepage.

    It probably came with the new 3.1.12 JDBC driver. The solution to the codepage problem seems to be to feed extra options in the JDBC URL. (useUnicode=true&characterEncoding=...)

    This is not yet possible at the moment.
    So you're forced to use a generic URL for the time being.
    However, I'm adding an "extra options" tab to the database dialog today or tomorrow.

    All the best,

    Matt

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default RE: mySQL - Unknown character set index for field / Kettle versions

    Hi Matt,

    I saw you already started to change this - just for completeness I added a Change Request and assigned it to you: [# 2407] mySQL - Unknown character set index for field

    Since it is not a blocker it is not time critical. The circumvention is to use ODBC at this time ;-)

    All the best,
    Jens

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.