ScriptRunner - sqlAttributes

attributeGroup sqlAttributes

annotation

documentation

Documentation only: attributes for type=SQL tasks

attribute sqlAttributes/@binds

type

xs:string

properties

isRef	0
use	optional

annotation

documentation

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 binds="bind1,bind2,bind3". Unlike parameters, bind variables are substituted by name, not position.

attribute sqlAttributes/@dataSourceName

type

xs:string

properties

isRef	0
use	optional

annotation

documentation

The name of the dataSource to be used. This must match a connection's dataSourceName attribute.

attribute sqlAttributes/@postcheck

type

xs:string

properties

isRef	0
use	optional

annotation

documentation

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

attribute sqlAttributes/@precheck

type

xs:string

properties

isRef	0
use	optional

annotation

documentation

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

attribute sqlAttributes/@statement-split

type

xs:string

properties

isRef	0
use	optional

annotation

documentation

Java regular expression for identifying individual SQL statements in full SQLTask body.