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
    • Environment:

      Windows Vista 64 bit

    • Steps to Reproduce:
      Hide

      This is not easy as PowerHub server and an underlying database is required. Also the client must have two jars: com_lgc_ph_client.jar and
      com_lgc_ph_common.jar. These jars allow clients (including JDBC
      and PowerExplorer) to talk to the PowerHub Server.

      Show
      This is not easy as PowerHub server and an underlying database is required. Also the client must have two jars: com_lgc_ph_client.jar and com_lgc_ph_common.jar. These jars allow clients (including JDBC and PowerExplorer) to talk to the PowerHub Server.
    • Bugzilla Update:
      Perform

      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. Includes.java
            5 kB
          2. JdbcCatalogImpl.java
            8 kB
          3. JdbcImportMetadataPage.java
            23 kB
          4. JdbcSchemaImpl.java
            7 kB
          5. JdbcTableImpl.java
            9 kB
          6. org.teiid.designer.jdbc.patch
            6 kB
          7. org.teiid.designer.jdbc.ui.patch
            1 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: