repositoryRequired property

Specifies the pureQuery client optimization behavior if errors occur during retrieving or writing pureQuery data. If the pureQuery runtime properties and pureQueryXML data cannot be retrieved from the location specified by the finalRepositoryProperties property, or if the repository that stores captured SQL is not accessible.

This property is recognized only if the finalRepositoryProperties property is also specified, otherwise it is ignored.

This property can take these values:

atStartup
Specifies that the location specified by finalRepositoryProperties property is required at application startup. If the pureQuery properties are not available or read errors are detected an exception is thrown.
forOutput
Specifies that writing the first captured SQL data to the repository must be successful. If the repository is not available or write errors are detected an exception is thrown. If the repository becomes unavailable after application startup, an error is logged if logging is enabled. The application continues and writing the captured SQL is tried at the next scheduled time.
atStartupAndForOutput
Specifies that both the atStartup and forOutput values are enabled.
no
Specifies the default behavior if the location specified by the finalRepositoryProperties property is not available at application startup. The following list describes the default behavior:
  • The application runs with the default pureQuery client optimization and pureQuery runtime configuration. The application runs dynamic SQL.
  • If logging is enabled, a message is logged indicating the problem with the repository.
  • If a timer thread can be created, an attempt is made to retrieve the pureQuery runtime properties and pureQueryXML data every 10 minutes. If the information is retrieved, pureQuery client optimization uses the retrieved pureQuery runtime properties and pureQueryXML data.
  • If pureQuery client optimization is configured to store captured SQL data in a repository, and the repository is not available, or a write error is detected, a message is logged indicating the problem with the repository. Writing of the captured SQL data to the repository is attempted at the next scheduled time.

Usage notes

The following list contains information about using the repositoryRequired property:


Feedback