Run JDBC Paging Job operation
Invokes a service that is part of AEM forms using parameters
read from each record of a JDBC query. This method generates database
queries that read the rows in a page of input items that are processed
in one transaction. Since multiple queries are used to retrieve
the input items, this operation can be less efficient than the Run
JDBC Cursor Job operation. However, this operation can work with
some databases and application servers where the Run JDBC Cursor Job
operation is not supported.
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 set of parameters
that are applied to each AEM forms service invocation.
Batch Input properties
Properties that identify the input data source and the
input SELECT, FROM, and WHERE clauses.
Input Data Source
The JNDI name of the
JDBC data source that input items will be read from.
Input SELECT Clause
The SELECT clause
part of SQL query string. You can omit the SELECT keyword.
not use the column as a sort key if the column has an alias in the
SELECT clause. For example, if you use SELECT clause= "column1,
column2, column3 as key" and a user enters "column3" or "key" as
the sort key, the JDBC Paging job will fail. The user needs to enter
"column1" or "column2" as the sort key.
Input FROM Clause
The FROM clause part
of SQL query string. You can omit the FROM keyword.
Input WHERE Clause
The WHERE clause part
of SQL query string. You can omit the WHERE keyword.
A unique key to use to sort and
limit page content.
Batch Output properties
Properties that identify the output data source and output
Output Data Source
The JNDI name of a
JDBC data source that output items are written to. 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.