SQL Engine tab
- Last Updated: October 30, 2020
- 2 minute read
- DataDirect Connectors
- ODBC
- Oracle Service Cloud 7.1
- Documentation
The SQL Engine tab allows you to specify additional data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.
| Connection Options: SQL Engine | Default (Direct Mode) |
|---|---|
| SQL Engine Mode | Specifies whether the driver’s SQL engine
runs in the same process as the driver (direct mode) or runs in a process that is
separate from the driver (server mode). Default: 0 - Direct |
| 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 the driver library path. Values that include special characters or spaces
must be enclosed in curly braces { } when used in a connection
string. Default: -Xmx256m |
| JVM Classpath | Specifies the CLASSPATH for the Java
Virtual Machine (JVM) used by the driver. The CLASSPATH is the search string the JVM
uses to locate the Java jar files the driver needs. Separate multiple jar files by a
semi-colon on Windows platforms and by a colon on Linux and UNIX platforms. CLASSPATH
values with multiple jar files must be enclosed in curly braces { } when used in a
connection string. Default: None |
| Proxy Host | Specifies the Hostname and possibly the Domain of the Proxy
Server. The value specified can be a host name, a fully qualified domain name, or an
IPv4 or IPv6 address. Default: None |
| Proxy Port | Specifies the port number where the Proxy Server is listening
for HTTP and/or HTTPS requests. Default: None |
| Proxy User | Specifies the user name needed to connect to the Proxy
Server. Default: None |
| Proxy Password | Specifies the password needed to connect to the Proxy
Server. Default: None |
By default, the Oracle Service Cloud driver operates in direct mode, with both the driver and its SQL engine running in the ODBC application's address space. Some applications may experience problems loading the JVM because the process exceeds the available heap space. You can configure the Oracle Service Cloud driver to operate in server mode. Server mode allows the driver to connect to a 32-bit SQL engine JVM running as a separate service.
To run the driver in server mode, set SQL Engine Mode to 1 - Server. Additional configuration settings appear on the SQL Engine tab. All fields except SQL Engine Mode are read only.
To define the settings for server mode, click Edit Server Settings from the SQL Engine tab. The SQL Engine Service Setup dialog box appears.
You use the SQL Engine Service Setup dialog box to configure server mode and to start or stop the service. See "Configuring server mode" for detailed information.
| Configuration Options: SQL Engine Service | Description |
|---|---|
| SQL Engine Mode | Specifies whether the driver’s SQL engine
runs in the same process as the driver (direct mode) or runs in a process that is
separate from the driver (server mode). Default: 1-Server |
| 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 the driver
library path. Values that include special characters or spaces must be enclosed in
curly braces { } when used in a connection string. Default: -Xmx1024m |
| JVM Classpath | Specifies the CLASSPATH for the Java
Virtual Machine (JVM) used by the driver. The CLASSPATH is the search string the JVM
uses to locate the Java jar files the driver needs. Separate multiple jar files by a semi-colon on Windows platforms and by a colon on Linux and UNIX platforms. CLASSPATH values with multiple jar files must be enclosed in curly braces { } when used in a connection string. Default: install_dir\java\lib\rightnow.jar |
| Proxy Host | Specifies the Hostname and possibly the Domain of the Proxy
Server. The value specified can be a host name, a fully qualified domain name, or an
IPv4 or IPv6 address. Default: None |
| Proxy Port | Specifies the port number where the Proxy Server is listening
for HTTP and/or HTTPS requests. Default: None |
| Proxy User | Specifies the user name needed to connect to the Proxy Server. Default: None |
| Proxy Password | Specifies the password needed to connect to the Proxy Server. Default: None |
| Server Port Number | Specifies a valid port on which the SQL
engine listens for requests from the driver. Default: 19929 |
| Java Path | Specifies fully qualified path to the
Java SE 7 or higher JVM executable that you want to use to run the SQL Engine Server.
The path must not contain double quotation marks. Default: install_dir\jre\bin\java.exe |
| Server DB Directory | Specifies the path of the working
directory for the SQL engine service to use to store the newly created database files
or locate the existing database files. If the Database connection option contains a file name prefix, the user’s local database is created at the path specified by Server DB Directory. However, if the Database connection option contains a fully qualified path, the user’s local database is created using that path; the path specified by Server DB Directory is ignored. Default: Path of the working directory for the SQL Engine service. |
If you finished configuring your driver, proceed to Step 6 in "Data source configuration through a GUI". Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:
- General tab allows you to configure options that are required for creating a data source.
- Advanced tab allows you to configure advanced behavior.
- Web Service tab allows you to configure web service behavior.
- Pooling tab allows you to configure connection pooling behavior.