You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Kevin Risden (JIRA)" <ji...@apache.org> on 2016/03/10 15:44:40 UTC
[jira] [Comment Edited] (SOLR-8659) Improve Solr JDBC Driver to
support more SQL Clients
[ 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org