getQueryOptions

getQueryOptions(concurrency: Integer output;
                limitOption: Integer output;
                limitValue:  Integer output);

The getQueryOptions method of the JadeReportWriterReport class returns the locking concurrency and current resource limit option values that are to be applied to the report at the query phase of the report run.

If you want to override these values at run time, you can call the setQueryOptions method and pass as the appropriate parameters the values that you require.

The concurrency parameter values used to lock objects during the query process are listed in the following table.

Class Constant Value Concurrency Strategy Description
CONCURRENCY_NONE 1 Nothing Does nothing during the query evaluation
CONCURRENCY_READ_COMMITTED 3 Read Committed Resynchronizes every object that is accessed, but holds on to locks on collections
CONCURRENCY_READ_OPTIMISTIC 4 Repeatable Read Optimistic Resynchronizes every object that is accessed, locks objects needed later, and checks the edition (the default value)
CONCURRENCY_READ_PESSIMISTIC 5 Repeatable Read Pessimistic Brackets a read-only transaction to ensure that objects referenced after the start of the query and before the end of the query are the latest editions of the objects (that is, acquires an implicit shared lock on each object as it is referenced)

The limitOption and limitValue parameter values, respectively, are listed in the following table.

Class Constant Value Resource to Limit Limit Value (as an Integer)
RESOURCE_LIMIT_NONE 0 No resource limits defined Not applicable (that is, ignored), which is the default value
RESOURCE_LIMIT_READS 1 Object reads from the database Maximum number of objects to read
RESOURCE_LIMIT_RESULTS 2 Result objects to add to the query result Maximum number of result objects to add
RESOURCE_LIMIT_TIME 3 Time that the query runs Maximum number of milliseconds the report query runs
RESOURCE_LIMIT_QUERYOPS 4 Query operations performed Maximum number of query operations