[
https://issues.apache.org/jira/browse/SOLR-8659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15137755#comment-15137755
]
Kevin Risden edited comment on SOLR-8659 at 3/10/16 2:44 PM:
-------------------------------------------------------------
Some rough notes that should be added as subtasks for DbVisualizer:
* After connection, click on Database Info tab after double clicking on
connection name ensure that DB capabilities are correct - SOLR-8815
* After connection, click on Database Info tab after double clicking on
connection name should add add info about supported Keywords and Functions -
SOLR-8816
* After connection, click on Data Types tab after double clicking on connection
name should add info about data types - SOLR-8817
* After connecting, ResultSet is empty if double click on "DB" under connection
name then click on Tables tab. - SOLR-8818
* After connecting, NPE if double click on "DB" under connection name then
click on References tab. - SOLR-8819
* After connecting, ResultSet is empty if double click on "Table" under "DB"
then click on Tables tab. - SOLR-8820
* After connecting, NPE if double click on "DB" under "DB" then click on
References tab. - SOLR-8821
* Implement DatabaseMetaDataImpl.getPrimaryKeys(String catalog, String schema,
String table) - SOLR-8822
* Implement DatabaseMetaDataImpl.getColumns(String catalog, String
schemaPattern, String tableNamePattern, String columnNamePattern) - SOLR-8823
was (Author: risdenk):
Some rough notes that should be added as subtasks for DbVisualizer:
* After connection, click on Database Info tab after double clicking on
connection name ensure that DB capabilities are correct
* After connection, click on Database Info tab after double clicking on
connection name should add add info about supported Keywords and Functions
* After connection, click on Data Types tab after double clicking on connection
name should add info about data types
* After connecting, ResultSet is empty if double click on "DB" under connection
name then click on Tables tab.
* After connecting, NPE if double click on "DB" under connection name then
click on References tab.
* After connecting, ResultSet is empty if double click on "Table" under "DB"
then click on Tables tab.
* After connecting, NPE if double click on "DB" under "DB" then click on
References tab.
* Implement DatabaseMetaDataImpl.getPrimaryKeys("192.168.1.237:9983", "test",
"test")
* Implement DatabaseMetaDataImpl.getColumns("192.168.1.237:9983", "test",
"test", "%")
> Improve Solr JDBC Driver to support more SQL Clients
> ----------------------------------------------------
>
> Key: SOLR-8659
> URL: https://issues.apache.org/jira/browse/SOLR-8659
> Project: Solr
> Issue Type: Improvement
> Components: SolrJ
> Affects Versions: master
> Reporter: Kevin Risden
> Attachments:
> iODBC_Demo__Unicode__-_Connected_to__remotesolr__and_Attach_screenshot_-_ASF_JIRA.png
>
>
> SOLR-8502 was a great start to getting JDBC support to be more complete. This
> ticket is to track items that could further improve the JDBC support for more
> SQL clients and their features. A few SQL clients are:
> * DbVisualizer
> * SquirrelSQL
> * Apache Zeppelin (incubating)
> * IntelliJ database browser
> * ODBC clients like Excel/Tableau
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
