Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mysql JDBC/ODBC connection error(s)

  1. #1
    Join Date
    May 2013

    Default Mysql JDBC/ODBC connection error(s)

    Hi i know this is a common issue that it saves putting the 'mysql-connector-java-5.1.25-bin.jar' driver into 'C:\Archivos de programa\pentaho\design-tools\data-integration\libext\JDBC'.
    But in my case this doesn't solves it. I tried so many variants, put it on 'libext', 'lib'... always the error message was:

    Exception while loading class

    I think this error became of missing path or something...

    I tried too to make a new database connection vía ODBC, and this way was succesfull. And then I tried to make a Catalog connection via ODBC, but new error message appears:
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][Administrador de controladores ODBC] The name of the data source is too long

    I'm using Kettle SpoonStable release 4.4.0 on windows XP, my dsn odbc name is 'pordsn'. Mysql version is 5.1.41.
    Environment: CLASSPATH=.;C:\Archivos de programa\Java\jdk1.7.0_05;C:\Archivos de programa\pentaho\design-tools\data-integration\libext\JDBC
    JAVA_HOME=C:\Archivos de programa\Java\jdk1.7.0_05
    PENTAHO_HOME=C:\Archivos de programa\pentaho
    PENTAHO_INSTALLED_LICENSE_PATH=C:\Archivos de programa\pentaho\.installedLicenses.xml
    PENTAHO_JAVA_HOME=C:\Archivos de programa\Java\jdk1.7.0_05

    Thanks for help

  2. #2
    Join Date
    May 2013


    well finally I have solved this problem... I had installed both full and open source pdi versions in the same directory. I uninstalled the full version and all works fine. Thanks for listening/reading me and I hope this can help somebody

Tags for this Thread

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.