[jira] [Commented] (NIFI-2381) Connection Pooling Service -Drop invalid connections and create new ones

["Carlos Manuel António Fernandes (JIRA)" <ji...@apache.org>]

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

Carlos Manuel António Fernandes commented on NIFI-2381:
-------------------------------------------------------

Toivo, I Will test and send feedback soon.

Carlos


> Connection Pooling Service -Drop invalid connections and create new ones 
> -------------------------------------------------------------------------
>
>                 Key: NIFI-2381
>                 URL: https://issues.apache.org/jira/browse/NIFI-2381
>             Project: Apache NiFi
>          Issue Type: Improvement
>          Components: Core Framework
>    Affects Versions: 0.7.0
>         Environment: all
>            Reporter: Carlos Manuel António Fernandes
>            Assignee: Toivo Adams
>
> The connections  in Connection Pooling Service become invalid for several reasons : session timeout, firewalls block idle connections, outages of backend server, etc.
> In the current niif releases this connections rest in the pool as good  but when the user use one of them is triggered an errror  for the backend database. 
> Ex: org.netezza.error.NzSQLException: FATAL 1:  Connection Terminated - session timeout exceeded
> With this improvement we pretend periodicaly to test all the connections , drop the invalid ,create new ones and  mantain all the pool healthy.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)