1.1

sqlfire.properties
Overrides the default lookup for application file properties in the file named
'sqlfire.properties.'
Description
sqlfire.propertiesDefault Value
systemProperty Type
n/aPrefix
sqlfire.query-cancellation-interval
After used memory used passes a critical limit, SQLFire begins cancelling queries to free memory. This
attribute specifies the period in milliseconds after which SQLFire cancels a query during periods of critical
Description
memory usage. With the default value, SQLFire cancels a query every 100 milliseconds when necessary
to free memory.
100Default Value
connection (boot)Property Type
n/aPrefix
sqlfire.security. Properties (prefix)
All properties that are prefixed with sqlfire.security. are propagated to the plug-in
implementation of UserAuthenticator on page 450 and CredentialInitializer on page 450.
Description
not setDefault Value
connection (boot)Property Type
sqlfire.security.Prefix
sqlfire.single-hop-max-connections
If sqlfire.single-hop-max-connections is set to true, then this system property specifies the maximum number of single-hop
client connections that a server can support. The default value of 5 creates enough connections for 5 single-hop clients
Description
to distribute queries to other SQLFire members in the cluster. Set this value to the maximum number of single-hop
clients that you want to support at one time.
Note that the actual number of connections that may be created for single-hop clients is determined by the number of
members in the SQLFire distributed system. For example, if the SQLFire cluster has 10 members, then the default
single-hop-max-connections setting of 5 means that a maximum of 50 connections could be created
for single-hop access (5 simultaneous single-hop clients connecting to all servers in the cluster). However, the actual
connection resources are created only when necessary. See Connect to a SQLFire Server with the Thin Client JDBC
Driver on page 113.
5Default Value
systemProperty Type
n/aPrefix
345
Configuration Properties