[jira] [Updated] (DRILL-6966) JDBC Storgage Plugin fails to retrieve schema of Oracle DB

["Pritesh Maker (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pritesh Maker updated DRILL-6966:
---------------------------------
    Fix Version/s:     (was: 1.16.0)

> JDBC Storgage Plugin fails to retrieve schema of Oracle DB
> ----------------------------------------------------------
>
>                 Key: DRILL-6966
>                 URL: https://issues.apache.org/jira/browse/DRILL-6966
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JDBC
>    Affects Versions: 1.15.0
>            Reporter: jean-claude
>            Priority: Major
>             Fix For: Future
>
>
>  
> I've configured drill to use an JDBC storage plugin. My connection string is for an Oracle database. I have included the Oracle JDBC driver to my drill deployment.
>  
> The connection is established correctly. However the storage plugin fails to retrieve the schema of the database. 
>  
> The JDBC API provides two ways to get metadata about the database: getSchemas() and getCatalogs(). Depending on the database vendor one of those calls will return the information. The storage plugin correctly tries both calls. However I believe there is an issue when using Oracle.
>  
> The JDBC API claims that getSchemas() returns a set of two columns "table schema" and "table catalog" but in reality it just returns "table schema" as a first column of the result set. I believe this to be a bug. Has anyone tested the JDBC storage plugin against an Oracle DB and successfully retrieved the list of schema and tables? 
>  
> This article explains in details the issue in retrieving schema information using JDBC. [https://www.wisdomjobs.com/e-university/jdbc-tutorial-278/what-are-catalogs-and-schemas-1147.html]
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)