Re: Solr vs JDBC driver

2016-05-31 Thread Vachon , Jean-Sébastien
e77PLDQ3ZHnf9yvFvYlNUI3MVyqcKj3K >lyZF0A=pZojVpq10BZok4-rElqKq3mXwoUx8HsGwFK0hhWGqAE=IEvtNH443siONK2tXX4 >IPdFocT4Kc0JnwY-eqITAteg= > >On Fri, May 27, 2016 at 8:16 PM, Vachon, Jean-Sébastien < >jvac...@cebglobal.com> wrote: > >> Never

SQL Interface vs geofilter (radius search)

2016-05-30 Thread Vachon , Jean-Sébastien
Hi All, Does the SQL interface allow searching around a specific lat/long coordinates for all documents within a radius of 50 kilometers? If so, what is the syntax to perform such a query? Thanks CEB Canada Inc. Registration No: 1781071. Registered office: 199 Bay Street Commerce Court

Re: Solr vs JDBC driver

2016-05-27 Thread Vachon , Jean-Sébastien
Never mindŠ I had to load the class just like any database driver: Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl").newInstance (); On 2016-05-27, 2:59 PM, "Vachon, Jean-Sébastien" <jvac...@cebglobal.com> wrote: >Hi All, > > > >I am

Solr vs JDBC driver

2016-05-27 Thread Vachon , Jean-Sébastien
Hi All, I am trying to use Solr’s JDBC driver in Java and I’m stuck with the following error message: 14:52:37,802 ERROR [consoleLogger] java.sql.SQLException: No suitable driver found for jdbc:solr://10.28.213.133:2181/solr?collection=Current My pom.xml contains: org.apache.solr

Question regarding the SQL interface

2016-05-19 Thread Vachon , Jean-Sébastien
Hi all, I am planning into migrating our application from SolrJ to the SQL interface and I have some questions regarding some of Solr features… * How can we specify multiple search fields on a keyword. Do we have to handle everything by ourselves like in regular SQL? SELECT x,y,z FROM