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

Improve Solr JDBC Driver to support SQL Clients like DBVisualizer

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: 6.0
    • Fix Version/s: 6.0
    • Component/s: SolrJ
    • Labels:

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

          Issue Links

          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

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

                Dates

                • Created:
                  Updated:
                  Resolved: