A public API is available which contains utility methods for the transaction SQL query cache. The class, curam.util.transaction.SQLQueryCacheUtil, provides utility methods for the transaction SQL query cache. These methods include the following:
- isSQLQueryCacheEnabled(): This function returns a flag to indicate if the transaction SQL query cache has been enabled or not.
- runWithSQLQueryCacheDisabled(Runnable run): This function runs the runnable bypassing the SQL query cache. SQLQueryCache may be needed to be disabled when there is a need to read the same row multiple times in a transaction to see if it has changed. For example, in the batch infrastructure it is required to read the same row multiple times in a transaction to see if it has changed.