SQL database polling client adapter. Repeatedly executes a query against a remote database via an ODBC- or JDBC- defined DSN (Data Source Name) and processes each resulting row.
These are the production settings for this object
If specified, used to delete rows after processing. Must have exactly one parameter for IDKey value
The name of the IDKey field in the query's resultset. Must be unique (non-reused) over time if DeleteQuery is empty.
A comma-separated list of parameter value specifiers, if any. These correspond to any replaceable ? parameters in the query string. %
refers to Adapter properties such as %LastKey; $ refers to Service class properties; & refers to persistent values saved between invocations.
The Base query string that will be repeatedly executed to look for new rows
Set persistent value (default name=%LastKey) to new value only if it is currently undefined. Return old value if any.
This user callback method is called just after %OnNew()
default InboundAdapter behavior: always call ProcessInput on CallInterval
This user callback method is called just before %OnClose()