org.gjt.mm.mysql.Driver

Pentaho BI Platform Tracking | Vicente Naranjo | 3 years ago
  1. 0

    Error connecting to database [rf_fpac] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.normalConnect(Database.java:366) at org.pentaho.di.core.database.Database.connect(Database.java:315) at org.pentaho.di.core.database.Database.connect(Database.java:277) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533) 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:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$1.widgetSelected(KettleDatabaseRepositoryDialog.java:198) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:320) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:75) at org.pentaho.di.ui.repository.RepositoriesHelper.newRepository(RepositoriesHelper.java:119) at org.pentaho.di.ui.repository.controllers.RepositoriesController.newRepository(RepositoriesController.java:272) 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:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$300(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:87) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.repository.controllers.RepositoriesController.show(RepositoriesController.java:194) at org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:102) at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6829) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6995) at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:8288) at org.eclipse.jface.window.Window.create(Window.java:426) at org.eclipse.jface.window.Window.open(Window.java:785) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8303) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580) 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:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Exception while loading class org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:421) at org.pentaho.di.core.database.Database.normalConnect(Database.java:350) ... 68 more Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:412) ... 69 more Hostname : FOOTPRINTS Port : 3306 Database name : facdb --------------------------------------------------------------------------------------------------------------------------------------------------- By reading some other issues I noticed that the jar file needs to be added to the libtex folder. However, I have done this and I still get the same error. Reading some other issues I've notice that you say it's not supported anymore that library. So what's the solution to solve this?

    Pentaho BI Platform Tracking | 3 years ago | Vicente Naranjo
    org.gjt.mm.mysql.Driver
  2. 0

    Error connecting to database [rf_fpac] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Exception while loading class org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.normalConnect(Database.java:366) at org.pentaho.di.core.database.Database.connect(Database.java:315) at org.pentaho.di.core.database.Database.connect(Database.java:277) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533) 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:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$1.widgetSelected(KettleDatabaseRepositoryDialog.java:198) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:320) at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:75) at org.pentaho.di.ui.repository.RepositoriesHelper.newRepository(RepositoriesHelper.java:119) at org.pentaho.di.ui.repository.controllers.RepositoriesController.newRepository(RepositoriesController.java:272) 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:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.swt.tags.SwtButton.access$300(SwtButton.java:26) at org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:87) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304) at org.pentaho.di.ui.repository.controllers.RepositoriesController.show(RepositoriesController.java:194) at org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:102) at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6829) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6995) at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:8288) at org.eclipse.jface.window.Window.create(Window.java:426) at org.eclipse.jface.window.Window.open(Window.java:785) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8303) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580) 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:134) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Exception while loading class org.gjt.mm.mysql.Driver at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:421) at org.pentaho.di.core.database.Database.normalConnect(Database.java:350) ... 68 more Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:412) ... 69 more Hostname : FOOTPRINTS Port : 3306 Database name : facdb --------------------------------------------------------------------------------------------------------------------------------------------------- By reading some other issues I noticed that the jar file needs to be added to the libtex folder. However, I have done this and I still get the same error. Reading some other issues I've notice that you say it's not supported anymore that library. So what's the solution to solve this?

    Pentaho BI Platform Tracking | 3 years ago | Vicente Naranjo
    org.gjt.mm.mysql.Driver
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.gjt.mm.mysql.Driver

      No message provided

      at org.pentaho.di.core.database.Database.normalConnect()
    2. org.pentaho.di
      DatabaseMeta.testConnection
      1. org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
      2. org.pentaho.di.core.database.Database.connect(Database.java:315)
      3. org.pentaho.di.core.database.Database.connect(Database.java:277)
      4. org.pentaho.di.core.database.Database.connect(Database.java:267)
      5. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
      6. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464)
      6 frames
    3. org.pentaho.ui
      DataHandler.testDatabaseConnection
      1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    5. org.pentaho.ui
      SwtButton$4.widgetSelected
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
      2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
      3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
      4. org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
      5. org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
      5 frames
    6. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    7. JFace
      Window.open
      1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
      2. org.eclipse.jface.window.Window.open(Window.java:796)
      2 frames
    8. org.pentaho.ui
      SwtDialog.show
      1. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
      2. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
      2 frames
    9. org.pentaho.di
      KettleDatabaseRepositoryDialog$1.widgetSelected
      1. org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
      2. org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
      3. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog$1.widgetSelected(KettleDatabaseRepositoryDialog.java:198)
      3 frames
    10. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    11. org.pentaho.di
      RepositoriesController.newRepository
      1. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:320)
      2. org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:75)
      3. org.pentaho.di.ui.repository.RepositoriesHelper.newRepository(RepositoriesHelper.java:119)
      4. org.pentaho.di.ui.repository.controllers.RepositoriesController.newRepository(RepositoriesController.java:272)
      4 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    13. org.pentaho.ui
      SwtButton$2.mouseUp
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
      2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
      3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
      4. org.pentaho.ui.xul.swt.tags.SwtButton.access$300(SwtButton.java:26)
      5. org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:87)
      5 frames
    14. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      2. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      4. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      5. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      5 frames
    15. JFace
      Window.open
      1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
      2. org.eclipse.jface.window.Window.open(Window.java:796)
      2 frames
    16. org.pentaho.ui
      SwtDialog.show
      1. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
      2. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
      2 frames
    17. org.pentaho.di
      Spoon.createContents
      1. org.pentaho.di.ui.repository.controllers.RepositoriesController.show(RepositoriesController.java:194)
      2. org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:102)
      3. org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6829)
      4. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6995)
      5. org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:8288)
      5 frames
    18. JFace
      Window.open
      1. org.eclipse.jface.window.Window.create(Window.java:426)
      2. org.eclipse.jface.window.Window.open(Window.java:785)
      2 frames
    19. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8303)
      2. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
      2 frames
    20. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    21. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      1 frame