[jira] [Commented] (SOLR-8521) Add documentation for how to use Solr JDBC driver with SQL client like DB Visualizer

["Yonik Seeley (JIRA)" <ji...@apache.org>]

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

Yonik Seeley commented on SOLR-8521:
------------------------------------

It feels like this is where linear documentation (i.e. a produced PDF where you get/download everything) starts to diverge from non-linear (web/wiki)...
hundreds of pages of screenshots can be completely natural on on the latter, but not so much on the former.

Also
 - The systems connecting to solr may change versions as well
 - New systems may be added at any point and be applicable to multiple versions of Solr (it's not like we can document them all up-front)

Live documentation feels like the best fit for this.  Regardless of what Solr version people are using, it seems like they tend to go look at the latest version of cwiki anyway.  If that's the case, the question may just boil down to: do we want to put this somewhere on the wiki that doesn't get serialized to a PDF?

bq. That is correct the JDCB driver only works with the Parallel SQL feature.

How users will come to see it is: "I can use JDBC to talk to Solr" (and of course the language is SQL when using JDBC).  It will be seen as a first class feature, and the fact that we were not able to do that until just recently will be irrelevant.


> Add documentation for how to use Solr JDBC driver with SQL client like DB Visualizer
> ------------------------------------------------------------------------------------
>
>                 Key: SOLR-8521
>                 URL: https://issues.apache.org/jira/browse/SOLR-8521
>             Project: Solr
>          Issue Type: Sub-task
>          Components: documentation, SolrJ
>    Affects Versions: master
>            Reporter: Kevin Risden
>         Attachments: solr_jdbc_dbvisualizer_20160203.pdf
>
>
> Currently this requires the following:
> * a JDBC SQL client program (like DBVisualizer or SQuirrelSQL)
> * all jars from solr/dist/solrj-lib/* to be on the SQL client classpath
> * solr/dist/solr-solrj-6.0.0-SNAPSHOT.jar on the SQL client classpath
> * a valid JDBC connection string (like jdbc:solr://SOLR_ZK_CONNECTION_STRING?collection=COLLECTION_NAME)
> * without SOLR-8213, the username/password supplied by the SQL client will be ignored.



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