[teiid-issues] [JBoss JIRA] (TEIID-2318) Powerhub driver not working with Teiid

[Tanmoy Palit (JIRA)]

Tanmoy Palit created TEIID-2318:
-----------------------------------

             Summary: Powerhub driver not working with Teiid
                 Key: TEIID-2318
                 URL: https://issues.jboss.org/browse/TEIID-2318
             Project: Teiid
          Issue Type: Bug
          Components: JDBC Driver
    Affects Versions: 7.7
         Environment: Windows Vista 64 bit
            Reporter: Tanmoy Palit
            Assignee: Steven Hawkins
            Priority: Blocker


Powerhub drvier which is com.lgc.dam.phs.client.jdbc.PhsJDBCDriver, is a custom JDBC driver from Landmark.
Connection string looks like the following:
jdbc:scwapi:<server_name>;<powerhub_user>;<passwd>;<database_instance><database_name;<username>;<dbpasswd>

Getting the following error when Teiid Designer is used to consume the underlying database:
Error:
Unexpected exception while calling com.lgc.dam.phs.client.jdbc.PhsJDBCDatabaseMetaData.getTableTypes() and processing results on Acceptance PowerExplorer.CDSPROD

Here is the complete stack trace for the error:

java.lang.NullPointerException

          at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportMetadataPage.initializeInTransaction(JdbcImportMetadataPage.java:313)

          at com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportMetadataPage.setVisible(JdbcImportMetadataPage.java:238)

          at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1260)

          at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1239)

          at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1228)

          at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

          at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1226)

          at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:915)

          at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:428)

          at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)

          at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)

          at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

          at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

          at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

          at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

          at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)

          at org.eclipse.jface.window.Window.open(Window.java:801)

          at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:150)

          at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:277)

          at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:293)

          at org.eclipse.core.commands.Command.executeWithChecks(Command.java:476)

          at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)

          at org.eclipse.ui.internal.handlers.HandlerService.executeCommand(HandlerService.java:169)

          at org.eclipse.ui.internal.handlers.SlaveHandlerService.executeCommand(SlaveHandlerService.java:241)

          at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)

          at org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:171)

          at org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:97)

          at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168)

          at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

          at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

          at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

          at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

          at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

          at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

          at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

          at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)

          at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)

          at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)

          at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)

          at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

          at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)

          at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

          at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)

          at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

          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.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)

          at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)

          at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

          at org.eclipse.equinox.launcher.Main.main(Main.java:1386)


 Squrriel SQL Client successfully connects to metadata and executes queries to this Powerhub data source using same PhsJDBC driver



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira