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.







10 comments :

Azucena Orea said...

Gracias!! :D

Senorita awaits... said...

Didnot work for me. !

Senorita awaits... said...

Can you suggest any other solution

BOUHLEL MED KHALIL said...

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

Ramon Santos said...

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

mary Brown said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training in India . Nowadays Java has tons of job opportunities on various vertical industry.

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