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.
For information about the General and Route Evaluation property
groups, see Common operation properties.
Job Identification propertiesProperty that identifies the job run.
Run IdentifierA 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 propertiesProperties that identify the service and operation to invoke
for each batch item read.
ServiceThe name of the LiveCycle service
or process that will be invoked for each batch item that is read.
OperationThe 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 propertiesProperties that identify static service parameters.
Static ParametersA set of parameters
that are applied to each LiveCycle service invocation.
Batch Input propertiesProperties that identify the input data source and the
input SELECT, FROM, and WHERE clauses.
Input Data SourceThe JNDI name of the
JDBC data source that input items will be read from.
Input SELECT ClauseThe 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 ClauseThe FROM clause part
of SQL query string. You can omit the FROM keyword.
Input WHERE ClauseThe WHERE clause part
of SQL query string. You can omit the WHERE keyword.
Sort KeyA unique key to use to sort and
limit page content.
Batch Output propertiesProperties that identify the output data source and output
SQL.
Output Data SourceThe 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 SQLAn 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 propertiesProperties that identify the partition strategy, its parameters,
and commit interval.
Partition StrategyDetermines 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 ParametersArguments
used by the partitioning strategy. The number of input items per partition
or the number partitions, depending on the partition strategy.
Commit IntervalThe 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 propertiesBatch processing return code. Can return any of the following
values:
COMPLETED
FAILED
STOPPED
UNKNOWN
ALREADY_RUNNING
RESTART_FAILED
ALREADY_COMPLETE
ExceptionsThis operation can throw a BatchProcessorException.
|
|
|