[
https://issues.apache.org/jira/browse/SOLR-13220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-13220:
----------------------------------
Description:
The jdcb Streaming Expression currently opens and closes the database
connection with each call. This hinders performance and scalability. This
ticket will allow the jdbc stream to lazily cache the connection in a cache
managed by the stream handler.
The connectionUrl will be hashed to create a key to the cache. The connection
will also be refreshed (closed/opened) periodically to ensure that they are not
timed out during periods of inactivity.
was:
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}
> jdbc Streaming Expression should lazily cache 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
>
> The jdcb Streaming Expression currently opens and closes the database
> connection with each call. This hinders performance and scalability. This
> ticket will allow the jdbc stream to lazily cache the connection in a cache
> managed by the stream handler.
> The connectionUrl will be hashed to create a key to the cache. The connection
> will also be refreshed (closed/opened) periodically to ensure that they are
> not timed out during periods of inactivity.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
