[SOLR-8502] Improve Solr JDBC Driver to support SQL Clients like DBVisualizer

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Affects Version/s: 6.0
• Fix Version/s: 6.0
• Component/s: SolrJ
• Labels: jdbc
• Assignee: Unassigned
• Reporter: Kevin Risden
• Created: 07/Jan/16 19:02
• Updated: 08/Oct/19 14:51
• Resolved: 07/Feb/16 02:47

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.

Issue Links

• is related to: SOLR-8680 Distribute JDBC driver as a separate jar
• is related to: SOLR-8659 Improve Solr JDBC Driver to support more SQL Clients
• is related to: SOLR-8786 Ensure Solr's JDBC Driver works with Apache Zeppelin
• relates to: SOLR-8125 Umbrella ticket for Streaming and SQL issues
• relates to: SOLR-7986 JDBC Driver for SQL Interface
• relates to: SOLR-8593 Integrate Apache Calcite into the SQLHandler
• supercedes: SOLR-8138 Simple UI for issuing SQL queries

Sub-Tasks

• Implement org.apache.solr.client.solrj.io.sql.ConnectionImpl.getMetaData and getCatalog: Closed
• Implement DatabaseMetaDataImpl.getDatabaseMajorVersion and DatabaseMetaDataImpl.getDatabaseMinorVersion(): Closed
• Determine test strategy and add tests for JDBC driver metadata.: Closed
• Implement DatabaseMetaDataImpl.getURL(): Closed
• Implement ResultSetImpl.getMetaData(): Closed
• Implement StatementImpl.getConnection: Closed
• Implement ResultSetImpl.getStatement: Closed
• Implement StatementImpl.execute(String sql), StatementImpl.getResultSet(), and StatementImpl.getUpdateCount(): Closed
• Implement ConnectionImpl,StatementImpl,ResultSetImpl clearWarnings and getWarnings: Resolved
• Implement ResultSetMetaDataImpl.getColumnCount(): Resolved
• Implement minimal set of get* methods in ResultSetImpl for column names: Resolved
• Implement minimal set of get* methods in ResultSetImpl for column indices: Resolved
• Implement ResultSetMetaDataImpl getColumnType and getColumnTypeName: Resolved
• Implement ResultSetMetaDataImpl getColumnLabel(int column) and getColumnDisplaySize(int column): Resolved
• Implement ConnectionImpl.isValid() and DatabaseMetaDataImpl.getConnection(): Resolved
• Implement ResultSetImpl.wasNull(): Resolved
• Implement StatementImpl.getMoreResults(): Resolved
• Implement DatabaseMetaDataImpl.getCatalogs(): Resolved
• Implement DatabaseMetaDataImpl.getSchemas(): Resolved
• Throw UnsupportedOperationException for DatabaseMetaDataImpl.getTypeInfo(): Resolved
• Add information about database product name, product version, driver name, and driver version.: Resolved
• Implement ConnectionImpl setCatalog and setSchema: Resolved