Last active
January 8, 2017 10:47
-
-
Save selvait90/fbe15d832fadb3a3025b to your computer and use it in GitHub Desktop.
Pentaho Data Integration failed to connect PostgreSQL - sun.jdbc.odbc.JdbcOdbcDriver error
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| * Operating System | |
| OS X Yosemite 10.10.2 | |
| * Java Version | |
| $ java -version | |
| java version "1.7.0_76" | |
| Java(TM) SE Runtime Environment (build 1.7.0_76-b13) | |
| * JRE Version | |
| $ /Library/Internet\ Plug-Ins/JavaAppletPlugin.plugin/Contents/Home/bin/java -version | |
| java version "1.7.0_76" | |
| * PostgreSQL driver in pdi-ee/data-integration/lib | |
| postgresql-9.3-1100-jdbc4.jar |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| org.pentaho.di.core.exception.KettleDatabaseException: | |
| Error occurred while trying to connect to the database | |
| Driver class 'sun.jdbc.odbc.JdbcOdbcDriver' could not be found, make sure the 'PostgreSQL' driver (jar file) is installed. | |
| sun.jdbc.odbc.JdbcOdbcDriver | |
| at org.pentaho.di.core.database.Database.normalConnect(Database.java:417) | |
| at org.pentaho.di.core.database.Database.connect(Database.java:357) | |
| at org.pentaho.di.core.database.Database.connect(Database.java:310) | |
| at org.pentaho.di.core.database.Database.connect(Database.java:300) | |
| at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.createDatabaseNodes(XulDatabaseExplorerController.java:380) | |
| at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.init(XulDatabaseExplorerController.java:130) | |
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
| at java.lang.reflect.Method.invoke(Method.java:606) | |
| at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) | |
| at org.pentaho.ui.xul.impl.AbstractXulDomContainer.initialize(AbstractXulDomContainer.java:141) | |
| at org.pentaho.ui.xul.swt.SwtXulRunner$1.run(SwtXulRunner.java:67) | |
| at org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source) | |
| at org.eclipse.swt.widgets.Display.syncExec(Unknown Source) | |
| at org.pentaho.ui.xul.swt.SwtXulRunner.initialize(SwtXulRunner.java:64) | |
| at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerDialog.open(XulDatabaseExplorerDialog.java:92) | |
| at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.getSQL(TableInputDialog.java:552) | |
| at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.access$500(TableInputDialog.java:78) | |
| at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog$12.handleEvent(TableInputDialog.java:394) | |
| 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.Widget.sendEvent(Unknown Source) | |
| at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) | |
| at org.eclipse.swt.widgets.Widget.notifyListeners(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.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:435) | |
| at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) | |
| at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8797) | |
| at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) | |
| at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) | |
| 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.Widget.sendEvent(Unknown Source) | |
| at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) | |
| at org.eclipse.swt.widgets.Widget.notifyListeners(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:1316) | |
| at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7979) | |
| at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9310) | |
| at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) | |
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
| at java.lang.reflect.Method.invoke(Method.java:606) | |
| at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) | |
| Caused by: org.pentaho.di.core.exception.KettleDatabaseException: | |
| Driver class 'sun.jdbc.odbc.JdbcOdbcDriver' could not be found, make sure the 'PostgreSQL' driver (jar file) is installed. | |
| sun.jdbc.odbc.JdbcOdbcDriver | |
| at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:491) | |
| at org.pentaho.di.core.database.Database.normalConnect(Database.java:400) | |
| ... 50 more | |
| Caused by: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver | |
| at java.net.URLClassLoader$1.run(URLClassLoader.java:366) | |
| at java.net.URLClassLoader$1.run(URLClassLoader.java:355) | |
| at java.security.AccessController.doPrivileged(Native Method) | |
| at java.net.URLClassLoader.findClass(URLClassLoader.java:354) | |
| at java.lang.ClassLoader.loadClass(ClassLoader.java:425) | |
| at java.lang.ClassLoader.loadClass(ClassLoader.java:358) | |
| at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:466) | |
| ... 51 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment