[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8502: - Attachment: aggregation-query.png Added a screenshot of an aggregation query with aliases. > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: 6.0 > > Attachments: aggregation-query.png, connection-screen-shot.png, > connection-working!.png, driver-setup.png, screenshot-1.png, > screenshot-2.png, screenshot-3.png, screenshot-4.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8502: - Attachment: connection-working!.png Attaching a screenshot with a working connection. All I did was restart DbVisualizer and the connection started working. I'll move on committing the remaining open tickets. I'll also create a new ticket to implement setMaxRows() on the Statement. This is the only error I see in the debug window and it will be extremely useful in ensuring users don't select entire result sets. The implementation will simply take on a limit clause to the end of the SQL statement if it doesn't exist. After this work is done I'll close out this ticket and add SOLR-8502 to CHANGES.txt for 6.0. > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: connection-screen-shot.png, connection-working!.png, > driver-setup.png, screenshot-1.png, screenshot-2.png, screenshot-3.png, > screenshot-4.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8502: - Fix Version/s: (was: Trunk) 6.0 > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: 6.0 > > Attachments: connection-screen-shot.png, connection-working!.png, > driver-setup.png, screenshot-1.png, screenshot-2.png, screenshot-3.png, > screenshot-4.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8502: - Attachment: driver-setup.png connection-screen-shot.png > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: connection-screen-shot.png, driver-setup.png, > screenshot-1.png, screenshot-2.png, screenshot-3.png, screenshot-4.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- Attachment: screenshot-4.png > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: screenshot-1.png, screenshot-2.png, screenshot-3.png, > screenshot-4.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- Attachment: screenshot-3.png > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: screenshot-1.png, screenshot-2.png, screenshot-3.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- Attachment: screenshot-1.png > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: screenshot-1.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- Attachment: screenshot-2.png > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: Trunk > > Attachments: screenshot-1.png, screenshot-2.png > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8502: - Fix Version/s: 6.0 > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > Fix For: 6.0 > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- 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. Some ideas for sub jiras include: * implementing getMetadata method in ConnectionImpl * add necessary metadata classes to support more advanced SQL clients * implementing more methods in ConnectionImpl, StatementImpl, ResultSetImpl * pass back schema info from sql handler to enable proper populations * support JDBC/Solr authentication 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 include the recent changes to trunk. The branch has unrelated formatting changes that should be ignored. was: 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. Some ideas for sub jiras include: * implementing getMetadata method in ConnectionImpl * add necessary metadata classes to support more advanced SQL clients * implementing more methods in ConnectionImpl, StatementImpl, ResultSetImpl * pass back schema info from sql handler to enable proper populations 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 include the recent changes to trunk. The branch has unrelated formatting changes that should be ignored. > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > > 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. Some ideas for sub jiras include: > * implementing getMetadata method in ConnectionImpl > * add necessary metadata classes to support more advanced SQL clients > * implementing more methods in ConnectionImpl, StatementImpl, ResultSetImpl > * pass back schema info from sql handler to enable proper populations > * support JDBC/Solr authentication > 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 include the recent changes to trunk. The branch has unrelated > formatting changes that should be ignored. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8502) Improve Solr JDBC Driver to support SQL Clients like DBVisualizer
[ https://issues.apache.org/jira/browse/SOLR-8502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Risden updated SOLR-8502: --- 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. was: 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. Some ideas for sub jiras include: * implementing getMetadata method in ConnectionImpl * add necessary metadata classes to support more advanced SQL clients * implementing more methods in ConnectionImpl, StatementImpl, ResultSetImpl * pass back schema info from sql handler to enable proper populations * support JDBC/Solr authentication 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 include the recent changes to trunk. The branch has unrelated formatting changes that should be ignored. > Improve Solr JDBC Driver to support SQL Clients like DBVisualizer > - > > Key: SOLR-8502 > URL: https://issues.apache.org/jira/browse/SOLR-8502 > Project: Solr > Issue Type: Improvement > Components: SolrJ >Affects Versions: Trunk >Reporter: Kevin Risden > Labels: jdbc > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
