Package org.apache.nifi.processors.standard

Class AbstractExecuteSQL

java.lang.Object

org.apache.nifi.components.AbstractConfigurableComponent

org.apache.nifi.processor.AbstractSessionFactoryProcessor

org.apache.nifi.processor.AbstractProcessor

org.apache.nifi.processors.standard.AbstractExecuteSQL

All Implemented Interfaces:

org.apache.nifi.components.ConfigurableComponent, org.apache.nifi.processor.Processor

Direct Known Subclasses:

ExecuteSQL, ExecuteSQLRecord

public abstract class AbstractExecuteSQL
extends org.apache.nifi.processor.AbstractProcessor

Field Summary

Fields

Modifier and Type	Field	Description
static final org.apache.nifi.components.PropertyDescriptor	AUTO_COMMIT
static final org.apache.nifi.components.PropertyDescriptor	DBCP_SERVICE
protected DBCPService	dbcpService
static final org.apache.nifi.components.PropertyDescriptor	FETCH_SIZE
static final String	FRAGMENT_COUNT
static final String	FRAGMENT_ID
static final String	FRAGMENT_INDEX
static final String	INPUT_FLOWFILE_UUID
static final org.apache.nifi.components.PropertyDescriptor	MAX_ROWS_PER_FLOW_FILE
static final org.apache.nifi.components.PropertyDescriptor	OUTPUT_BATCH_SIZE
protected List<org.apache.nifi.components.PropertyDescriptor>	propDescriptors
static final org.apache.nifi.components.PropertyDescriptor	QUERY_TIMEOUT
static final org.apache.nifi.processor.Relationship	REL_FAILURE
static final org.apache.nifi.processor.Relationship	REL_SUCCESS
protected Set<org.apache.nifi.processor.Relationship>	relationships
static final String	RESULT_ERROR_MESSAGE
static final String	RESULT_QUERY_DURATION
static final String	RESULT_QUERY_EXECUTION_TIME
static final String	RESULT_QUERY_FETCH_TIME
static final String	RESULT_ROW_COUNT
static final String	RESULTSET_INDEX
static final org.apache.nifi.components.PropertyDescriptor	SQL_POST_QUERY
static final org.apache.nifi.components.PropertyDescriptor	SQL_PRE_QUERY
static final org.apache.nifi.components.PropertyDescriptor	SQL_SELECT_QUERY

Constructor Summary

Constructors

Constructor	Description
AbstractExecuteSQL()

Method Summary

Modifier and Type	Method	Description
protected abstract SqlWriter	configureSqlWriter(org.apache.nifi.processor.ProcessSession session, org.apache.nifi.processor.ProcessContext context, org.apache.nifi.flowfile.FlowFile fileToProcess)
protected org.apache.commons.lang3.tuple.Pair<String,SQLException>	executeConfigStatements(Connection con, List<String> configQueries)
protected List<String>	getQueries(String value)
Set<org.apache.nifi.processor.Relationship>	getRelationships()
protected List<org.apache.nifi.components.PropertyDescriptor>	getSupportedPropertyDescriptors()
void	onTrigger(org.apache.nifi.processor.ProcessContext context, org.apache.nifi.processor.ProcessSession session)
protected org.apache.nifi.flowfile.FlowFile	setFlowFileEmptyResults(org.apache.nifi.processor.ProcessSession session, org.apache.nifi.flowfile.FlowFile flowFile, SqlWriter sqlWriter)
void	setup(org.apache.nifi.processor.ProcessContext context)

Methods inherited from class org.apache.nifi.processor.AbstractProcessor

onTrigger

Methods inherited from class org.apache.nifi.processor.AbstractSessionFactoryProcessor

getControllerServiceLookup, getIdentifier, getLogger, getNodeTypeProvider, init, initialize, isConfigurationRestored, isScheduled, toString, updateConfiguredRestoredTrue, updateScheduledFalse, updateScheduledTrue

Methods inherited from class org.apache.nifi.components.AbstractConfigurableComponent

customValidate, equals, getPropertyDescriptor, getPropertyDescriptors, getSupportedDynamicPropertyDescriptor, hashCode, onPropertyModified, validate

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.apache.nifi.components.ConfigurableComponent

getPropertyDescriptor, getPropertyDescriptors, onPropertyModified, validate

Methods inherited from interface org.apache.nifi.processor.Processor

isStateful, migrateProperties, migrateRelationships

Field Details

RESULT_ROW_COUNT

