[ https://issues.apache.org/jira/browse/SOLR-7986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717899#comment-14717899 ]
Joel Bernstein commented on SOLR-7986: -------------------------------------- Some thoughts on the design: 1) The *Connection* class should be SolrCloud aware. This means that the *Database* it connects to is a SolrCloud Collection with each node running a /sql handler. This Collection will be a facade for the distributed database. SQL queries can refer to *Tables* (Collections) that reside in the same ZooKeeper or a remote Zookeeper. 2) The *Statement* and *ResultSet* can be a wrapper around a SolrStream class. The SolrStream class can be used to send SQL request of HTTP to the /sql handler. 3) The Statement will open and close the SolrStream. 4) The ResultSet can be used to iterate the Tuples from the SolrStream. > JDBC Driver for SQL Interface > ----------------------------- > > Key: SOLR-7986 > URL: https://issues.apache.org/jira/browse/SOLR-7986 > Project: Solr > Issue Type: Bug > Components: clients - java > Affects Versions: Trunk > Reporter: Joel Bernstein > Priority: Minor > > This ticket is to create a JDBC Driver (thin client) for the new SQL > interface. As part of this ticket a driver will be added to the Solrj libary > under the package: *org.apache.solr.client.solrj.io.jdbc* > Initial implementation will include basic *Connection*, *Statement* and > *ResultSet* implementations. > Future releases can build on this implementation to support a wide range of > JDBC clients and user interfaces. > -- 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