[jira] [Comment Edited] (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:comment-tabpanel=15135959#comment-15135959 ] Joel Bernstein edited comment on SOLR-8502 at 2/6/16 7:26 PM: -- 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 tack 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. was (Author: joel.bernstein): 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] [Comment Edited] (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:comment-tabpanel=15129740#comment-15129740 ] Joel Bernstein edited comment on SOLR-8502 at 2/3/16 3:53 AM: -- [~risdenk], working on connecting with DbVisualizer but am currently stuck with following error: java.util.concurrent.TimeoutException: Could not connect to ZooKeeper localhost:9983 within 1 ms I can make a JDBC connection using a command line client to that address though. Did you run into an issue like this? was (Author: joel.bernstein): [~risdenk], working on connecting with DbVisualizer but am currently stuck with following error: java.util.concurrent.TimeoutException: Could not connect to ZooKeeper localhost:9983 within 1 ms I can make JDBC connection using a command line client to that address though. Did you run into an issue like this? > 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] [Comment Edited] (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:comment-tabpanel=15121793#comment-15121793 ] Joel Bernstein edited comment on SOLR-8502 at 1/28/16 4:11 PM: --- [~risdenk], do we have enough working in DBVisualizer with the latest commit to declare victory on this ticket. If we do, we can close it out and add it to the CHANGES.txt for 6.0. If we can connect, run an aggregation query and chart the result I think that's a great start. The remaining issues listed on this ticket we can tackle individually. Or do you feel like we need to tackle the calalog and schema issues before closing this out? was (Author: joel.bernstein): [~risdenk], do we have enough working in DBVisualizer with the latest commit to declare victory on this ticket. If we do, we can close it out and add it to the CHANGES.txt for 6.0. If we can connect, run and aggregation query and chart the result I think that's a great start. The remaining issues listed on this ticket we can tackle individually. Or do you feel like we need to tackle the calalog and schema issues before closing this out? > 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] [Comment Edited] (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:comment-tabpanel=15121793#comment-15121793 ] Joel Bernstein edited comment on SOLR-8502 at 1/28/16 4:11 PM: --- [~risdenk], do we have enough working in DBVisualizer with the latest commit to declare victory on this ticket. If we do, we can close it out and add it to the CHANGES.txt for 6.0. If we can connect, run and aggregation query and chart the result I think that's a great start. The remaining issues listed on this ticket we can tackle individually. Or do you feel like we need to tackle the calalog and schema issues before closing this out? was (Author: joel.bernstein): [~risdenk], do we have enough working in DBVisualizer with the latest commit to declare victory on this ticket. If we do, we can close it out and add it to the CHANGES.txt for 6.0. The remaining issues listed on this ticket we can tackle individually. Or do you feel like we need to tackle the calalog and schema issues before closing this out? > 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] [Comment Edited] (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:comment-tabpanel=15117303#comment-15117303 ] Kevin Risden edited comment on SOLR-8502 at 1/26/16 7:55 PM: - Added screenshot-1.png to show that rough DBVisualizer is working. The following items are still "issues": * The columns are always returned as strings with getString since SOLR-8518 is not merged * ConnectionImpl.isValid() throws a warning that it is not implemented but assumes the connection is valid. SOLR-8574 * Column names and width are guessed by dbvisualizer but can be improved with SOLR-8520 * DBVisualizer cannot get info about the driver since some methods about versions/names aren't implemented. SOLR-8507 * Catalog/schema info is not implemented so there is an error when trying to populate that info with DBVisualizer SOLR-8508 and SOLR-8510 was (Author: risdenk): Added screenshot-1.png to show that rough DBVisualizer is working. The following items are still "issues": * The columns are always returned as strings with getString since SOLR-8518 is not merged * ConnectionImpl.isValid() throws a warning that it is not implemented but assumes the connection is valid. SOLR-8574 * Column names and width are guessed by intellij but can be improved with SOLR-8520 * DBVisualizer cannot get info about the driver since some methods about versions/names aren't implemented. SOLR-8507 * Catalog/schema info is not implemented so there is an error when trying to populate that info with DBVisualizer SOLR-8508 and SOLR-8510 > 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] [Comment Edited] (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:comment-tabpanel=15089599#comment-15089599 ] Kevin Risden edited comment on SOLR-8502 at 1/8/16 9:21 PM: Here are some of the JIRAs are that are ready for review. * SOLR-8503 * SOLR-8507 * SOLR-8509 * SOLR-8511 * SOLR-8513 * SOLR-8514 * SOLR-8515 * SOLR-8516 was (Author: risdenk): Here are some of the JIRAs are that are ready for review. * SOLR-8503 * SOLR-8507 * SOLR-8511 * SOLR-8513 * SOLR-8514 * SOLR-8515 * SOLR-8516 > 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