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 | 4 months ago
  1. 0

    Spoon connectivity issue to PostgreSql

    Stack Overflow | 4 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

  5. 0

    Apache thrift transportaion TTransportException error while using Hive data integration using Pentaho

    Stack Overflow | 2 years ago | Jiten Patel
    org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) org.apache.thrift.transport.TTransportException</p> <pre><code>at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:573)
  6. 0

    Apache thrift transportaion TTransportException error while using Hive data integration using Pentaho

    Stack Overflow | 2 years ago | Jiten Patel
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database</p> <p>Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) org.apache.thrift.transport.TTransportException</p> <pre><code>at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)

    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.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