[
https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15130837#comment-15130837
]
Joel Bernstein commented on SOLR-8502:
--------------------------------------
Here is the debug error:
2016-02-03 08:52:38.855 INFO 955 [ExecutorRunner-pool-3-thread-11 - G.ￄﾷ]
Exception while connecting Database Connection (1) (2)
*** Database Properties ****************************
Alias: Database Connection (1) (2)
Settings Format: URL
URL: jdbc:solr://localhost:9983?collection=collection2
Driver: solr
Userid:
Preferred Database Type: auto
Current Database Type: generic
Preferred Profile: auto
Current Profile: null (not connected?)
--- Object Type Settings ---------------------------
None
--- Overridden User Properties ---------------------
generic.AutoCommit = false
generic.ConnectionMode = Production
--- Overridden Driver Properties -------------------
None
*** End Database Properties ************************
*** Driver Information *****************************
Name: solr
DefaultDriver: false
DefaultClass: org.apache.solr.client.solrj.io.sql.DriverImpl
Paths:
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solr-solrj-6.0.0-SNAPSHOT.jar
Type: dynamic
Class: org.apache.solr.client.solrj.io.sql.DriverImpl
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/commons-io-2.4.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/httpclient-4.4.1.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/httpcore-4.4.1.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/httpmime-4.4.1.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/jcl-over-slf4j-1.7.7.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/noggit-0.6.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/slf4j-api-1.7.7.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/stax2-api-3.1.4.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/woodstox-core-asl-4.4.1.jar
Type: dynamic
Path:
/Users/joelbernstein/solr-git/lucene-solr/solr/dist/solrj-lib/zookeeper-3.4.6.jar
Type: dynamic
*** End Driver Information *************************
*** Current Connection Message *********************
Disconnected.
*** End Current Connection Message *****************
2016-02-03 08:52:38.857 INFO 955 [ExecutorRunner-pool-3-thread-11 - G.ￄﾷ]
Exception while connecting Database Connection (1) (2)
org.apache.solr.common.SolrException: java.util.concurrent.TimeoutException:
Could not connect to ZooKeeper localhost:9983 within 10000 ms
at
org.apache.solr.common.cloud.SolrZkClient.<init>(SolrZkClient.java:182)
at
org.apache.solr.common.cloud.SolrZkClient.<init>(SolrZkClient.java:116)
at
org.apache.solr.common.cloud.SolrZkClient.<init>(SolrZkClient.java:106)
at
org.apache.solr.common.cloud.ZkStateReader.<init>(ZkStateReader.java:202)
at
org.apache.solr.client.solrj.impl.CloudSolrClient.connect(CloudSolrClient.java:467)
at
org.apache.solr.client.solrj.io.SolrClientCache.getCloudSolrClient(SolrClientCache.java:49)
at
org.apache.solr.client.solrj.io.sql.ConnectionImpl.<init>(ConnectionImpl.java:56)
at
org.apache.solr.client.solrj.io.sql.DriverImpl.connect(DriverImpl.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.onseven.dbvis.h.B.D.ￄﾁ(Z:1548)
at com.onseven.dbvis.h.B.F$A.call(Z:1369)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.util.concurrent.TimeoutException: Could not connect to
ZooKeeper localhost:9983 within 10000 ms
at
org.apache.solr.common.cloud.ConnectionManager.waitForConnected(ConnectionManager.java:209)
at
org.apache.solr.common.cloud.SolrZkClient.<init>(SolrZkClient.java:174)
... 17 more
> Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
> -----------------------------------------------------------------
>
> Key: SOLR-8502
> URL: https://issues.apache.org/jira/browse/SOLR-8502
> Project: Solr
> Issue Type: Improvement
> Components: SolrJ
> Affects Versions: Trunk
> Reporter: Kevin Risden
> Labels: jdbc
> Fix For: Trunk
>
> Attachments: connection-screen-shot.png, driver-setup.png,
> screenshot-1.png, screenshot-2.png, screenshot-3.png, screenshot-4.png
>
>
> Currently when trying to connect to Solr with the JDBC driver with a SQL
> client the driver must implement more methods and metadata to allow
> connections. This JIRA is designed to act as an umbrella for the JDBC changes.
> An initial pass from a few months ago is here:
> https://github.com/risdenk/lucene-solr/tree/expand-jdbc. This needs to be
> broken up and create patches for the related sub tasks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
