skip to main content
Connection property descriptions
  

Try DataDirect Drivers Now

Connection property descriptions

You can use connection properties to customize the driver for your environment. This section lists the connection properties supported by the driver and describes each property. You can use these connection properties with either the JDBC Driver Manager or a JDBC data source. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value). Connection property names are case-insensitive. For example, Password is the same as password.
Note: In a JDBC DataSource, string values must be enclosed in double quotation marks, for example, setUser("123@abccorp.com").
Note: The data type listed in each of the connection property descriptions is the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the driver, their corresponding data source methods, and their default values.
Table 11. Driver Properties
Connection String Property
Data Source Method
Default Value
setConfigOptions
APIVersion=latest
setCreateMap
notExist
setLogConfigFile
ddlogging.properties
setPassword
No default value
setProxyHost
No default value
setProxyPassword
No default value
setProxyPort
No default value
setProxyUser
No default value
setSchemaMap
For Windows:
application_data_folder\
Local\Progress\DataDirect\
Oracle_Sales_Cloud_Schema\user_name.config
For UNIX/Linux:
˜/progress/datadirect/
oracle_sales_cloud_schema/
user_name.config
setServerName
No default value
setSpyAttributes
No default value
setUser
No default value
setWSFetchSize
100 (rows)
setWSRetryCount
0
setWSTimeout
120 (seconds)
* ConfigOptions
* CreateMap
* LogConfigFile
* Password
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* SchemaMap
* ServerName
* SpyAttributes
* User
* WSFetchSize
* WSRetryCount
* WSTimeout