• Squirrel Jdbc Driver Handbook
• Jdbc Driver Mysql

In theory SQuirreL should work with any DBMS that has a JDBC 2.0 driver. However not all drivers/DBMS's are fully complient with the JDBC 2.0 specification. People have reported SQuirreL working with the following. For any other database you first have to download the JDBC driver. Hope that helps. If you have further questions do not hesitate to ask. Andreas Ernesto Silva schrieb: Hi, I'm new to the list and to Squirrel sql client. I've downloaded and installed Squirrel 3.1.2 in.

For SQuirreL SQL, you will need to create a new driver for Solr. This will add several SolrJ client .jars to the SQuirreL SQL classpath. The files required are:

• all .jars found in $SOLR_HOME/dist/solrj-libs

• the SolrJ .jar found at $SOLR_HOME/dist/solr-solrj-<version>.jar

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 editor to issue queries.

Add Solr JDBC Driver

Name the Driver

Provide a name for the driver, and provide the URL format: jdbc:solr://<zk_connection_string>/?collection=<collection>. Do not fill in values for the variables “zk_connection_string” and “collection”, those will be defined later when the connection to Solr is configured.

Add the Solr JDBC driver class name

After adding the .jars, you will need to additionally define the Class Name org.apache.solr.client.solrj.io.sql.DriverImpl.

Create an Alias

Squirrel Jdbc Driver Handbook

Jdbc Driver Mysql

To define a JDBC connection, you must define an alias.

Querying

Once you’ve successfully connected to Solr, you can use the SQL interface to enter queries and work with data.