Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" ?>
- <template encoding-version="1.1">
- <description></description>
- <groupId>73ae6ed8-015e-1000-89f3-94907fd76646</groupId>
- <name>NIFI-4352</name>
- <snippet>
- <processGroups>
- <id>af0614b4-e899-38f5-0000-000000000000</id>
- <parentGroupId>c72c436c-5a63-35af-0000-000000000000</parentGroupId>
- <position>
- <x>0.0</x>
- <y>0.0</y>
- </position>
- <comments></comments>
- <contents>
- <connections>
- <id>95be3a9f-7d65-3878-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>88df13bf-0a02-3443-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>09dcfaf8-ceed-3fe3-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>db2e08a4-bcfd-3f22-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>9a964548-d41b-3016-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>e4edc66f-3833-3212-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>e828f8d7-cf88-33c9-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <bends>
- <x>642.5</x>
- <y>314.5</y>
- </bends>
- <destination>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>88df13bf-0a02-3443-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>failure</selectedRelationships>
- <source>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>09dcfaf8-ceed-3fe3-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>4e75beb0-3d02-3812-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <bends>
- <x>-74.79996109008789</x>
- <y>344.7000045776367</y>
- </bends>
- <destination>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>9a964548-d41b-3016-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>failure</selectedRelationships>
- <selectedRelationships>retry</selectedRelationships>
- <source>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>e4edc66f-3833-3212-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <connections>
- <id>6cf1a3f2-c1d1-3fc2-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <backPressureDataSizeThreshold>1 GB</backPressureDataSizeThreshold>
- <backPressureObjectThreshold>10000</backPressureObjectThreshold>
- <destination>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>e4edc66f-3833-3212-0000-000000000000</id>
- <type>PROCESSOR</type>
- </destination>
- <flowFileExpiration>0 sec</flowFileExpiration>
- <labelIndex>1</labelIndex>
- <name></name>
- <selectedRelationships>success</selectedRelationships>
- <source>
- <groupId>af0614b4-e899-38f5-0000-000000000000</groupId>
- <id>c6c11444-8dd1-31c6-0000-000000000000</id>
- <type>PROCESSOR</type>
- </source>
- <zIndex>0</zIndex>
- </connections>
- <controllerServices>
- <id>d7682303-fa59-3327-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <bundle>
- <artifact>nifi-dbcp-service-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <comments></comments>
- <descriptors>
- <entry>
- <key>Database Connection URL</key>
- <value>
- <name>Database Connection URL</name>
- </value>
- </entry>
- <entry>
- <key>Database Driver Class Name</key>
- <value>
- <name>Database Driver Class Name</name>
- </value>
- </entry>
- <entry>
- <key>database-driver-locations</key>
- <value>
- <name>database-driver-locations</name>
- </value>
- </entry>
- <entry>
- <key>Database User</key>
- <value>
- <name>Database User</name>
- </value>
- </entry>
- <entry>
- <key>Password</key>
- <value>
- <name>Password</name>
- </value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>
- <name>Max Wait Time</name>
- </value>
- </entry>
- <entry>
- <key>Max Total Connections</key>
- <value>
- <name>Max Total Connections</name>
- </value>
- </entry>
- <entry>
- <key>Validation-query</key>
- <value>
- <name>Validation-query</name>
- </value>
- </entry>
- </descriptors>
- <name>DBCPConnectionPool</name>
- <persistsState>false</persistsState>
- <properties>
- <entry>
- <key>Database Connection URL</key>
- <value>jdbc:oracle:thin:@nifi-test.c9novxgbvgcd.ap-northeast-1.rds.amazonaws.com:1521:ORCL</value>
- </entry>
- <entry>
- <key>Database Driver Class Name</key>
- <value>oracle.jdbc.driver.OracleDriver</value>
- </entry>
- <entry>
- <key>database-driver-locations</key>
- <value>/Users/koji/Downloads/ojdbc7.jar</value>
- </entry>
- <entry>
- <key>Database User</key>
- <value>admin</value>
- </entry>
- <entry>
- <key>Password</key>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>500 millis</value>
- </entry>
- <entry>
- <key>Max Total Connections</key>
- <value>8</value>
- </entry>
- <entry>
- <key>Validation-query</key>
- </entry>
- </properties>
- <state>ENABLED</state>
- <type>org.apache.nifi.dbcp.DBCPConnectionPool</type>
- </controllerServices>
- <processors>
- <id>88df13bf-0a02-3443-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <position>
- <x>696.2000122070312</x>
- <y>371.3999938964844</y>
- </position>
- <bundle>
- <artifact>nifi-update-attribute-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Delete Attributes Expression</key>
- <value>
- <name>Delete Attributes Expression</name>
- </value>
- </entry>
- <entry>
- <key>Store State</key>
- <value>
- <name>Store State</name>
- </value>
- </entry>
- <entry>
- <key>Stateful Variables Initial Value</key>
- <value>
- <name>Stateful Variables Initial Value</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Delete Attributes Expression</key>
- </entry>
- <entry>
- <key>Store State</key>
- <value>Do not store state</value>
- </entry>
- <entry>
- <key>Stateful Variables Initial Value</key>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>UpdateAttribute</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <state>STOPPED</state>
- <style></style>
- <type>org.apache.nifi.processors.attributes.UpdateAttribute</type>
- </processors>
- <processors>
- <id>9a964548-d41b-3016-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <position>
- <x>-51.599952697753906</x>
- <y>407.20001220703125</y>
- </position>
- <bundle>
- <artifact>nifi-update-attribute-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Delete Attributes Expression</key>
- <value>
- <name>Delete Attributes Expression</name>
- </value>
- </entry>
- <entry>
- <key>Store State</key>
- <value>
- <name>Store State</name>
- </value>
- </entry>
- <entry>
- <key>Stateful Variables Initial Value</key>
- <value>
- <name>Stateful Variables Initial Value</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Delete Attributes Expression</key>
- </entry>
- <entry>
- <key>Store State</key>
- <value>Do not store state</value>
- </entry>
- <entry>
- <key>Stateful Variables Initial Value</key>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>UpdateAttribute</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <state>STOPPED</state>
- <style></style>
- <type>org.apache.nifi.processors.attributes.UpdateAttribute</type>
- </processors>
- <processors>
- <id>c6c11444-8dd1-31c6-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <position>
- <x>-37.899999999999864</x>
- <y>-94.49999809265128</y>
- </position>
- <bundle>
- <artifact>nifi-standard-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>File Size</key>
- <value>
- <name>File Size</name>
- </value>
- </entry>
- <entry>
- <key>Batch Size</key>
- <value>
- <name>Batch Size</name>
- </value>
- </entry>
- <entry>
- <key>Data Format</key>
- <value>
- <name>Data Format</name>
- </value>
- </entry>
- <entry>
- <key>Unique FlowFiles</key>
- <value>
- <name>Unique FlowFiles</name>
- </value>
- </entry>
- <entry>
- <key>generate-ff-custom-text</key>
- <value>
- <name>generate-ff-custom-text</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.1.type</key>
- <value>
- <name>sql.args.1.type</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.1.value</key>
- <value>
- <name>sql.args.1.value</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.2.type</key>
- <value>
- <name>sql.args.2.type</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.2.value</key>
- <value>
- <name>sql.args.2.value</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.3.type</key>
- <value>
- <name>sql.args.3.type</name>
- </value>
- </entry>
- <entry>
- <key>sql.args.3.value</key>
- <value>
- <name>sql.args.3.value</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>File Size</key>
- <value>0B</value>
- </entry>
- <entry>
- <key>Batch Size</key>
- <value>1</value>
- </entry>
- <entry>
- <key>Data Format</key>
- <value>Text</value>
- </entry>
- <entry>
- <key>Unique FlowFiles</key>
- <value>false</value>
- </entry>
- <entry>
- <key>generate-ff-custom-text</key>
- <value>insert into clob_test values(?, ?, ?)</value>
- </entry>
- <entry>
- <key>sql.args.1.type</key>
- <value>4</value>
- </entry>
- <entry>
- <key>sql.args.1.value</key>
- <value>1</value>
- </entry>
- <entry>
- <key>sql.args.2.type</key>
- <value>2005</value>
- </entry>
- <entry>
- <key>sql.args.2.value</key>
- <value>Some text which will be inserted into a CLOB column.</value>
- </entry>
- <entry>
- <key>sql.args.3.type</key>
- <value>2011</value>
- </entry>
- <entry>
- <key>sql.args.3.value</key>
- <value>こんにちは、世界</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>1d</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>GenerateFlowFile</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <state>STOPPED</state>
- <style></style>
- <type>org.apache.nifi.processors.standard.GenerateFlowFile</type>
- </processors>
- <processors>
- <id>e4edc66f-3833-3212-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <position>
- <x>-47.999969482421875</x>
- <y>152.1999969482422</y>
- </position>
- <bundle>
- <artifact>nifi-standard-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>JDBC Connection Pool</key>
- <value>
- <identifiesControllerService>org.apache.nifi.dbcp.DBCPService</identifiesControllerService>
- <name>JDBC Connection Pool</name>
- </value>
- </entry>
- <entry>
- <key>Support Fragmented Transactions</key>
- <value>
- <name>Support Fragmented Transactions</name>
- </value>
- </entry>
- <entry>
- <key>Transaction Timeout</key>
- <value>
- <name>Transaction Timeout</name>
- </value>
- </entry>
- <entry>
- <key>Batch Size</key>
- <value>
- <name>Batch Size</name>
- </value>
- </entry>
- <entry>
- <key>Obtain Generated Keys</key>
- <value>
- <name>Obtain Generated Keys</name>
- </value>
- </entry>
- <entry>
- <key>rollback-on-failure</key>
- <value>
- <name>rollback-on-failure</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>JDBC Connection Pool</key>
- <value>d7682303-fa59-3327-0000-000000000000</value>
- </entry>
- <entry>
- <key>Support Fragmented Transactions</key>
- <value>true</value>
- </entry>
- <entry>
- <key>Transaction Timeout</key>
- </entry>
- <entry>
- <key>Batch Size</key>
- <value>100</value>
- </entry>
- <entry>
- <key>Obtain Generated Keys</key>
- <value>false</value>
- </entry>
- <entry>
- <key>rollback-on-failure</key>
- <value>true</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>0 sec</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>PutSQL</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>retry</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <state>STOPPED</state>
- <style></style>
- <type>org.apache.nifi.processors.standard.PutSQL</type>
- </processors>
- <processors>
- <id>09dcfaf8-ceed-3fe3-0000-000000000000</id>
- <parentGroupId>af0614b4-e899-38f5-0000-000000000000</parentGroupId>
- <position>
- <x>746.7999877929688</x>
- <y>106.0</y>
- </position>
- <bundle>
- <artifact>nifi-standard-nar</artifact>
- <group>org.apache.nifi</group>
- <version>1.4.0-SNAPSHOT</version>
- </bundle>
- <config>
- <bulletinLevel>WARN</bulletinLevel>
- <comments></comments>
- <concurrentlySchedulableTaskCount>1</concurrentlySchedulableTaskCount>
- <descriptors>
- <entry>
- <key>Database Connection Pooling Service</key>
- <value>
- <identifiesControllerService>org.apache.nifi.dbcp.DBCPService</identifiesControllerService>
- <name>Database Connection Pooling Service</name>
- </value>
- </entry>
- <entry>
- <key>SQL select query</key>
- <value>
- <name>SQL select query</name>
- </value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>
- <name>Max Wait Time</name>
- </value>
- </entry>
- <entry>
- <key>dbf-normalize</key>
- <value>
- <name>dbf-normalize</name>
- </value>
- </entry>
- <entry>
- <key>dbf-user-logical-types</key>
- <value>
- <name>dbf-user-logical-types</name>
- </value>
- </entry>
- <entry>
- <key>dbf-default-precision</key>
- <value>
- <name>dbf-default-precision</name>
- </value>
- </entry>
- <entry>
- <key>dbf-default-scale</key>
- <value>
- <name>dbf-default-scale</name>
- </value>
- </entry>
- </descriptors>
- <executionNode>ALL</executionNode>
- <lossTolerant>false</lossTolerant>
- <penaltyDuration>30 sec</penaltyDuration>
- <properties>
- <entry>
- <key>Database Connection Pooling Service</key>
- <value>d7682303-fa59-3327-0000-000000000000</value>
- </entry>
- <entry>
- <key>SQL select query</key>
- <value>select * from clob_test</value>
- </entry>
- <entry>
- <key>Max Wait Time</key>
- <value>0 seconds</value>
- </entry>
- <entry>
- <key>dbf-normalize</key>
- <value>false</value>
- </entry>
- <entry>
- <key>dbf-user-logical-types</key>
- <value>false</value>
- </entry>
- <entry>
- <key>dbf-default-precision</key>
- <value>10</value>
- </entry>
- <entry>
- <key>dbf-default-scale</key>
- <value>0</value>
- </entry>
- </properties>
- <runDurationMillis>0</runDurationMillis>
- <schedulingPeriod>1d</schedulingPeriod>
- <schedulingStrategy>TIMER_DRIVEN</schedulingStrategy>
- <yieldDuration>1 sec</yieldDuration>
- </config>
- <name>ExecuteSQL</name>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>failure</name>
- </relationships>
- <relationships>
- <autoTerminate>false</autoTerminate>
- <name>success</name>
- </relationships>
- <state>RUNNING</state>
- <style></style>
- <type>org.apache.nifi.processors.standard.ExecuteSQL</type>
- </processors>
- </contents>
- <name>NIFI-4352</name>
- </processGroups>
- </snippet>
- <timestamp>09/12/2017 12:04:40 JST</timestamp>
- </template>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement