[jira] [Resolved] (SOLR-12472) SOLR JDBC issue with running queries

["Shawn Heisey (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-12472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shawn Heisey resolved SOLR-12472.
---------------------------------
    Resolution: Invalid

This issue tracker is not a support portal.

Please discuss the problem with the community, either on the user mailing list or the IRC channel.  If the community determines that the problem you're having is a bug, then we can take further action in Jira.

http://lucene.apache.org/solr/community.html#mailing-lists-irc

In the community discussion, please provide any entries in solr.log that correspond with the attempted query.  Any other information you can supply would also be helpful.


> 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
>




--
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