Pantaho MySQL 8 connection error Driver class 'org.gjt.mm.mysql.Driver' could not be found

user_1073487 0
Viewed 5333

While upgrading ETL scripts for Mysql 5.8 to MySQL8 upgrade, as soon as I have updated the data-integration/lib jar to mysql-connector-java-8.0.xx.jar, it has started blowing with following error.

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

pentaho-data-integration pentaho mysql-8.0 mysql
6 Answers

I did spent lot of time debugging and finally concluded, two things, I hope this may save others time in similar situation.

Reason: There is hardcoded jdbc drive name in org.pentaho.di.core.database.MySQLDatabaseMeta, and it always returns org.gjt.mm.mysql.Driver which is removed and new Driver with name com.mysql.jdbc.Driver or com.mysql.cj.jdbc.Driver should be used.

Solutions Any of below should be done to resolve.

  1. Continue using the old jdbc jar.

  2. Modify the org.pentaho.di.core.database.MySQLDatabaseMeta below method, compile and place it in classes directory.

    public String getDriverClass()  {
if (getAccessType()==DatabaseMeta.TYPE_ACCESS_ODBC)
{
    return "sun.jdbc.odbc.JdbcOdbcDriver";
}
else
{
    return "com.mysql.cj.jdbc.Driver";
}   }

  3. Use the Generic database connection, then you can specify the driver class yourself. (Based on @Cyrus comment.)

Pentaho open bug reference.

user_10734870

Could you please try to add both jars in

data-integration/lib

As I did, I have added the lastest jar of 5.x i.e mysql-connector-java-5.1.48.jarand the same version mine is 8.0.19 so i have added mysql-connector-java-8.0.19.jar i copied into location data-integration/lib .

After the test its working fine now.

user_117441700

MySQL driver for version 8 changed the class name. Therefore, you must set it as a Generic connection instead, and use com.mysql.jdbc.Driver as the class.

user_35934980

I have fixed the issue by replacing mysql-connector-java-5.1.42-bin.jar with mysql-connector-java-5.1.44.jar

Reference

user_63185140

I was working with pdi 9.1, all I did to get rid of this error was to copy these two jar files in the data-integration\lib:

mysql-connector-java-5.1.49.jar
mysql-connector-java-5.1.49-bin.jar

The link to the zip folder is mentioned in the above comments

Restart your spoon! And that's it.

user_109642800

i just to use Pentaho version 9.1 - 9.1.0.0-324 and mysql-connector-java-8.0.25

1- Make sure the Pentaho is not running.

2- Download the mysql connector at the link below.(https://mvnrepository.com/artifact/mysql/mysql-connector-java)

3- Copy the .jar file (mysql-connector-java-8.0.25.jar) and paste it in your Lib folder:

Example: C:....\pentaho-data-integration\lib

4- Execute Pentaho (Spoon.bat)

user_45768260
Related