1
How to fix Mysql database connection error with Pentaho
Error Connecting to database [School] :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
at org.pentaho.di.core.database.Database.normalConnect(Database.java:472) at org.pentaho.di.core.database.Database.connect(Database.java:370) at org.pentaho.di.core.database.Database.connect(Database.java:341) at org.pentaho.di.core.database.Database.connect(Database.java:331) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(Databasefactory.java:80) at org.pentaho.di.core.database.DatabaseMeta.testConnection(Databasemeta.java:2783) at org.pentaho.ui.database.Event.DataHandler.testDatabaseConnection(Datahandler.java:597) at sun.reflect..Nativemethodaccessorimpl.invoke0(Native Method) at sun.reflect..Nativemethodaccessorimpl.invoke(Unknown Source) at sun.reflect.Delegatingmethodaccessorimpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(Abstractxuldomcontainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(Abstractxulcomponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(Abstractxulcomponent.java:141) at org.pentaho.ui.xul.swt.tags.Swtbutton.access$500(Swtbutton.java:43) at org.pentaho.ui.xul.swt.tags.Swtbutton$4.widgetSelected(Swtbutton.java:137) at org.eclipse.swt.widgets.Typedlistener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.Eventtable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.di.ui.Xul.KettleDialog.show(Kettledialog.java:80) at org.pentaho.di.ui.Xul.KettleDialog.show(Kettledialog.java:47) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(Xuldatabasedialog.java:116) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(Databasedialog.java:60) at org.pentaho.di.ui.Spoon.delegates.Spoondbdelegate.newConnection(Spoondbdelegate.java:485) at org.pentaho.di.ui.Spoon.delegates.Spoondbdelegate.newConnection(Spoondbdelegate.java:472) at org.pentaho.di.ui.Spoon.Spoon.newConnection(Spoon.java:8788) at sun.reflect..Nativemethodaccessorimpl.invoke0(Native Method) at sun.reflect..Nativemethodaccessorimpl.invoke(Unknown Source) at sun.reflect.Delegatingmethodaccessorimpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(Abstractxuldomcontainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(Abstractxulcomponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(Abstractxulcomponent.java:141) at org.pentaho.ui.xul.jface.tags.Jfacemenuitem.access$100(Jfacemenuitem.java:43) at org.pentaho.ui.xul.jface.tags.Jfacemenuitem$1.run(Jfacemenuitem.java:106) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.Actioncontributionitem.handleWidgetSelection(Actioncobutionitem.java:545) at org.eclipse.jface.action.Actioncontributionitem.access$2(Actioncobutionitem.java:490) at org.eclipse.jface.action.Actioncontributionitem$5.handleEvent(Actioncobutionitem.java:402) at org.eclipse.swt.widgets.Eventtable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.Spoon.Spoon.readAndDispatch(Spoon.java:1366) at org.pentaho.di.ui.Spoon.Spoon.waitForDispose(Spoon.java:8022) at org.pentaho.di.ui.Spoon.Spoon.start(Spoon.java:9277) at org.pentaho.di.ui.Spoon.Spoon.main(Spoon.java:692) at sun.reflect..Nativemethodaccessorimpl.invoke0(Native Method) at sun.reflect..Nativemethodaccessorimpl.invoke(Unknown Source) at sun.reflect.Delegatingmethodaccessorimpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.Commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.di.core.Exception.Kettledatabaseexception: 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.connectUsingClass(Database.java:515) at org.pentaho.di.core.database.Database.normalConnect(Database.java:456) ... 57 more Caused by: java.lang.Classnotfoundexception: org.gjt.mm.mysql.Driver at java.net.Urlclassloader.findClass(Unknown Source) at java.lang.Classloader.loadClass(Unknown Source) at java.lang.Classloader.loadClass(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490) ... 58 more