You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2019/01/11 19:59:00 UTC
[jira] [Updated] (DRILL-6966) JDBC Storgage Plugin fails to
retrieve schema of Oracle DB
[ https://issues.apache.org/jira/browse/DRILL-6966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-6966:
--------------------------------
Affects Version/s: 1.15.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
> Affects Versions: 1.15.0
> Reporter: jean-claude
> Priority: Major
>
>
> 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)