Configuring server mode using the Configuration Manager
In server mode, you must start the SQL engine server before connecting. Before starting the SQL engine server, choose a directory to store the local database files using the Schema Map (SchemaMap) option. Make sure that you have the correct permissions to write to this directory.
Note: The Configuration Manager is currently supported only on Windows platforms. To configure the SQL Engine on Linux platforms, see "Configuring the SQL Engine Server using Java options."
The following sections describe how to configure, start, and stop the SQL Engine Server using the Configuration Manager.
1. Open your data source using the Configuration Manager; then, select the SQL Engine tab.
2. Set the SQL Engine Mode (SQLEngineMode) connection option to one of the following values:
0 - Auto: The SQL engine attempts to run in server mode first, but will failover to direct mode if server mode is unavailable.
1 - Server: The SQL engine mode runs exclusively in server mode.
Note: By default, SQL Engine Mode is set to 0 - Auto for Windows and 2 - Direct for Linux.
The fields associated with server mode will become editable, and the Start button appears.
3. Provide values for the following options:
Server Port Number: Specifies a valid port on which the SQL engine listens for requests from the driver. The default value depends on your platform:
32-bit: 19952
64-bit: 19951
JVM Classpath: Specifies the CLASSPATH for the JVM used by the driver. See "JVM Classpath" for details. The default depends on your platform:
JVM Arguments: A string that contains the arguments that are passed to the JVM that the driver is starting. The location of the JVM must be specified on your PATH. See "JVM Arguments" for details. The default value is:
-Xmx1024m
JVM Path: Specifies fully qualified path to the Java SE 8 or higher JVM executable that you want to use to run the SQL Engine Server. The path must not contain double quotation marks.
4. Optionally, if connecting through a proxy server, provide values for the following options:
Server Proxy Host: Specifies the host name of the proxy server used by the SQL engine. The value specified can be a host name, a fully qualified domain name, or an IPv4 or IPv6 address.
Server Proxy Port: Specifies the port needed to connect to the proxy server used by the SQL engine.
Server Proxy User: Specifies the user name needed to connect to the proxy server used by the SQL engine.
Server Proxy Password: Specifies the password needed to connect to the proxy server used by the SQL engine.
5. Click Save to save your changes
6. Click Start to run the SQL Engine service. A message is displayed that indicates whether the SQL Engine was able to successfully run.
0 - Auto: The SQL engine attempts to run in server mode first, but will failover to direct mode if server mode is unavailable.
