[SOLR-8659] Improve Solr JDBC Driver to support more SQL Clients

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 6.0
• Component/s: SolrJ
• Assignee: Unassigned
• Reporter: Kevin Risden
• Created: 08/Feb/16 21:32
• Updated: 08/Oct/19 14:50

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

Issue Links

• is related to: SOLR-8680 Distribute JDBC driver as a separate jar
• 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-8502 Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
• relates to: SOLR-8593 Integrate Apache Calcite into the SQLHandler

Sub-Tasks

• SolrJ JDBC - ClassNotFoundException: com.google.common.base.MoreObjects: Closed
• Implement DatabaseMetaDataImpl getTables() and fix getSchemas(): Resolved
• Implement Connection.setReadOnly, Statement.set/getFetchSize, ResultSet.getType: Resolved
• Implement Connection.prepareStatement: Closed
• Implement StatementImpl/ResultSetImpl get/set fetch* methods and proper errors for traversal methods: Closed
• Add setReadOnly(String ...) to ConnectionImpl: Resolved
• Implement DatabaseMetaDataImpl.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern): Open
• SolrJ JDBC - Implement "Select *": Resolved
• Implement PreparedStatementImpl parameterization: Reopened
• Implement DatabaseMetaDataImpl.getPrimaryKeys(String catalog, String schema, String table): Closed
• SolrJ JDBC - DBVisualizer DB Capabilities: Closed
• SolrJ JDBC - DbVisualizer Database Info Keywords and Functions: Closed
• SolrJ JDBC - DbVisualizer info about data types: Closed
• SolrJ JDBC - DbVisualizer DB Tables ResultSet is empty: Closed
• SolrJ JDBC - DbVisualizer DB -> Table -> Tables tab ResultSet is empty: Closed
• SolrJ JDBC - DbVisualizer DB -> DB -> References tab NPE: Closed
• SolrJ JDBC - Ensure that SQuirrel SQL works with SolrJ JDBC: Resolved
• SolrJ JDBC - Ensure that Python JayDeBeApi works with SolrJ JDBC: Closed
• SolrJ JDBC - Ensure that R RJDBC works with SolrJ JDBC: Closed
• SolrJ JDBC - Ensure that an ODBC-JDBC bridge works with SolrJ JDBC: Closed
• Add documentation for how to use Solr JDBC driver with SQL client like DB Visualizer: Resolved
• SolrJ JDBC - SQuirrel SQL documentation: Resolved
• SolrJ JDBC - Apache Zeppelin JDBC documentation: Resolved
• SolrJ JDBC - Python JayDeBeApi documentation: Resolved
• SolrJ JDBC - Jython Documentation: Resolved
• SolrJ JDBC - R RJDBC documentation: Resolved
• SolrJ JDBC - ODBC-JDBC bridge documentation: Closed
• SolrJ JDBC - Ensure that Spark works with SolrJ JDBC: Open
• SolrJ JDBC - Spark documentation: Open