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

Preview Issue - when non-Type4 JDBC driver is used.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.5
    • Data Preview, Patch Release
    • None
    • Hide

      1) import from Oracle BQT using an 'invalid' ojdbc14.jar driver (not type4). Make sure a valid driver has not been previously deployed.
      2) attempt to preview

      Show
      1) import from Oracle BQT using an 'invalid' ojdbc14.jar driver (not type4). Make sure a valid driver has not been previously deployed. 2) attempt to preview

      Encountered issue when trying to preview an Oracle source table in Designer. The preview failed with the following in the server log:

      10:39:44,877 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue0) TEIID30020 Processing exception for request N0JYBgYp8yw2.0 'TEIID30498 Capabilities for OracleSource were not avaialable. The command could not be planned properly.'. Originally QueryPlannerException PlanToProcessConverter.java:324. Enable more detailed logging to see the entire stacktrace.

      Upon debug, I found that the 'type' for my deployed oracle driver 'ojdbc14.jar' was not found on the server. The ojdbc14.jar was actually getting deployed in ExecutionAdmin, but the type was not present - because it was not a type4 jdbc driver.

      However, the preview proceeded (and failed) with the above exception.

      We need to investigate and handle this case more gracefully in Designer. The preview should not proceed - we should catch this error and display to the user - and stop the preview attempt.

        1. ojdbc14.jar
          1.48 MB

            mdrillin1@redhat.com Mark Drilling (Inactive)
            mdrillin1@redhat.com Mark Drilling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: