Reference

Authentication HTTP

Description

No description available [API reference]

Instructions

Solr SQL over HTTP (no ZooKeeper in the JDBC URL). Still requires /sql on the collection.

  1. Note the Solr node host and HTTP port (default 8983) and the collection name.
  2. If the node is SolrCloud, ZooKeeper Auth is usually more reliable. Use HTTP for standalone Solr or a single node you can reach directly.
  3. Keep SolrJ 9.x. Do not mix Solr 10 JARs with this EngineVersion 11 profile.
  4. After Finish, replace host, port, and collection.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Include SolrJ, streaming, and ZooKeeper JARs. Add WEB-INF/lib and server/lib/ext if Test Connection reports missing classes (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Apache Solr\solr-solrj-9.10.1.jar;C:\ZappySys\Jdbc\Apache Solr\solr-solrj-streaming-9.10.1.jar;C:\ZappySys\Jdbc\Apache Solr\solr-solrj-zookeeper-9.10.1.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 2181). 		YES 2181
Name: Collection

Label: Collection

Solr collection name (e.g. MyCollection). 		YES MyCollection
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.solr.client.solrj.io.sql.DriverImpl). 		org.apache.solr.client.solrj.io.sql.DriverImpl
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.