You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "wanghongqi (Jira)" <ji...@apache.org> on 2020/06/10 06:53:00 UTC

[jira] [Created] (NIFI-7519) Add a ExecuteSQL property on DBCPConnectionPool

wanghongqi created NIFI-7519:
--------------------------------

             Summary: Add a ExecuteSQL property on DBCPConnectionPool
                 Key: NIFI-7519
                 URL: https://issues.apache.org/jira/browse/NIFI-7519
             Project: Apache NiFi
          Issue Type: Wish
            Reporter: wanghongqi


I wish add a ExecuteSQL property on DBCPConnectionPool.

 

When it is convenient to get the connection (usually before inserting data), some processing such as turning off foreign key verification, index optimizer (GreenPlum) and so on are performed in advance.

 

For example: MySQL execute 'SET UNIQUE_CHECKS=0' OR 'SET AUTOCOMMIT=0' on a INSERT connection.

For example: GreenPlum execute 'set optimizer to off' before return a connection for insert.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)