You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Shawn Heisey (JIRA)" <ji...@apache.org> on 2018/06/10 20:35:00 UTC
[jira] [Updated] (SOLR-12472) SOLR JDBC issue with running queries
[ https://issues.apache.org/jira/browse/SOLR-12472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shawn Heisey updated SOLR-12472:
--------------------------------
Description:
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
> 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.
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org