#1 Unable to connect to Palo database

[Herman Darmawan]

Hi I tried to use the Palo Plugin.
I have verified that Palo server is runing.
I can run Excel and paste view for Database Demo and cube Sales.

However when I run kettle, I get this error when I create a new Palo connection and test the connection.
How to solve this problem?

Herman
----
Error connecting to database [PaloDemo] : java.lang.InstantiationException: plugin.palo.core.PaloHelper
java.lang.InstantiationException: plugin.palo.core.PaloHelper
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.di.core.database.DatabaseMeta.getDatabaseFactory(DatabaseMeta.java:2495)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2477)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1919)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1901)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:293)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(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.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:368)
at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:505)
at org.pentaho.di.ui.spoon.Spoon.newConnection(Spoon.java:6453)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
at org.pentaho.xul.swt.menu.PopupMenu.handleMenuEvent(PopupMenu.java:40)
at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(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:873)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5639)
at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5735)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)

[Nobody/Anonymous]

Logged In: NO

the palo test connection is not ok, but if you run any transformation that implies use palo elements the plugin is ok and you can get/set data