finalRepositoryProperties property

Specifies the location of the pureQuery properties used with a pureQuery-enabled application.

The pureQuery-enabled application can retrieve the pureQuery properties from a local file system, a remote file system, and a repository that was created in a database.

PureQuery runtime processes finalRepositoryProperties property after it processes pureQuery properties from all the supported locations for specifying pureQuery properties.

If the finalRepositoryProperties property specifies a repository that is created in a database, an exception is thrown if the pureQueryXml property is also specified.

The following values are valid for finalRepositoryProperties:

ds://DataSource-name
Specifies a database using a JNDI (Java Naming and Directory Interface) data source name. A JNDI Directory Service must be registered such that data sources can be accessed by name. The database must contain a repository. The database user connecting to the repository must have the appropriate database privileges to access the repository. The pureQuery runtime properties and optionally the pureQueryXML data are retrieved from the database and used by pureQuery Runtime.

Most application servers support JNDI Data Source lookup.

The runtime group ID must also be specified with the propertiesGroupId property or an exception is thrown

The following are examples of a DataSource URL:

ds://AccountsPayableAppl1
ds://jdbc/sample
file://directory-path
Specifies a platform-specific directory path. The following are examples for a UNIX and Windows file system:
  • A relative path for a UNIX system:
    file://applicationProperties/application1
  • An absolute path for a UNIX system:
    file:///etc/services
  • A relative path for a Windows system:
    file://applicationProperties/application1.properties
  • Absolute path names for a Windows system:
    file:///C:/WINDOWS/system32/drivers/etc/services
    file:///C:/Documents and Settings/All Users/IBM/installRegistry.xml
Note: The platform-specific directory path supports spaces in the file name.
jdbc:JDBC-URL
Specifies a database using a JDBC URL. The database must contain a repository. The database user connecting to the repository must have the appropriate database privileges to access the repository. The pureQuery runtime properties and optionally the pureQueryXML are retrieved from the database and used by pureQuery Runtime.

The runtime group ID must also be specified with the propertiesGroupId property or an exception is thrown

The following example is a JDBC URL:
jdbc:db2://localhost:50000/SAMPLE:user=username;password=passwd;

Processing of the finalRepositoryProperties property

The pureQuery Runtime processes the finalRepositoryProperties property in the following way:
  1. Before retrieving and setting the pureQuery runtime properties from the location specified by the finalRepositoryProperties property, pureQuery client optimization and existing pureQuery runtime properties are reset to default values. Properties that are retrieved and set as global pureQuery properties are not affected. The following repository-defining properties are retained:
    • The finalRepositoryProperties property cannot be changed.
    • The propertiesGroupId property cannot be changed.
    • The repositoryRequired property cannot be reset to its default value.
    • The propertiesRefreshInterval property can be changed by specifying the property in a retrieved set of properties.
  2. Properties retrieved and set from the location specified by the finalRepositoryProperties property affect only the application that sets them.
  3. Properties are ignored if the property is not valid for pureQuery client optimization, and the property is retrieved from the location specified by the finalRepositoryProperties property. If logging is enabled, a message is written to the log file.
  4. The finalRepositoryProperties property does not support multiple levels of indirection. The finalRepositoryProperties property is ignored if the property is also specified as one of the properties that are retrieved when you use the finalRepositoryProperties property.
  5. The propertiesGroupId property is ignored if it is specified in the properties that are retrieved when using the finalRepositoryProperties property.
  6. The propertiesRefreshInterval property can be specified in the properties that are retrieved using the finalRepositoryProperties property.
  7. The repositoryRequired property can be specified in the set of properties that are retrieved when using the finalRepositoryProperties property.

Feedback