Pentaho

 View Only

 Pentaho connection to MySql error

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Carlos Andiazabal's profile image
Carlos Andiazabal posted 03-14-2020 04:12

Dear team

 

This is Carlos from Milan (Italy). Could you help me, please?

 

From Pentaho when I click on button "Test Database Connection" it visualizes:

 

-----------------------------------------------------------------------------------------------------------------------------------

 

Error connecting to database [test] :org.pentaho.di.core.exception.KettleDatabaseException: 

 

Error occurred 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 occurred 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

 

-----------------------------------------------------------------------------------------------------------------------------------

 

It's evident that the problem is MySql connector.

 

- I downloaded mysql-connector-java-8.0.19.zip from MySql site

 

- unzipped it

 

- The only file .jar present is: mysql-connector-java-8.0.19.jar (in my opinion it should be 

 

mysql-connector-java-8.0.19-bin.jar but it's not present)

 

- I copied it on my data-integration\Lib but the problem remains.

 

Have you got any suggestion?

 

I'd really appreciate your feedback!

 

Best regards

 

Carlos


#PentahoDataIntegrationPDI
#Kettle
#Pentaho
Sergio Ribeiro's profile image
Sergio Ribeiro posted 03-17-2020 12:15

(note that this is the same answer that I posted in the other post with the same title)

 

Hello @Carlos Andiazabal​​,

 

You don't refer the Pentaho's version you're using...

At the JDBC drivers reference page (9.0) it's stated that, for MySQL, «Version 5.1.x is the most recent version supported».

There's a link to get the most recent connector (5.1.48) in that same location.

 

Regards,

 

Sérgio Ribeiro

Porto - Portugal.

 

Andrew Cave's profile image
Andrew Cave posted 03-19-2020 04:14

Hi Carlos. I've had success connecting to MySQL 8 using mysql-connector-java-5.1.47.jar

 

As I recall , Oracle changed the driver class name, but Pentaho has it hard-coded in. There is a current JIRA ticket to get it updated.

Carlos Andiazabal's profile image
Carlos Andiazabal posted 03-20-2020 17:58

That's was the problem. I solved it!!

Thanks a lot Andrew!

Carlos

Related Content