Enum Summary |
GpListener.State |
|
SqlTablePoller.OPTIONAL_ATT |
Optional fields that can be included in your parameter tree as attributes in the
upper Element
1) 4 character long String that indicate status of each row for this poller
1st: Character that indicates "Pending" state = available for processing
2nd: "Working" : some poller is working on the row (or ab-ended while working)
3rd: "Error" : some poller tried to process, and found an error during processing
4th: "Done" : this row has already been processed successfully
2) if you wish to further filter your ResultSet, you can add an optional list of
conditions that will be included in the "scan" SQL statement (without "where")
3) Comma separated list of fields to order ResultSet (without "order by") |
SqlTablePoller.ROW_STATE |
First character of these values are the default states of a table row trigger
the "inProcessVals" parameter can override these (if that were ever necessary)
this is why the default value for that parameter is "PWED" (see below)
The poller will only process rows that have the "inProcessField" first character
equal to the first character of whatever the "Pending" state is (typically "P") |
SqlTablePoller.TABLE_ATT |
Mandatory attributes needed for SqlTablePoller
1) Table name
2) Comma separated list of fields needed in the ResultSet
3) Comma separated list of fields that constitute a unique ID of the working row
all fields in this list MUST also be in the "selectFields" list
these fields will be used in the "where" clause of update statements
4) Name of table field used as indicator/semaphore to avoid concurrent update |