Invokes a service that is part of LiveCycle 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.
A string 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.
Service
The name of the LiveCycle service
or process that will be invoked for each batch item that is read.
Operation
The operation to invoke for
each batch item that is read. When the service is a process, the
value is always invoke. 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.
Static Parameters
A set of parameters
that are applied to each LiveCycle 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.
Do
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.
Sort Key
A unique key to use to sort and
limit page content.
Batch Output properties
Properties that identify the output data source and output
SQL.
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.
Output SQL
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)".
Optimization properties
Properties that identify the partition strategy, its parameters,
and commit interval.
Partition Strategy
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
Arguments
used by the partitioning strategy. The number of input items per partition
or the number partitions, depending on the partition strategy.
Commit Interval
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.
Result properties
Batch processing return code. Can return any of the following
values:
COMPLETED
FAILED
STOPPED
UNKNOWN
ALREADY_RUNNING
RESTART_FAILED
ALREADY_COMPLETE
Exceptions
This operation can throw a BatchProcessorException.
