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

        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

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

              Dates

                Created:
                Updated:
                Resolved: