[
https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15120513#comment-15120513
]
Kevin Risden commented on SOLR-8502:
------------------------------------
Including SOLR-8520, SOLR-8574, SOLR-8603, and SOLR-8602:
DBVisualizer with screenshot-3.png
JiSQL
{code}
java -cp
/opt/jisql/lib/jisql-2.0.11.jar:/opt/jisql/lib/jopt-simple-3.2.jar:/opt/solr/dist/solrj-lib/*:/opt/solr/dist/solr-solrj-6.0.0-SNAPSHOT.jar
com.xigole.util.sql.Jisql -user test -password test -driver
org.apache.solr.client.solrj.io.sql.DriverImpl -cstring
'jdbc:solr://192.168.1.237:9983?collection=test&aggregationMode=map_reduce' -c
\; -query 'select fielda, fieldb, fieldc, fieldd_s, fielde_i from test limit
10;'
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
SLF4J: Failed to load class "org.slf4j.impl.StaticMDCBinder".
SLF4J: Defaulting to no-operation MDCAdapter implementation.
SLF4J: See http://www.slf4j.org/codes.html#no_static_mdc_binder for further
details.
fielda | fieldb | fieldc | fieldd_s | fielde_i |
-------+--------+--------+----------+----------|
a1 | b1 | 1 | d1 | 1 |
a2 | b2 | 2 | d1 | 2 |
a1 | b3 | 3 | NULL | 1 |
a1 | b4 | 4 | d2 | NULL |
a2 | b2 | NULL | d2 | 2 |
{code}
> Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
> -----------------------------------------------------------------
>
> Key: SOLR-8502
> URL: https://issues.apache.org/jira/browse/SOLR-8502
> Project: Solr
> Issue Type: Improvement
> Components: SolrJ
> Affects Versions: Trunk
> Reporter: Kevin Risden
> Labels: jdbc
> Fix For: Trunk
>
> Attachments: screenshot-1.png, screenshot-2.png, screenshot-3.png
>
>
> Currently when trying to connect to Solr with the JDBC driver with a SQL
> client the driver must implement more methods and metadata to allow
> connections. This JIRA is designed to act as an umbrella for the JDBC changes.
> An initial pass from a few months ago is here:
> https://github.com/risdenk/lucene-solr/tree/expand-jdbc. This needs to be
> broken up and create patches for the related sub tasks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
