You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Joel Bernstein (JIRA)" <ji...@apache.org> on 2019/04/03 00:04:00 UTC

[jira] [Comment Edited] (SOLR-13220) Add connect Streaming Expression to create cached JDBC connections

    [ https://issues.apache.org/jira/browse/SOLR-13220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808241#comment-16808241 ] 

Joel Bernstein edited comment on SOLR-13220 at 4/3/19 12:03 AM:
----------------------------------------------------------------

My thinking on this has evolved. The new plan is to change the JDBCStream to lazily cache connections in a pool that is managed by the Stream handler. The handle to the cached connection will be a hash of the connectionUrl, user and password. Caching would be off be default and turned on with a flag in the jdbc expression. 


was (Author: joel.bernstein):
My thinking on the has evolved. The new plan is to change the JDBCStream to lazily cache connections in a pool that is managed by the Stream handler. The handle to the cache will be a hash of the connectionUrl, user and password. Caching would be off be default and turned on with a flag in the jdbc expression. 

> Add connect Streaming Expression to create cached JDBC connections
> ------------------------------------------------------------------
>
>                 Key: SOLR-13220
>                 URL: https://issues.apache.org/jira/browse/SOLR-13220
>             Project: Solr
>          Issue Type: New Feature
>      Security Level: Public(Default Security Level. Issues are Public) 
>            Reporter: Joel Bernstein
>            Assignee: Joel Bernstein
>            Priority: Major
>
> Currently the *jdbc* Streaming Expression requires that username, password and URL parameters are set to operate. This ticket will allow users to configure JDBC connections using the new *connect* Streaming Expression. 
> The *jdbc* Streaming Expression will be changed to use the cached connections rather than accepting parameters directly.
> The *parallel* Streaming Expression can be used to setup connections on each node of a collection.
> The *Apache Hive* JDBC driver will also be included with Apache Solr as part of this ticket to allow seamless out-of-the-box connection to Apache Hive.
> Syntax:
> {code:java}
> connect(connectionName, url="", username="", password=""){code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org