RAD Studio VCL Reference
|
Specifies names of system properties that should be applied to all databases open in a process.
SystemProperties = class;
class SystemProperties;
SystemProperties.cs
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:
AppDomain.CurrentDomain.SetData("blackfishsql.port", "2508");
These settings can also be specified in the launcher config files as:
<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:
System.setProperty("blackfishsql.port", "2508");
These settings can also be specified in the launcher config files as:
vmparam -Dblackfishsql.port=2508
SystemProperties can be specified in the BSQLServer.exe.config file. Here is an example after a clean install:
<?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 |
Sets the minimum number of cache blocks in the cache. Note that all databases opened in the same process share the same cache. | |
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 (32*1024). Default is 12M (12*1024*1024). | |
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. | |
Specify the port to communicate with a remote server. Default is 2508. | |
If this directory location is specified, it is the only directory searched for licenses. | |
If this directory location is specified, this is used to replace the macro |DataDirectory| at the beginning of a database file name specification. |
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
What do you think about this topic? Send feedback!
|