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.
Gracias!! :D
ReplyDeleteDidnot work for me. !
ReplyDeleteCan you suggest any other solution
ReplyDeleteCopy file to folder pentaho/design-tools/data-integration/libext/JDBC
ReplyDeleteCara, Muito obrigado, deu certo. Vlw
ReplyDeleteRamito Brasil.
dancok
ReplyDeleteSenorita awaits how did you resolve?
ReplyDeleteYa copié el archivo jar a la carpeta lib y aún así no hace la conexión, ayudaaa!!!
ReplyDelete