JDBC with DbVisualizer
Solr’s JDBC driver supports DbVisualizer for querying Solr.
For DbVisualizer, you will need to create a new driver for Solr using the DbVisualizer Driver Manager.
This will add several SolrJ client (and dependency)
.jar s to the DbVisualizer classpath.
See below for the required files.
Once the driver has been created, you can create a connection to Solr with the connection string format outlined in the generic section and use the SQL Commander to issue queries.
Name the Driver in Driver Manager
Provide a name for the driver, and provide the URL format:
Do not fill in values for the variables “
zk_connection_string” and “
collection”, those will be provided later when the connection to Solr is configured.
The Driver Class will also be automatically added when the driver
.jar s are added.
Add Driver Files to Classpath
The driver files to be added are:
.jars found in
$SOLR_TIP/server/lib/ext/*. In the Solr distribution these dependencies are not separated from Solr’s dependencies, so you must include all or manually choose the exact set that is needed. Please refer to the maven release for the exact dependencies needed for your version.
Create a Connection
Open and Connect to Solr
Once the connection has been created, double-click on it to open the connection details screen and connect to Solr.