Environment Variables

c-treeACE SQL can set environment variables for the server process on startup. This functionality is implemented via the keyword SETENV.For example, the c-treeACE SQL looks at the CLASSPATH to find required classes for proper operation of the server. When the c-treeACE SQL is running as a Windows 32 bit versions Service, c-treeACE SQL is launched automatically by the SCM (Service Control Manager) when the computer starts up. Setting the CLASSPATH via a keyword eliminates the manual operation of setting environment variables. The syntax is as follows:

SETENV <var>=<value>

Where var is the environment variable and value is the setting. For example:

SETENV CLASSPATH=%CLASSPATH%;C:\FairCom\ctreeJQL\classes

The input line length for the server configuration file is 1024 to allow for very long configuration values.

The c-treeACE SQL considers existing environment variables during startup processing for the Java environment used with stored procedures. The following variables are used in the c-treeACE SQL configuration file, ctsrvr.cfg, to set the parameters for the Java JVM and compiler. These configurations are required for c-treeACE SQL Stored Procedures, Triggers, and User Defined Functions:

SETENV CLASSPATH=

SETENV JVM_LIB=

SETENV JAVA_COMPILER=

SETENV DEBUG_JVM

When these values are not explicitly set within the server configuration file, the server considers existing system environment variables.This feature simplifies setup and configuration changes for c-treeACE SQL Stored Procedures. Refer to the Appendix Server Configuration Keywords for a complete list of c-treeACE SQL specific keywords.