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

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

Carlos Manuel António Fernandes created NIFI-2381:
-----------------------------------------------------

             Summary: 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


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)