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

Joel Bernstein edited comment on SOLR-8502 at 2/6/16 7:26 PM:
--------------------------------------------------------------

Attaching a screenshot with a working connection. All I did was restart 
DbVisualizer and the connection started working. 

I'll move on committing the remaining open tickets. I'll also create a new 
ticket to implement setMaxRows() on the Statement. This is the only error I see 
in the debug window and it will be extremely useful in ensuring users don't 
select entire result sets. The implementation will simply tack on a limit 
clause to the end of the SQL statement if it doesn't exist.

After this work is done I'll close out this ticket and add SOLR-8502 to 
CHANGES.txt for 6.0.


was (Author: joel.bernstein):
Attaching a screenshot with a working connection. All I did was restart 
DbVisualizer and the connection started working. 

I'll move on committing the remaining open tickets. I'll also create a new 
ticket to implement setMaxRows() on the Statement. This is the only error I see 
in the debug window and it will be extremely useful in ensuring users don't 
select entire result sets. The implementation will simply take on a limit 
clause to the end of the SQL statement if it doesn't exist.

After this work is done I'll close out this ticket and add SOLR-8502 to 
CHANGES.txt for 6.0.

> Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
> -----------------------------------------------------------------
>
>                 Key: SOLR-8502
>                 URL: https://issues.apache.org/jira/browse/SOLR-8502
>             Project: Solr
>          Issue Type: Improvement
>          Components: SolrJ
>    Affects Versions: Trunk
>            Reporter: Kevin Risden
>              Labels: jdbc
>             Fix For: Trunk
>
>         Attachments: connection-screen-shot.png, connection-working!.png, 
> driver-setup.png, screenshot-1.png, screenshot-2.png, screenshot-3.png, 
> screenshot-4.png
>
>
> Currently when trying to connect to Solr with the JDBC driver with a SQL 
> client the driver must implement more methods and metadata to allow 
> connections. This JIRA is designed to act as an umbrella for the JDBC changes.
> An initial pass from a few months ago is here: 
> https://github.com/risdenk/lucene-solr/tree/expand-jdbc. This needs to be 
> broken up and create patches for the related sub tasks.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

Reply via email to