SystemProperties Class

Specifies names of system properties that should be applied to all databases open in a process.

Pascal

SystemProperties = class;

C++

class SystemProperties;

File

SystemProperties.cs

Description

This class specifies the names of system properties that should be applied to all databases open in a process. Some of these properties can also be specified as a connection property as well.

Blackfish SQL for Windows calls the AppDomain.CurrentDomain.GetData method with the string "blackfishsql." prepended to the property name to obtain system property settings. Here is how to set the default server port:

Copy Code

 AppDomain.CurrentDomain.SetData("blackfishsql.port", "2508");

These settings can also be specified in the launcher config files as:

Copy Code

<appSettings> <add key="ServiceName" value="BlackfishSQL" />
            <add key="blackfishsql.port" value="2508" /> <add
            key="blackfishsql.tempDir" value="" /> </appSettings>

Blackfish SQL for Java calls the java.lang.System.getProperty method with the string "blackfishsql." prepended to the property name to obtain system property settings. Here is how to set the default server port:

Copy Code

 System.setProperty("blackfishsql.port", "2508");

These settings can also be specified in the launcher config files as:

Copy Code

 vmparam -Dblackfishsql.port=2508

SystemProperties can be specified in the BSQLServer.exe.config file. Here is an example after a clean install:

Copy Code

<?xml version="1.0" encoding="utf-8" ?> <configuration>
            <startup> <supportedRuntime version="v2.0.50727" />
            <supportedRuntime version="v1.1.4322" /> <supportedRuntime
            version="v1.0.3705" /> </startup> <appSettings> <add
            key="ServiceName" value="BlackfishSQL" /> <!— Blackfish SQL system properties are
            documented in the Borland.Data.DataStore.SystemProperties class. Empty or missing values
            cause default settings to be used. --> <add key="blackfishsql.minCacheSize"
            value="" /> <add key="blackfishsql.maxSortBuffer" value="" /> <add
            key="blackfishsql.tempDir" value="" /> <add key="blackfishsql.licenseDirectory"
            value="" /> <add key="blackfishsql.port" value="2508" /> <add
            key="blackfishsql.dataDirectory" value="" /> </appSettings>
            </configuration>

This table contains system property names.

System Property Name	Description
MinCacheSize	Sets the minimum number of cache blocks in the cache. Note that all databases opened in the same process share the same cache.
MaxSortBuffer	Maximum sort buffer size in bytes. When sorting operations are performed for operations like index building, this is the maximum memory in bytes that is used for a sort buffer. Increasing this number may speed up very large sorts. Cannot be set to less than 32K (321024). Default is 12M (121024*1024).
TempDir	Specify directory for temp files. Used for operations like large sorts. If this is not set, the directory of the DATABASE property is used for temporary files.
Port	Specify the port to communicate with a remote server. Default is 2508.
LicenseDirectory	If this directory location is specified, it is the only directory searched for licenses.
DataDirectory	If this directory location is specified, this is used to replace the macro \|DataDirectory\| at the beginning of a database file name specification.

What do you think about this topic? Send feedback!