[
https://issues.apache.org/jira/browse/GEODE-6431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16772484#comment-16772484
]
ASF subversion and git services commented on GEODE-6431:
--------------------------------------------------------
Commit 9909626cc4d5a4ef3e17048195531e293353bffc in geode's branch
refs/heads/feature/GEODE-6431 from Jianxia Chen
[ https://gitbox.apache.org/repos/asf?p=geode.git;h=9909626 ]
GEODE-6431: Change default catalog and schema to null
Authored-by: Jianxia Chen <[email protected]>
> JDBC Connector should use NULL as default catalog and schema instead of empty
> string
> ------------------------------------------------------------------------------------
>
> Key: GEODE-6431
> URL: https://issues.apache.org/jira/browse/GEODE-6431
> Project: Geode
> Issue Type: Bug
> Components: extensions
> Reporter: Jianxia Chen
> Assignee: Jianxia Chen
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
>
> From the {{DatabaseMetaData.getTables(String catalog, String schemaPattern,
> String tableNamePattern, String[] types)}} Javadoc:
> https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[])
> "retrieves those without a catalog; null means that the catalog name should
> not be used to narrow the search"
> From the {{DatabaseMetaData.getSchemas(String catalog, String
> schemaPattern)}} javadoc:
>
> [https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas(java.lang.String,%20java.lang.String])
> {{catalog - a catalog name; must match the catalog name as it is stored in
> the database;"" retrieves those without a catalog; null means catalog name
> should not be used to narrow down the search.}}
> For example, for MySQL, if using empty string as default value for catalog
> and schema, {{DatabaseMetaData.getTables(String catalog, String
> schemaPattern, String tableNamePattern, String[] types)}} cannot return the
> expected table.
> Compared to ""(empty string), {{NULL}} is a better default value for catalog
> and schema.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
