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 DriverManager or a JDBC DataSource. For a DriverManager 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, setCompany("ABCCorp").
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 13. Driver properties
Connection String Property
Data Source Method
Default Value
setBulkActivityPageSize
50000 (rows)
setBulkPageSize
5000 (rows)
setBulkTimeout
1800 (seconds)
setBulkTopThreshold
1000 (rows)
setCompany
No default value
setConfigOptions
CheckBoxAsText=0;
KeywordConflictSuffix=
setCreateMap
notExist
setFailOnIncompleteData
0
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\
Eloqua_Schema\user_name.config
For UNIX/Linux:
˜/progress/datadirect/
eloqua_schema/
user_name.config
setSpyAttributes
No default value
setUser
No default value
setWSFetchSize
1000 (rows)
setWSRetryCount
0
setWSTimeout
120 (seconds)
* BulkActivityPageSize
* BulkPageSize
* BulkTimeout
* BulkTopThreshold
* Company
* ConfigOptions
* CreateMap
* FailOnIncompleteData
* LogConfigFile
* Password
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* SchemaMap
* SpyAttributes
* User
* WSFetchSize
* WSRetryCount
* WSTimeout