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

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 6.0
• Component/s: documentation, SolrJ
• Assignee: Kevin Risden
• Reporter: Kevin Risden
• Created: 07/Jan/16 21:10
• Updated: 22/Jun/16 18:13
• Resolved: 06/May/16 15:20

Description

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.

Issue Links

• is related to: SOLR-8846 SolrJ JDBC - Spark documentation
• is related to: SOLR-8824 SolrJ JDBC - Apache Zeppelin JDBC documentation
• is related to: SOLR-8825 SolrJ JDBC - SQuirrel SQL documentation
• is related to: SOLR-9013 SolrJ JDBC - Python JayDeBeApi documentation
• is related to: SOLR-9018 SolrJ JDBC - Jython Documentation
• is related to: SOLR-8826 SolrJ JDBC - ODBC-JDBC bridge documentation
• is related to: SOLR-8680 Distribute JDBC driver as a separate jar
• relates to: SOLR-8125 Umbrella ticket for Streaming and SQL issues