[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2219) Preview Issue - when non-Type4 JDBC driver is used.

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 Attachments: ojdbc14.jar 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.