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

Pentaho BI Platform Tracking | jeni markishka | 8 years ago
  1. 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
  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

    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)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reproduction: - In Spoon 4.4 create a log table in a simple transformation (see attachment) - let it run in Spoon 4.4 - look at the execution history (refresh) and see one log line - Close Spoon 4.4 - Open Spoon 5.0 (on Windows, use SpoonConsole.bat to see the exception mentioned below) - it automatically opens the previous transformation - It opens the Execution history but this is empty The following exception is shown on the console: Unable to get rows of data from logging table test_dbx-log_table4_5_test org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list' at org.pentaho.di.core.database.Database.openQuery(Database.java:1610) [...] Note: - We added the fields EXECUTING_SERVER, EXECUTING_USER and CLIENT to the log table in 5.0 - I propose to make these fields disabled by default to keep compatible with previous log tables

    Pentaho BI Platform Tracking | 4 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_JOB, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, STARTDATE, ENDDATE, LOGDATE, DEPDATE, REPLAYDATE, LOG_FIELD, EXECUTING_SERVER, EXECUTING_USER, START_JOB_ENTRY, CLIENT FROM log_table4_5_test WHERE JOBNAME LIKE ? ORDER BY ID_JOB DESC Unknown column 'EXECUTING_SERVER' in 'field list'
  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

      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()
    2. org.pentaho.di
      DatabaseMeta.testConnection
      1. org.pentaho.di.core.database.Database.initWithJNDI(Database.java:336)
      2. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:351)
      3. org.pentaho.di.core.database.Database.normalConnect(Database.java:302)
      4. org.pentaho.di.core.database.Database.connect(Database.java:267)
      5. org.pentaho.di.core.database.Database.connect(Database.java:229)
      6. org.pentaho.di.core.database.Database.connect(Database.java:219)
      7. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:54)
      8. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2368)
      8 frames
    3. org.pentaho.ui
      DataHandler.testDatabaseConnection
      1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:464)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    5. org.pentaho.ui
      SwingButton$1$1.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
      2 frames
    6. Java RT
      Component.setVisible
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      5. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
      6. java.awt.Dialog$1.run(Dialog.java:517)
      7. java.awt.Dialog$2.run(Dialog.java:545)
      8. java.security.AccessController.doPrivileged(Native Method)
      9. java.awt.Dialog.show(Dialog.java:543)
      10. java.awt.Component.show(Component.java:1300)
      11. java.awt.Component.setVisible(Component.java:1253)
      11 frames
    7. org.pentaho.ui
      SwingDialog.show
      1. org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214)
      1 frame
    8. org.pentaho.aggdes
      ConnectionController.loadDatabaseDialog
      1. org.pentaho.aggdes.ui.form.controller.ConnectionController.loadDatabaseDialog(ConnectionController.java:235)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    10. org.pentaho.ui
      SwingButton$1$1.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
      2 frames
    11. Java RT
      Component.setVisible
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      5. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
      6. java.awt.Dialog$1.run(Dialog.java:517)
      7. java.awt.Dialog$2.run(Dialog.java:545)
      8. java.security.AccessController.doPrivileged(Native Method)
      9. java.awt.Dialog.show(Dialog.java:543)
      10. java.awt.Component.show(Component.java:1300)
      11. java.awt.Component.setVisible(Component.java:1253)
      11 frames
    12. org.pentaho.ui
      SwingDialog.show
      1. org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214)
      1 frame
    13. org.pentaho.aggdes
      ConnectionController.showConnectionDialog
      1. org.pentaho.aggdes.ui.form.controller.ConnectionController.showConnectionDialog(ConnectionController.java:313)
      1 frame
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    15. org.pentaho.ui
      SwingButton$1$1.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
      2 frames
    16. Java RT
      EventDispatchThread.run
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      5. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
      6. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
      7. java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
      7 frames