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

["Toivo Adams (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Toivo Adams updated NIFI-2381:
------------------------------
    Status: Patch Available  (was: In Progress)

https://github.com/apache/nifi/pull/986

Testing is most difficult.
Derby was useless. Finally H2 allowed to create invalid connections (by restarting server) and Junit test conformed drop and create.

Please test using other databases, especially Netezza.

Thanks
Toivo

> 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)