public static final String RESULT_ROW_COUNT

See Also:

• Constant Field Values

RESULT_QUERY_DURATION

public static final String RESULT_QUERY_DURATION

See Also:

• Constant Field Values

RESULT_QUERY_EXECUTION_TIME

public static final String RESULT_QUERY_EXECUTION_TIME

See Also:

• Constant Field Values

RESULT_QUERY_FETCH_TIME

public static final String RESULT_QUERY_FETCH_TIME

See Also:

• Constant Field Values

RESULTSET_INDEX

public static final String RESULTSET_INDEX

See Also:

• Constant Field Values

RESULT_ERROR_MESSAGE

public static final String RESULT_ERROR_MESSAGE

See Also:

• Constant Field Values

INPUT_FLOWFILE_UUID

public static final String INPUT_FLOWFILE_UUID

See Also:

• Constant Field Values

FRAGMENT_ID

public static final String FRAGMENT_ID

FRAGMENT_INDEX

public static final String FRAGMENT_INDEX

FRAGMENT_COUNT

public static final String FRAGMENT_COUNT

REL_SUCCESS

public static final org.apache.nifi.processor.Relationship REL_SUCCESS

REL_FAILURE

public static final org.apache.nifi.processor.Relationship REL_FAILURE

relationships

protected Set<org.apache.nifi.processor.Relationship> relationships

DBCP_SERVICE

public static final org.apache.nifi.components.PropertyDescriptor DBCP_SERVICE

SQL_PRE_QUERY

public static final org.apache.nifi.components.PropertyDescriptor SQL_PRE_QUERY

SQL_SELECT_QUERY

public static final org.apache.nifi.components.PropertyDescriptor SQL_SELECT_QUERY

SQL_POST_QUERY

public static final org.apache.nifi.components.PropertyDescriptor SQL_POST_QUERY

QUERY_TIMEOUT

public static final org.apache.nifi.components.PropertyDescriptor QUERY_TIMEOUT

MAX_ROWS_PER_FLOW_FILE

public static final org.apache.nifi.components.PropertyDescriptor MAX_ROWS_PER_FLOW_FILE

OUTPUT_BATCH_SIZE

public static final org.apache.nifi.components.PropertyDescriptor OUTPUT_BATCH_SIZE

FETCH_SIZE

public static final org.apache.nifi.components.PropertyDescriptor FETCH_SIZE

AUTO_COMMIT

public static final org.apache.nifi.components.PropertyDescriptor AUTO_COMMIT

propDescriptors

protected List<org.apache.nifi.components.PropertyDescriptor> propDescriptors

dbcpService

protected DBCPService dbcpService

Constructor Details

AbstractExecuteSQL

public AbstractExecuteSQL()

Method Details

getRelationships

public Set<org.apache.nifi.processor.Relationship> getRelationships()

Specified by:

getRelationships in interface org.apache.nifi.processor.Processor

Overrides:

getRelationships in class org.apache.nifi.processor.AbstractSessionFactoryProcessor

getSupportedPropertyDescriptors

protected List<org.apache.nifi.components.PropertyDescriptor> getSupportedPropertyDescriptors()

Overrides:

getSupportedPropertyDescriptors in class org.apache.nifi.components.AbstractConfigurableComponent

setup

@OnScheduled
public void setup(org.apache.nifi.processor.ProcessContext context)

onTrigger

public void onTrigger(org.apache.nifi.processor.ProcessContext context,
 org.apache.nifi.processor.ProcessSession session)
               throws org.apache.nifi.processor.exception.ProcessException

Specified by:

onTrigger in class org.apache.nifi.processor.AbstractProcessor

Throws:

org.apache.nifi.processor.exception.ProcessException

setFlowFileEmptyResults

protected org.apache.nifi.flowfile.FlowFile setFlowFileEmptyResults(org.apache.nifi.processor.ProcessSession session,
 org.apache.nifi.flowfile.FlowFile flowFile,
 SqlWriter sqlWriter)

executeConfigStatements

protected org.apache.commons.lang3.tuple.Pair<String,SQLException> executeConfigStatements(Connection con,
 List<String> configQueries)

getQueries

protected List<String> getQueries(String value)

configureSqlWriter

protected abstract SqlWriter configureSqlWriter(org.apache.nifi.processor.ProcessSession session,
 org.apache.nifi.processor.ProcessContext context,
 org.apache.nifi.flowfile.FlowFile fileToProcess)