[jira] [Updated] (NIFI-322) New Database Connection Pooling Controller Service

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

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

Toivo Adams updated NIFI-322:
-----------------------------
    Attachment: TestProcessor.java
                TestDatabaseSystems.java
                DBCPServiceTest.java
                DBCPServiceApacheDBCP14.java
                DatabaseSystems.java
                DatabaseSystemDescriptor.java

First prototype

> New Database Connection Pooling Controller Service
> --------------------------------------------------
>
>                 Key: NIFI-322
>                 URL: https://issues.apache.org/jira/browse/NIFI-322
>             Project: Apache NiFi
>          Issue Type: New Feature
>          Components: Extensions
>            Reporter: Toivo Adams
>            Priority: Minor
>              Labels: controller
>         Attachments: DBCPServiceApacheDBCP14.java, DBCPServiceTest.java, DatabaseSystemDescriptor.java, DatabaseSystems.java, TestDatabaseSystems.java, TestProcessor.java
>
>
> Often DataFlows contain many processors which deal with database - select, update or delete different data in different tables. 
> Yet database is same and connection pooling helps to speed up connecting to database (open connection is fairly expensive). Also configuration must be done only in one place. 
> Database Connection Pooling Controller Service helps to solve this in consistent way. 
> related
> https://issues.apache.org/jira/browse/NIFI-293 : Add a JDBC Processor for executing arbitrary SQL queries. 



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