setQueryOptions

setQueryOptions(concurrency:        Integer;
                resourceLimitType:  Integer;
                resourceLimitValue: Integer);

The setQueryOptions method of the JadeReportWriterReport class sets specific limits in the execution of a query when running the report.

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 resourceLimitType and resourceLimitValue 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

Use the getQueryOptions method to get the locking concurrency and resource limits that are to be applied at the query phase of the report run.