Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Pentaho report designer- cassadra connection issue

  1. #1
    Join Date
    Sep 2017
    Posts
    2

    Default Pentaho report designer- cassadra connection issue

    Hi,

    I am trying to use pentaho report designer tool with cassandra. I am unable to connect to casssandra DB.
    I have copied cassandra driver jar /usr/local/report-designer/lib/jdbc path.
    I have used JDBC driver from : https://github.com/zhicwu/cassandra-jdbc-driver
    Below are the connection parameters -
    In Database Connection -
    Connection Name : cassandra
    Connection Type : Generic database
    Access : Naive
    Custom Connection URL : jdbc:cassandraatabase=apsea_cas_data;Port=9042;Server=127.0.0.1;
    Custom Driver Class Name : com.github.cassandra.jdbc.CassandraDriver


    Error :
    Error connecting to database [cassandra] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class com.github.cassandra.jdbc.CassandraDriver)
    com/google/common/base/Splitter




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class com.github.cassandra.jdbc.CassandraDriver)
    com/google/common/base/Splitter


    org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
    org.pentaho.di.core.database.Database.connect(Database.java:315)
    org.pentaho.di.core.database.Database.connect(Database.java:277)
    org.pentaho.di.core.database.Database.connect(Database.java:267)
    org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
    org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
    java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
    java.awt.Dialog.show(Dialog.java:1084)
    java.awt.Component.show(Component.java:1671)
    java.awt.Component.setVisible(Component.java:1623)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234)
    org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open(XulDatabaseDialog.java:237)
    org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$EditDataSourceAction.actionPerformed(ConnectionPanel.java:162)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6533)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    java.awt.Component.processEvent(Component.java:6298)
    java.awt.Container.processEvent(Container.java:2236)
    java.awt.Component.dispatchEventImpl(Component.java:4889)
    java.awt.Container.dispatchEventImpl(Container.java:2294)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
    java.awt.Container.dispatchEventImpl(Container.java:2280)
    java.awt.Window.dispatchEventImpl(Window.java:2746)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
    java.awt.EventQueue$4.run(EventQueue.java:731)
    java.awt.EventQueue$4.run(EventQueue.java:729)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
    java.awt.Dialog.show(Dialog.java:1084)
    java.awt.Component.show(Component.java:1671)
    java.awt.Component.setVisible(Component.java:1623)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    org.pentaho.reporting.ui.datasources.jdbc.ui.SimpleJdbcDataSourceDialog.performConfiguration(SimpleJdbcDataSourceDialog.java:152)
    org.pentaho.reporting.ui.datasources.jdbc.SimpleJdbcDataSourcePlugin.performEdit(SimpleJdbcDataSourcePlugin.java:70)
    org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:79)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.AbstractButton.doClick(AbstractButton.java:376)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6533)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    java.awt.Component.processEvent(Component.java:6298)
    java.awt.Container.processEvent(Container.java:2236)
    java.awt.Component.dispatchEventImpl(Component.java:4889)
    java.awt.Container.dispatchEventImpl(Container.java:2294)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
    java.awt.Container.dispatchEventImpl(Container.java:2280)
    java.awt.Window.dispatchEventImpl(Window.java:2746)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
    java.awt.EventQueue$4.run(EventQueue.java:731)
    java.awt.EventQueue$4.run(EventQueue.java:729)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:82)


    Hostname :
    Port : 1521
    Database name :



    Kindly Let me know , where I am going wrong.

    Thanks and Regards,
    Arunima Singh

  2. #2
    Join Date
    Sep 2017
    Posts
    2

    Exclamation Pentaho report designer - cassandra connection error

    Hi,

    I am trying to use pentaho report designer tool with cassandra. I am unable to connect to casssandra DB.
    I have copied cassandra driver jar /usr/local/report-designer/lib/jdbc path.
    I have used JDBC driver from : https://github.com/zhicwu/cassandra-jdbc-driver
    Below are the connection parameters -
    In Database Connection -
    Connection Name : cassandra
    Connection Type : Generic database
    Access : Naive
    Custom Connection URL : jdbc:cassandraatabase=apsea_cas_data;Port=9042;Server=127.0.0.1;
    Custom Driver Class Name : com.github.cassandra.jdbc.CassandraDriver


    Error :
    Error connecting to database [cassandra] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class com.github.cassandra.jdbc.CassandraDriver)
    com/google/common/base/Splitter




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class com.github.cassandra.jdbc.CassandraDriver)
    com/google/common/base/Splitter


    org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
    org.pentaho.di.core.database.Database.connect(Database.java:315)
    org.pentaho.di.core.database.Database.connect(Database.java:277)
    org.pentaho.di.core.database.Database.connect(Database.java:267)
    org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
    org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:498)
    org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
    java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
    java.awt.Dialog.show(Dialog.java:1084)
    java.awt.Component.show(Component.java:1671)
    java.awt.Component.setVisible(Component.java:1623)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234)
    org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open(XulDatabaseDialog.java:237)
    org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$EditDataSourceAction.actionPerformed(ConnectionPanel.java:162)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6533)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    java.awt.Component.processEvent(Component.java:6298)
    java.awt.Container.processEvent(Container.java:2236)
    java.awt.Component.dispatchEventImpl(Component.java:4889)
    java.awt.Container.dispatchEventImpl(Container.java:2294)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
    java.awt.Container.dispatchEventImpl(Container.java:2280)
    java.awt.Window.dispatchEventImpl(Window.java:2746)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
    java.awt.EventQueue$4.run(EventQueue.java:731)
    java.awt.EventQueue$4.run(EventQueue.java:729)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
    java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
    java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
    java.awt.Dialog.show(Dialog.java:1084)
    java.awt.Component.show(Component.java:1671)
    java.awt.Component.setVisible(Component.java:1623)
    java.awt.Window.setVisible(Window.java:1014)
    java.awt.Dialog.setVisible(Dialog.java:1005)
    org.pentaho.reporting.ui.datasources.jdbc.ui.SimpleJdbcDataSourceDialog.performConfiguration(SimpleJdbcDataSourceDialog.java:152)
    org.pentaho.reporting.ui.datasources.jdbc.SimpleJdbcDataSourcePlugin.performEdit(SimpleJdbcDataSourcePlugin.java:70)
    org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed(AddDataFactoryAction.java:79)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    javax.swing.AbstractButton.doClick(AbstractButton.java:376)
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
    javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    java.awt.Component.processMouseEvent(Component.java:6533)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    java.awt.Component.processEvent(Component.java:6298)
    java.awt.Container.processEvent(Container.java:2236)
    java.awt.Component.dispatchEventImpl(Component.java:4889)
    java.awt.Container.dispatchEventImpl(Container.java:2294)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
    java.awt.Container.dispatchEventImpl(Container.java:2280)
    java.awt.Window.dispatchEventImpl(Window.java:2746)
    java.awt.Component.dispatchEvent(Component.java:4711)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
    java.awt.EventQueue.access$500(EventQueue.java:97)
    java.awt.EventQueue$3.run(EventQueue.java:709)
    java.awt.EventQueue$3.run(EventQueue.java:703)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
    java.awt.EventQueue$4.run(EventQueue.java:731)
    java.awt.EventQueue$4.run(EventQueue.java:729)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:82)


    Hostname :
    Port : 1521
    Database name :



    Kindly Let me know , where I am going wrong.

    Thanks and Regards,
    Arunima Singh

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.