Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1542

Powerhub driver not working with Teiid

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Won't Do
    • Affects Version/s: 7.7
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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

        Gliffy Diagrams

          Attachments

          1. org.teiid.designer.jdbc.ui.patch
            1 kB
          2. org.teiid.designer.jdbc.patch
            6 kB
          3. JdbcTableImpl.java
            9 kB
          4. JdbcSchemaImpl.java
            7 kB
          5. JdbcImportMetadataPage.java
            23 kB
          6. JdbcCatalogImpl.java
            8 kB
          7. Includes.java
            5 kB

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                tanmoypalit Tanmoy Palit
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: