Simple name-value pair List of properties The standard JDBC 3 configuration properties Name of a connection the parent task and any children may use. This name would usually be unique. The name of a particular database on a server A description of this data source and what it will be used for. Te network protocol used to communicate with the server The user's database password The port number where a server is listening for requests Tthe initial SQL role name The database server name The user's account name. An enumeration of DBMS types General connection properties, with attributes for the standard JDBC3 connections. If a setter cannot be found by reflection, an error will be reported and processing will stop. Individual JDBC DataSource implementations usually have their own set of non-standard configuration properties, which should be added here. If a setter cannot be found by reflection, an error will be reported but processing will continue. Allow for the possibility of extension Class implementing javax.sql.ConnectionPoolDataSource or, in the worst case, simply javax.sql.DataSource. If provided, sets the DBMS type definitively for this connection. Otherwise, the DBMS type is guessed form the dataSource class name or the Connection class name. Allow for the possibility of extension. List of connections The standard JDBC 3 DataSource configuration properties are attributes. If a setter cannot be found by reflection, an error will be reported and processing stopped. Documentation only: attributes for type=If tasks The name of a property. If the value of the property matches one of the values in the ifvalue list, the contained task will be executed. If ifvalue is not set, the contained task will be executed if the ifname property is set to any value. If the ifname property is not in the ifvalue list, this Task will return successfully without processing the child task. A list of values the ifname property must take if the child is to be executed. Documentation only: attributes for type=Poll tasks The PollTask polls the child Task every poll seconds for up to duration seconds. It succeeds if the child Task succeeds within the given duration. The PollTask polls the child Task every poll seconds for up to duration seconds. It succeeds if the child Task succeeds within the given duration. Documentation only: attributes for type=Process tasks If true, echo the process error stream to stderr. If true, echo the process output stream to stdout. Documentation only: attributes for type=SQL tasks A comma-separated list of bind variables. Within the SQL, these will be in the Oracle form 'SQL SQL :bind1 SQL :bind3 SQLSQL :bind2;' with the attribute bind="bind1,bind2,bind3". Unlike parameters, bind variables are not substituted based no position but by name. The name of the dataSource to be used. This must match a connection's dataSourceName attribute. The name of a database function to be checked after the main SQL returns successfully. The result will override the script result. The function signature must be: FUNCTION f(run_id IN INTEGER, task IN VARCHAR2) RETURNS INTEGER The name of a database function to be checked before the main SQL is executed. The main SQL will only be executed on success, i.e. 0 is returned. The function signature must be: FUNCTION f(run_id IN INTEGER, task IN VARCHAR2) RETURNS INTEGER Java regular expression for identifying individual SQL statements in full SQLTask body. Basic unit and super-class Arbitrary properties Tasks may contain tasks Allow for the possibility of extension and for inclusion of tasks. The task's identifying name. Usually each task will have a globaly unique name as the check to see whether a task has finished successfully is by run identifier and name only. However, there can be benefits in having duplicate names, e.g. so that a setup script can be called from multiple places. Hence, this is not an ID. If present, the class value will be used to instantiate a Task object. This allows any class implementing the Task interface to be called. One of the type or the class attributes MUST be set. If present, the type value will imply a class name com.massimo.tools.scriptrunner.work."value"Task. Some types and classes are provided: Serial, Parallel, Pause, Print, Process and SQL. One of the type or the class attributes MUST be set. Comma-separated list of jar files to add to the classpath for this Task. Comma-separated list of integer error codes. Tasks will attempt to ignore these codes. If false, the Task will not maintain the audit trail log. The script itself must do this. List of property names for string substitution. Substitution is performed using the class java.text.MessageFormat, so the order of parameters is important. Allow for the possibility of extension. Each Task class may have its own set of properties, which may be added here. Required for validating separate property files. Required for validating separate properties files. Required for validating separate connection files. Required for validating separate connections files. The base element, representing what is to be executed and how. Each task element maps directly to a Task object at runtime.