Wednesday, February 19, 2014

Pentaho Common Errors : Driver class 'org.gjt.mm.mysql.Driver' could not be found

Error Message
Error connecting to database [MySQLDev] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
org.gjt.mm.mysql.Driver

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
org.gjt.mm.mysql.Driver

 at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)
 at org.pentaho.di.core.database.Database.connect(Database.java:353)
 at org.pentaho.di.core.database.Database.connect(Database.java:306)

 

 Resolution
 Pentaho version : PDI 5.0.2
OS                      : Linux CentOS release 6.2

1) Download latest MySQL jdbc connector.

http://dev.mysql.com/downloads/connector/j/


Download platform independent TAR archive for Linux OS.
ZIP Archive can be used for Windows.

2) Copy jar file to folder.

  • Locate tar file.
           [root@localhost Downloads]# ls
           mysql-connector-java-5.1.29.tar.gz
           [root@localhost Downloads]#


  • Unzip the file using following command.
            [root@localhost Downloads]# tar -zxvf mysql-connector-java-5.1.29.tar.gz

  • Copy file to folder pentaho/design-tools/data-integration/lib/
            cp mysql-connector-java-5.1.29-bin.jar /opt/pentaho/design-tools/data-integration/lib/

 3) Restart Spoon.







9 comments:

  1. Copy file to folder pentaho/design-tools/data-integration/libext/JDBC

    ReplyDelete
  2. Cara, Muito obrigado, deu certo. Vlw
    Ramito Brasil.

    ReplyDelete
  3. Thanks for the post, I am techno savvy. I believe you hit the nail right on the head. I am highly impressed with your blog. It is very nicely explained. Your article adds best knowledge to our Java Online Training from India. or learn thru Java Online Training from India Students.

    ReplyDelete
  4. Senorita awaits how did you resolve?

    ReplyDelete
  5. Ya copié el archivo jar a la carpeta lib y aún así no hace la conexión, ayudaaa!!!

    ReplyDelete