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 |