The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following table lists the connection string attributes supported by the Oracle Service Cloud driver.

Table 1. Oracle Service Cloud Attribute Names
Attribute (Short Name) Default
ApplicationUsingThreads (AUT) 1 (Enabled)
ConfigOptions (CO) Empty string
ConnectionReset (CR) 0 (Disabled)
CreateDB (CDB) 2 (NotExist)
Database (DBN) The user ID specified for the connection.
DataSourceName (DSN) None
Description (n/a) None
EnableAccessRequestHeader true
EnablePagingWithOrderByID (EPWO) 1 (Enabled)
FetchSize (FS) 100
HostName (HOST) None
IANAAppCodePage (IACP) 4 (ISO 8559-1 Latin-1)
InitializationString (IS) None
InterfaceName (IN) None
JVMArgs (JVMA)
-Xmx256m 1
JVMClasspath (JVMC) install_dir\java\lib\rightnow.jar
LoadBalanceTimeout (LBT) 0
LogConfigFile (LCF) ddlogging.properties
LogonID (UID) None
LoginTimeout (LT) None
ManagedObjects (MO) None
MaxPoolSize (MXPS) 100
MinLongVarcharSize (MINLVS) None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
MinPoolSize (MNPS) 0
OracleServiceCloudDatabase (OSCDB) 1 (report)
Password (PWD) Empty string
Pooling (POOL) 0 (Disabled)
ProxyHost (PXHN) Empty String
ProxyPort (PXPT) 0
ProxyPassword (PXPW) Empty String
ProxyUser Empty String
RefreshDirtyCache (RDC) 1 (Enabled)
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ServerPortNumber (SPN) 19929
SQLEngineMode (SEM) 0 (Direct)
StmtCallLimit (SCL) -1
StmtCallLimitBehavior (SCLB) 1 (ErrorAlways)
TransactionMode (TM) 0 (No Transactions)
VarcharThreshold (VT) None. If no value is specified, the driver will not change the described type for VARCHAR columns
WSCompressData (WSCD) 1 (compress)
WSFetchSize (WSFS) 0 (up to a maximum of 10,000 rows)
WSRetryCount (WSRC) 0
WSTimeout (WST) 120

This section includes the following topics:

1 The default value for this option is determined by the setting of the SQLEngineMode connection option. When set to direct mode

(SQLEngineMode=0), the default value is -Xmx256m . When set to server mode (SQLEngineMode=1), the default value is -Xmx1024m.