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

Improve Solr JDBC Driver to support SQL Clients like DBVisualizer

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Implemented
    • 6.0
    • 6.0
    • SolrJ

    Description

      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.

      Attachments

        1. aggregation-query.png
          990 kB
          Joel Bernstein
        2. connection-working!.png
          789 kB
          Joel Bernstein
        3. driver-setup.png
          1.22 MB
          Joel Bernstein
        4. connection-screen-shot.png
          1.14 MB
          Joel Bernstein
        5. screenshot-4.png
          1.46 MB
          Kevin Risden
        6. screenshot-3.png
          1.45 MB
          Kevin Risden
        7. screenshot-2.png
          1.42 MB
          Kevin Risden
        8. screenshot-1.png
          1.44 MB
          Kevin Risden

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. SOLR-8680 Distribute JDBC driver as a separate jar

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. SOLR-8659 Improve Solr JDBC Driver to support more SQL Clients

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. SOLR-8786 Ensure Solr's JDBC Driver works with Apache Zeppelin

          • Major - Major loss of function.
          • Resolved
          relates to

          New Feature - A new feature of the product, which has yet to be developed. SOLR-8125 Umbrella ticket for Streaming and SQL issues

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. SOLR-7986 JDBC Driver for SQL Interface

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SOLR-8593 Integrate Apache Calcite into the SQLHandler

          • Major - Major loss of function.
          • Closed
          supercedes

          New Feature - A new feature of the product, which has yet to be developed. SOLR-8138 Simple UI for issuing SQL queries

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          1.
          		 Implement org.apache.solr.client.solrj.io.sql.ConnectionImpl.getMetaData and getCatalog Sub-task Closed Unassigned
          2.
          		 Implement DatabaseMetaDataImpl.getDatabaseMajorVersion and DatabaseMetaDataImpl.getDatabaseMinorVersion() Sub-task Closed Unassigned
          3.
          		 Determine test strategy and add tests for JDBC driver metadata. Sub-task Closed Unassigned
          4.
          		 Implement DatabaseMetaDataImpl.getURL() Sub-task Closed Unassigned
          5.
          		 Implement ResultSetImpl.getMetaData() Sub-task Closed Unassigned
          6.
          		 Implement StatementImpl.getConnection Sub-task Closed Joel Bernstein
          7.
          		 Implement ResultSetImpl.getStatement Sub-task Closed Unassigned
          8.
          		 Implement StatementImpl.execute(String sql), StatementImpl.getResultSet(), and StatementImpl.getUpdateCount() Sub-task Closed Joel Bernstein
          9.
          		 Implement ConnectionImpl,StatementImpl,ResultSetImpl clearWarnings and getWarnings Sub-task Resolved Unassigned
          10.
          		 Implement ResultSetMetaDataImpl.getColumnCount() Sub-task Resolved Unassigned
          11.
          		 Implement minimal set of get* methods in ResultSetImpl for column names Sub-task Resolved Unassigned
          12.
          		 Implement minimal set of get* methods in ResultSetImpl for column indices Sub-task Resolved Unassigned
          13.
          		 Implement ResultSetMetaDataImpl getColumnType and getColumnTypeName Sub-task Resolved Unassigned
          14.
          		 Implement ResultSetMetaDataImpl getColumnLabel(int column) and getColumnDisplaySize(int column) Sub-task Resolved Unassigned
          15.
          		 Implement ConnectionImpl.isValid() and DatabaseMetaDataImpl.getConnection() Sub-task Resolved Joel Bernstein
          16.
          		 Implement ResultSetImpl.wasNull() Sub-task Resolved Joel Bernstein
          17.
          		 Implement StatementImpl.getMoreResults() Sub-task Resolved Unassigned
          18.
          		 Implement DatabaseMetaDataImpl.getCatalogs() Sub-task Resolved Unassigned
          19.
          		 Implement DatabaseMetaDataImpl.getSchemas() Sub-task Resolved Unassigned
          20.
          		 Throw UnsupportedOperationException for DatabaseMetaDataImpl.getTypeInfo() Sub-task Resolved Unassigned
          21.
          		 Add information about database product name, product version, driver name, and driver version. Sub-task Resolved Unassigned
          22.
          		 Implement ConnectionImpl setCatalog and setSchema Sub-task Resolved Unassigned

          Activity

            People

              Unassigned Unassigned
              krisden Kevin Risden
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: