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/02/08 22:43:39 UTC

[jira] [Commented] (SOLR-8659) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer (phase 2)

    [ https://issues.apache.org/jira/browse/SOLR-8659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15137755#comment-15137755 ] 

Kevin Risden commented on SOLR-8659:
------------------------------------

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 SQL Clients like DBVisualizer (phase 2)
> ---------------------------------------------------------------------------
>
>                 Key: SOLR-8659
>                 URL: https://issues.apache.org/jira/browse/SOLR-8659
>             Project: Solr
>          Issue Type: Improvement
>          Components: SolrJ
>    Affects Versions: Trunk
>            Reporter: Kevin Risden
>
> 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. DbVisualizer and SquirrelSQL are two that testing can easily be done on.



--
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