[
https://issues.apache.org/jira/browse/SOLR-12472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shawn Heisey updated SOLR-12472:
--------------------------------
Environment: (was: 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.)
> 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
> Reporter: Rani Y.
> Priority: Major
>
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
