Rani Y. created SOLR-12472:
------------------------------

             Summary: SOLR JDBC issue with running queries
                 Key: SOLR-12472
                 URL: https://issues.apache.org/jira/browse/SOLR-12472
             Project: Solr
          Issue Type: Bug
      Security Level: Public (Default Security Level. Issues are Public)
          Components: SolrJ
    Affects Versions: 6.5.1
         Environment: I am trying to work with the SOLR-JDBC.

For some reason it works with DbVisualizer, but a simple java program ..

Class.forName("org.apache.solr.client.solrj.io.sql.DriverImpl");

Connection conn = 
DriverManager.getConnection("jdbc:solr://zootest01:2181/?collection=mycol");

Statement stat = conn.createStatement();

ResultSet rs = stat.executeQuery("select item_id from mycol limit 10");

this fails with exception coming from :

org.noggit.JSONParser$ParserException: JSON Parse Error : char=< ...

It seems like the internal engine is returning HTML or XML while JSON is 
expected due to some reason.

As there is totally no documentation at all about the Driver Properties or 
anything else, I've no idea what is causing this or why is works with 
SquirrelSql & dbVisualizer, and not with other tools like DBeaver for example, 
which have the very same issues as I get with simple java program.

Any idea what is wrong there ? Cause definitely something is wrong, as I use a 
very simple Java sample which works fine with every other JDBC driver I've 
tested.
            Reporter: Rani Y.






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to