Run JDBC Cursor Job operation
Invokes a service that is part of AEM forms using parameters
read from each record of a JDBC query. A database cursor reads the
input items. This approach is often the simplest and most efficient
for reading the input items, although not all databases and application
server environments support it.
For information about the General and Route Evaluation property
Common operation properties
Job Identification properties
Property that identifies the job run.
value that uniquely identifies
this job run among all job runs with the same parameters. If null
or empty, a unique value is generated.
Service Operation properties
Properties that identify the service and operation to invoke
for each batch item read.
The name of the AEM forms service
or process that will be invoked for each batch item that is read.
The operation to invoke for
each batch item that is read. When the service is a process, the
value is always
. When the service is a Document
Service Component, the value is the name of the service operation.
Static Service Parameters properties
Properties that identify static service parameters.
A map that contains
the parameters that are applied to the AEM forms service that is
called for each item.
Batch Input properties
Properties that identify the input data source and input
Input Data Source
Input items are read
from this data source.
An SQL statement where each
row of the result set is mapped to a batch input item.
Batch Output properties
Properties that identify the output data source and output
Output Data Source
Output parameters for
each batch item can be written to this data source. If null or empty,
no output is written at the batch level.
An SQL statement that writes
output parameters to the output data source. The SQL statement may
use named parameters that correspond to input or output parameters,
for example, "insert into mytable (c1, c2) value (:param1, :param2)".
Properties that identify the partition strategy, its parameters,
and commit interval.
Determines how the
input items will be partitioned for parallel processing. Use any
of the following values:
No Partitioning. Input
items are processed sequentially
Each Partition has a specified number of input items
The input items are split into a specified number of partitions
Partition Strategy Parameters
used by the partitioning strategy. The number of input items per partition
or the number partitions, depending on the partition strategy.
The number of items that
will be processed before the batch processing state is committed
to persistent store. Setting this value too low may use more resources. Setting
this value too high may risk transaction time outs. If a failure
occurs, the batch processor needs to retry processing those items.
Batch processing return code. Can return any of the following
This operation can throw a BatchProcessorException.