]
Barry LaFond reassigned TEIIDDES-2219:
--------------------------------------
Assignee: Barry LaFond (was: Mark Drilling)
Preview Issue - when non-Type4 JDBC driver is used.
---------------------------------------------------
Key: TEIIDDES-2219
URL:
https://issues.jboss.org/browse/TEIIDDES-2219
Project: Teiid Designer
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Data Preview
Affects Versions: 8.5
Reporter: Mark Drilling
Assignee: Barry LaFond
Fix For: 8.6
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.