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 :

Unknown said...

Gracias!! :D

Senorita awaits... said...

Didnot work for me. !

Senorita awaits... said...

Can you suggest any other solution

Unknown said...

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

Ramon Gomes said...

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

Wright Petter said...

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.

muchsin al-hamied said...

dancok

Unknown said...

Senorita awaits how did you resolve?

predador x96 said...

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

Post a Comment

UA-46724997-1