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.2OS : 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.
mysql-connector-java-5.1.29.tar.gz
[root@localhost Downloads]#
- Unzip the file using following command.
- Copy file to folder pentaho/design-tools/data-integration/lib/
3) Restart Spoon.
9 comments :
Gracias!! :D
Didnot work for me. !
Can you suggest any other solution
Copy file to folder pentaho/design-tools/data-integration/libext/JDBC
Cara, Muito obrigado, deu certo. Vlw
Ramito Brasil.
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.
dancok
Senorita awaits how did you resolve?
Ya copié el archivo jar a la carpeta lib y aún así no hace la conexión, ayudaaa!!!
Post a Comment