> > start (without option : bin/solr start)
Solr SQL/JDBC requires Solr Cloud (running w/ Zookeeper) since streaming expressions (which backs the Solr SQL) requires it. You should be able to start Solr this way to get Solr in cloud mode. bin/solr start -c If you use the above to start Solr, the embedded ZK is on localhost:9983 so the JDBC connection string should be: jdbc:solr://localhost:9983?collection=test Assuming your collection name is test. Kevin Risden On Fri, Nov 6, 2020 at 11:31 AM Vincent Bossuet <bossue...@free.fr> wrote: > Hi all :) > > I'm trying to connect to Solr with JDBC, but I always have > "java.util.concurrent.TimeoutException: Could not connect to ZooKeeper > localhost:9983/ within 15000 ms" (or other port, depends wich jdbc url I > test). > > Here what I did : > > - > > I installed Solr 7.7.2 (i followed install doc here > <https://lucene.apache.org/solr/guide/7_2/installing-solr.html>), i.e. > download, extract, start (without option : bin/solr start). This > version of > Solr is the one I have at work, so i installed the same to test before > on > localhost. > - > > I added a 'test' collection and the examples xml documents, I can see > them at this url <http://localhost:8983/solr/test/select?q=*%3A*> > - > > then I installed DbVisualizer, added driver and a connection, like > explained > here > <https://lucene.apache.org/solr/guide/7_2/solr-jdbc-dbvisualizer.html> > => > the only differences I saw with documentation is that on screencopy with > the jar to import, versions are differents and there is one more jar in > solr archive (commons-math3-3.6.1.jar). Also, the jdbc url to use is > with > or without a '/' in the middle (see here > <http://jdbc:solr//localhost:9983?collection=test>), as this : > jdbc:solr://localhost:9983?collection=test or > jdbc:solr://localhost:9983/?collection=test. I don't know if it is > important... > - > > and I tried both on Ubuntu VM and Windows 10 > > So, all seems to be installed correctly, as in documentation, but when I > click on 'connect', always have a timeout. Every website where I found some > info talk about an url with 9983 port, I tried other possibilities (just in > case) but no success... > > - jdbc:solr://localhost:9983?collection=test > - jdbc:solr://127.0.0.1:9983?collection=test > - jdbc:solr://localhost:9983/?collection=test > - jdbc:solr://localhost:9983/solr?collection=test > - jdbc:solr://localhost:8983/?collection=test > - jdbc:solr://localhost:8983?collection=test > - jdbc:solr://localhost:8983/solr?collection=test > - jdbc:solr://localhost:2181?collection=test > - jdbc:solr://localhost:2181/?collection=test > - jdbc:solr://localhost:2181/solr?collection=test > > If you have an idea, thanks for help ! > > Vincent >
