Sam Hjelmfelt created NIFI-2973:
-----------------------------------

             Summary: Allow Dynamic Connection Pooling Service for ExecuteSQL
                 Key: NIFI-2973
                 URL: https://issues.apache.org/jira/browse/NIFI-2973
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Core Framework
            Reporter: Sam Hjelmfelt


Currently, extracting data from multiple databases requires a RouteOnAttribute 
processor and one ExecuteSQL processor for each database server. If the 
"Database Connection Pooling Service" attribute could be set with EL, one 
ExecuteSQL processor could be used.

In the ExecuteSQL processor, the connection is obtained in each OnTrigger 
execution anyway:
172: final DBCPService dbcpService = 
context.getProperty(DBCP_SERVICE).asControllerService(DBCPService.class);
...
192: final Connection con = dbcpService.getConnection();



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

Reply via email to