org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.postgresql.Driver) The connection attempt failed. org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.postgresql.Driver) The connection attempt failed. at org.pentaho.di.core.database.Database.normalConnect(Database.java:466)

Stack Overflow | Dex | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Spoon connectivity issue to PostgreSql

    Stack Overflow | 7 months ago | Dex
    org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.postgresql.Driver) The connection attempt failed. org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.postgresql.Driver) The connection attempt failed. at org.pentaho.di.core.database.Database.normalConnect(Database.java:466)
  2. 0

    using Pentaho Data Integration how to connect database via MariaDB

    Stack Overflow | 2 years ago
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.mariadb.jdbc.Driver) Could not connect to 20.0.1.93:3306 : Connection refused org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.mariadb.jdbc.Driver) Could not connect to 20.0.1.93:3306 : Connection refused at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
  3. 0

    I'm using biserver-ce-2.0.0.stable and aggregate-designer-ce-1.0.0.stable with Sybase ASA database. I have a problem with jndi connection in Aggregate Designer. My driver is in \aggregation-designer\drivers\ folder, my BI server is running, but when I try to connect to my database (data_9) this error appears. I'm doing the same with Kettle - there has not a problem with jndi connection. Error connecting to database [data_9] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Invalid JNDI connection data_9 : Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Invalid JNDI connection data_9 : Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial at org.pentaho.di.core.database.Database.normalConnect(Database.java:318) at org.pentaho.di.core.database.Database.connect(Database.java:267) at org.pentaho.di.core.database.Database.connect(Database.java:229) at org.pentaho.di.core.database.Database.connect(Database.java:219) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:54) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2368) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:464) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294) at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:517) at java.awt.Dialog$2.run(Dialog.java:545) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:543) at java.awt.Component.show(Component.java:1300) at java.awt.Component.setVisible(Component.java:1253) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214) at org.pentaho.aggdes.ui.form.controller.ConnectionController.loadDatabaseDialog(ConnectionController.java:235) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294) at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:517) at java.awt.Dialog$2.run(Dialog.java:545) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:543) at java.awt.Component.show(Component.java:1300) at java.awt.Component.setVisible(Component.java:1253) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214) at org.pentaho.aggdes.ui.form.controller.ConnectionController.showConnectionDialog(ConnectionController.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294) at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Invalid JNDI connection data_9 : Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial at org.pentaho.di.core.database.Database.initWithJNDI(Database.java:336) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:351) at org.pentaho.di.core.database.Database.normalConnect(Database.java:302) ... 57 more Hostname : Port : -1 Database name : data_9

    Pentaho BI Platform Tracking | 8 years ago | jeni markishka
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Invalid JNDI connection data_9 : Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettleDatabaseException

      Error connecting to database: (using class org.postgresql.Driver) The connection attempt failed. at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:579)

      at org.pentaho.di.core.database.Database.normalConnect()
    2. org.pentaho.di
      DatabaseMeta.testConnection
      1. org.pentaho.di.core.database.Database.normalConnect(Database.java:450)
      2. org.pentaho.di.core.database.Database.connect(Database.java:364)
      3. org.pentaho.di.core.database.Database.connect(Database.java:335)
      4. org.pentaho.di.core.database.Database.connect(Database.java:325)
      5. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)
      6. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2734)
      6 frames
    3. org.pentaho.ui
      DataHandler.testDatabaseConnection
      1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:591)
      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:313)
      2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
      3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
      4. org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)
      5. org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:137)
      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.di
      Spoon.newConnection
      1. org.pentaho.di.ui.xul.KettleDialog.show(KettleDialog.java:88)
      2. org.pentaho.di.ui.xul.KettleDialog.show(KettleDialog.java:55)
      3. org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)
      4. org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:60)
      5. org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:474)
      6. org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:461)
      7. org.pentaho.di.ui.spoon.Spoon.newConnection(Spoon.java:8805)
      7 frames
    9. 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
    10. org.pentaho.ui
      JfaceMenuitem$1.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
      2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
      3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
      4. org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43)
      5. org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106)
      5 frames
    11. JFace
      ActionContributionItem$5.handleEvent
      1. org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
      2. org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
      3. org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
      4. org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
      4 frames
    12. RWT
      Display.readAndDispatch
      1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      2. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      3. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      4 frames
    13. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1347)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7989)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9269)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:662)
      4 frames
    14. 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
    15. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
      1 frame