Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-8659

Improve Solr JDBC Driver to support more SQL Clients

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 6.0
    • Fix Version/s: None
    • Component/s: SolrJ
    • Labels:
      None

      Description

      SOLR-8502 was a great start to getting JDBC support to be more complete. This ticket is to track items that could further improve the JDBC support for more SQL clients and their features. A few SQL clients are:

      • DbVisualizer
      • SQuirrel SQL
      • Apache Zeppelin (incubating)
      • Spark
      • Python & Jython
      • IntelliJ IDEA Database Tool
      • ODBC clients like Excel/Tableau

        Attachments

          Issue Links

          1.
          SolrJ JDBC - ClassNotFoundException: com.google.common.base.MoreObjects Sub-task Closed Unassigned
          2.
          Implement DatabaseMetaDataImpl getTables() and fix getSchemas() Sub-task Resolved Kevin Risden
          3.
          Implement Connection.setReadOnly, Statement.set/getFetchSize, ResultSet.getType Sub-task Resolved Kevin Risden
          4.
          Implement Connection.prepareStatement Sub-task Closed Kevin Risden
          5.
          Implement StatementImpl/ResultSetImpl get/set fetch* methods and proper errors for traversal methods Sub-task Closed Kevin Risden
          6.
          Add setReadOnly(String ...) to ConnectionImpl Sub-task Resolved Kevin Risden
          7.
          Implement DatabaseMetaDataImpl.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Sub-task Open Kevin Risden
          8.
          SolrJ JDBC - Implement "Select *" Sub-task Resolved Kevin Risden
          9.
          Implement PreparedStatementImpl parameterization Sub-task Reopened Kevin Risden
          10.
          Implement DatabaseMetaDataImpl.getPrimaryKeys(String catalog, String schema, String table) Sub-task Closed Kevin Risden
          11.
          SolrJ JDBC - DBVisualizer DB Capabilities Sub-task Closed Unassigned
          12.
          SolrJ JDBC - DbVisualizer Database Info Keywords and Functions Sub-task Closed Kevin Risden
          13.
          SolrJ JDBC - DbVisualizer info about data types Sub-task Closed Kevin Risden
          14.
          SolrJ JDBC - DbVisualizer DB Tables ResultSet is empty Sub-task Closed Unassigned
          15.
          SolrJ JDBC - DbVisualizer DB -> Table -> Tables tab ResultSet is empty Sub-task Closed Unassigned
          16.
          SolrJ JDBC - DbVisualizer DB -> DB -> References tab NPE Sub-task Closed Unassigned
          17.
          SolrJ JDBC - Ensure that SQuirrel SQL works with SolrJ JDBC Sub-task Resolved Kevin Risden
          18.
          SolrJ JDBC - Ensure that Python JayDeBeApi works with SolrJ JDBC Sub-task Closed Kevin Risden
          19.
          SolrJ JDBC - Ensure that R RJDBC works with SolrJ JDBC Sub-task Closed Kevin Risden
          20.
          SolrJ JDBC - Ensure that an ODBC-JDBC bridge works with SolrJ JDBC Sub-task Closed Kevin Risden
          21.
          Add documentation for how to use Solr JDBC driver with SQL client like DB Visualizer Sub-task Resolved Kevin Risden
          22.
          SolrJ JDBC - SQuirrel SQL documentation Sub-task Resolved Kevin Risden
          23.
          SolrJ JDBC - Apache Zeppelin JDBC documentation Sub-task Resolved Kevin Risden
          24.
          SolrJ JDBC - Python JayDeBeApi documentation Sub-task Resolved Kevin Risden
          25.
          SolrJ JDBC - Jython Documentation Sub-task Resolved Kevin Risden
          26.
          SolrJ JDBC - R RJDBC documentation Sub-task Resolved Kevin Risden
          27.
          SolrJ JDBC - ODBC-JDBC bridge documentation Sub-task Closed Kevin Risden
          28.
          SolrJ JDBC - Ensure that Spark works with SolrJ JDBC Sub-task Open Kevin Risden
          29.
          SolrJ JDBC - Spark documentation Sub-task Open Unassigned

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                risdenk Kevin Risden
              • Votes:
                2 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated: