Pentaho

 View Only

 kettle connect mysql db?

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
huan zhuang's profile image
huan zhuang posted 11-21-2018 04:35

I use the kettle to connect the mysql database,the version of the kettle is 7.0 and the version of the mysql is 8.0.12. I have put the mysql-connector-java-8.0.12.jar in the lib folder. when I establish the database repository bu using the mysql database , it create a problem,the detail is as follows:

     错误连接数据库 [CESHI] : 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

I want to know how to solve it?


#PentahoDataIntegrationPDI
#Kettle
#Pentaho
Johan Hammink's profile image
Johan Hammink posted 11-21-2018 13:00

Did you restart kettle after you placed the driver in the lib folder?

Richard Azevedo's profile image
Richard Azevedo posted 11-22-2018 17:47

Hi all,

Try to use MariaDB JDBC Driver e choose Mariadb type connection, to connect Mysql 8.

I solved it, with this.

Regards

Diego Mainou's profile image
Diego Mainou posted 11-22-2018 22:11

Did you remove any old versions of the library?

huan zhuang's profile image
huan zhuang posted 11-23-2018 05:17

Thanks for your answer. T tried as your way.  I found that there isn't Mariadb type connection in kettle of version 7.0.

So I use kettle of version 7.1, and I download the mariadb-java-client-2.3.0.jar. It seems didn't work, can you tell me the version of kettle and MariaDB JDBC Driver you use. The error detail is as follows:

               org.pentaho.di.core.exception.KettleDatabaseException:

               Error occurred while trying to connect to the database

               Error connecting to database: (using class org.mariadb.jdbc.Driver)

               Unknown database 'dmpxt'

huan zhuang's profile image
huan zhuang posted 11-23-2018 05:18

yes. I have done this! But  it didn't work.

huan zhuang's profile image
huan zhuang posted 11-23-2018 05:18

yes. I have done this! But  it didn't work.

Diego Mainou's profile image
Diego Mainou posted 11-24-2018 10:57

Please post screenshot of the place where you dropped the library.

JOHN JOSEPH SPINETOLI's profile image
JOHN JOSEPH SPINETOLI posted 11-29-2018 13:19

Hi, i i've resolved the same problem installing the PDI MySql Plugin taken from Pentaho Marketplace ...

Related Content