Some applications may experience problems loading the JVM required for the SQL engine because the process exceeds the available heap space. If your application experiences problems loading the JVM, you can configure the driver to operate in server mode.
The driver supports the following SQL Engine modes:
Server mode: The driver's SQL engine runs in a separate process with its own JVM, instead of trying to load the SQL engine and JVM in the same process used by the driver.
Direct mode: The driver operates with the SQL engine and JVM running in a single process.
Auto mode: The driver attempts to run in server mode. However, if server mode is unavailable, the SQL engine will failover to run in direct mode.
By default:
Windows: The driver operates in auto mode by default.
Linux: The driver operates in direct mode by default.
Note: You must be an administrator to start or stop the service, or to configure any settings for the service.
See the following sections for details on configuring the SQL Engine Server on your platform.
Server mode: The driver's SQL engine runs in a separate process with its own JVM, instead of trying to load the SQL engine and JVM in the same process used by the driver.
