[
https://issues.apache.org/jira/browse/DRILL-8219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534282#comment-17534282
]
ASF GitHub Bot commented on DRILL-8219:
---------------------------------------
jnturton opened a new pull request, #2542:
URL: https://github.com/apache/drill/pull/2542
# [DRILL-8219](https://issues.apache.org/jira/browse/DRILL-8219): Handle
null catalog names returned by DB2 in storage-jdbc
## Description
DB2 is another DBMS in which clients must connect to a named database, not
just to the DBMS. A JDBC connection that does the same will receive a single
record containing a null string from a call to
Connection::getMetaData::getCatalogs. We need to ignore such a record in order
to query DB2 correctly.
## Documentation
N/A
## Testing
Install DB2 using the Docker container ibmcom/db2. Create a test schema and
table in the existing `testdb`. Configure a new Drill JDBC storage config to
connect to the DB2 `testdb` database. Test info schema queries and direct
querying of the test table.
> Handle null catalog names returned by DB2 in storage-jdbc
> ---------------------------------------------------------
>
> Key: DRILL-8219
> URL: https://issues.apache.org/jira/browse/DRILL-8219
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JDBC
> Affects Versions: 1.20.0
> Reporter: James Turton
> Assignee: James Turton
> Priority: Major
> Fix For: 2.0.0
>
>
> DB2 is another DBMS in which clients must connect to a named database, not
> just to the DBMS. A JDBC connection that does the same will receive a single
> record containing a null string from a call to
> Connection::getMetaData::getCatalogs. We need to ignore such a record in
> order to query DB2 correctly.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
