An error occurred while kettle connected to the MySQL database.

Environment:

Kettle: Kettle-Spoon version stable release-4.3.0

MySQL: MySQL Server 5.5.

Database connection information:

Test the database connection.

 

 

Error connecting database [MySql-1]: org. pentaho. Di. Core. Exception. kettledatabaseexception:

Erroccured while trying to connect to the database

 

Predictionwhile loading class

Org. gjt. Mm. MySQL. Driver

 

Org. pentaho. Di. Core. Exception. kettledatabaseexception:

Erroccured while trying to connect to the database

 

Predictionwhile loading class

Org. gjt. Mm. MySQL. Driver

 

 

Atorg. pentaho. Di. Core. database. database. normalconnect (database. Java: 368)

At org. pentaho. Di. Core. database. database. Connect (database. Java: 317)

Atorg. pentaho. Di. Core. database. database. Connect (database. Java: 279)

Atorg. pentaho. Di. Core. database. database. Connect (database. Java: 269)

Atorg. pentaho. Di. Core. database. databasefactory. getconnectiontestreport (databasefactory. Java: 86)

Atorg. pentaho. Di. Core. database. databasemeta. testconnection (databasemeta. Java: 2464)

Atorg. pentaho. UI. database. event. datahandler. testdatabaseconnection (datahandler. Java: 533)

Atsun. Reflect. nativemethodaccessorimpl. invoke0 (native method)

Atsun. Reflect. nativemethodaccessorimpl. Invoke (unknown source)

Atsun. Reflect. delegatingmethodaccessorimpl. Invoke (unknown source)

Atjava. Lang. Reflect. method. Invoke (unknown source)

Atorg. pentaho. UI. XUL. impl. abstractxuldomcontainer. Invoke (abstractxuldomcontainer. Java: 329)

Atorg. pentaho. UI. XUL. impl. abstractxulcomponent. Invoke (abstractxulcomponent. Java: 139)

Atorg. pentaho. UI. XUL. impl. abstractxulcomponent. Invoke (abstractxulcomponent. Java: 123)

Atorg. pentaho. UI. XUL. SWT. tags. swtbutton. Access $500 (swtbutton. Java: 26)

Atorg. pentaho. UI. XUL. SWT. tags. swtbutton $4. widgetselected (swtbutton. Java: 119)

Atorg. Eclipse. SWT. Widgets. typedlistener. handleevent (unknown source)

Atorg. Eclipse. SWT. Widgets. eventtable. sendevent (unknown source)

Atorg. Eclipse. SWT. Widgets. widget. sendevent (unknown source)

Atorg. Eclipse. SWT. Widgets. display. rundeferredevents (unknown source)

Atorg. Eclipse. SWT. Widgets. display. readanddispatch (unknown source)

Atorg. Eclipse. jface. Window. Window. runeventloop (window. Java: 820)

Atorg. Eclipse. jface. Window. Window. Open (window. Java: 796)

Atorg. pentaho. UI. XUL. SWT. tags. swtdialog. Show (swtdialog. Java: 378)

Atorg. pentaho. UI. XUL. SWT. tags. swtdialog. Show (swtdialog. Java: 304)

Atorg. pentaho. Di. UI. Core. database. Dialog. xuldatabasedialog. Open (xuldatabasedialog. Java: 115)

Atorg. pentaho. Di. UI. Core. database. Dialog. databasedialog. Open (databasedialog. Java: 62)

Atorg. pentaho. Di. UI. Spoon. Delegates. spoondbdelegate. editconnection (spoondbdelegate. Java: 88)

At org. pentaho. Di. UI. Spoon. Spoon. doubleclickedintree (spoon. Java: 2792)

Atorg. pentaho. Di. UI. Spoon. Spoon. Access $1900 (spoon. Java: 310)

Atorg. pentaho. Di. UI. Spoon. Spoon $24. widgetdefaselecselected (spoon. Java: 5275)

Atorg. Eclipse. SWT. Widgets. typedlistener. handleevent (unknown source)

At org. Eclipse. SWT. Widgets. eventtable. sendevent (unknownsource)

Atorg. Eclipse. SWT. Widgets. widget. sendevent (unknown source)

Atorg. Eclipse. SWT. Widgets. display. rundeferredevents (unknown source)

Atorg. Eclipse. SWT. Widgets. display. readanddispatch (unknown source)

At org. pentaho. Di. UI. Spoon. Spoon. readanddispatch (spoon. Java: 1183)

Atorg. pentaho. Di. UI. Spoon. Spoon. Start (spoon. Java: 6968)

Atorg. pentaho. Di. UI. Spoon. Spoon. Main (spoon. Java: 567)

Atsun. Reflect. nativemethodaccessorimpl. invoke0 (native method)

At sun. Reflect. nativemethodaccessorimpl. Invoke (unknownsource)

Atsun. Reflect. delegatingmethodaccessorimpl. Invoke (unknown source)

Atjava. Lang. Reflect. method. Invoke (unknown source)

Atorg. pentaho. commons. launcher. launcher. Main (launcher. Java: 134)

Causedby: org. pentaho. Di. Core. Exception. kettledatabaseexception:

Predictionwhile loading class

Org. gjt. Mm. MySQL. Driver

 

Atorg. pentaho. Di. Core. database. database. connectusingclass (database. Java: 423)

Atorg. pentaho. Di. Core. database. database. normalconnect (database. Java: 352)

... 43 more

Causedby: Java. Lang. classnotfoundexception: org. gjt. Mm. MySQL. Driver

Atjava.net. urlclassloader $ 1.run( unknown source)

Atjava.net. urlclassloader $ 1.run( unknown source)

Atjava. Security. accesscontroller. doprivileged (native method)

At java.net. urlclassloader. findclass (unknownsource)

Atjava. Lang. classloader. loadclass (unknown source)

Atjava. Lang. classloader. loadclass (unknown source)

At java. Lang. Class. forname0 (nativemethod)

At java. Lang. Class. forname (unknownsource)

At org. pentaho. Di. Core. database. database. connectusingclass (database. Java: 414)

... 44 more

 

Host Name: 192.168.2.1

Port 3306

Database Name: Test

 

 

Baidu cannot be asked about Internal Affairs, but Google cannot be asked about foreign affairs. Ask.

 

Put the corresponding MySQL driver package (mysql-connector-java-5.1.15-bin.jar) under kettle Directory: Data-integration \ libext \ JDBC.

 

The connection test is passed again.