skip to main content
Connection Option Descriptions
  

Try DataDirect Drivers Now

Connection Option Descriptions

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.
The following table lists the connection string attributes supported by the Oracle Service Cloud driver.
Table 11. Oracle Service Cloud Attribute Names
Attribute (Short Name)
Default
1 (Enabled)
Empty string
0 (Disabled)
2 (NotExist)
The user ID specified for the connection.
None
None
1 (Enabled)
100
None
4 (ISO 8559-1 Latin-1)
None
None
-Xmx256m 1
install_dir\java\lib\rightnow.jar
0
ddlogging.properties
None
None
100
None. If no value is specified, the driver will not change the column size reported for SQL_LONGVARCHAR columns.
0
1 (report)
Empty string
0 (Disabled)
Empty String
0
Empty String
Empty String
1 (Enabled)
0 (Ignore Errors)
19929
0 (Direct)
-1
1 (ErrorAlways)
0 (No Transactions)
None. If no value is specified, the driver will not change the described type for VARCHAR columns
1 (compress)
0 (up to a maximum of 10,000 rows)
0
120
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.

This section includes the following topics:
In this section: 
* Application Using Threads
* Compress Data
* Config Options
* Connection Pooling
* Connection Reset
* Create Database
* Data Source Name
* Database
* Description
* Enable Paging With Order By ID
* Fetch Size
* Host Name
* IANAAppCodePage
* Initialization String
* Interface Name
* JVM Arguments
* JVM Classpath
* LoadBalance Timeout
* Log Config File
* Login Timeout
* Max Pool Size
* Min Long Varchar Size
* Min Pool Size
* Oracle Service Cloud Database
* Password
* Proxy Host
* Proxy Port
* Proxy Password
* Proxy User
* Refresh Dirty Cache
* Report Codepage Conversion Errors
* Server Port Number
* SQL Engine Mode
* Statement Call Limit
* Statement Call Limit Behavior
* Transaction Mode
* User Name
* Varchar Threshold
* WSFetchSize
* WSRetry Count
* WSTimeout