skip to main content
Reference : Connection Property Descriptions
  

Try DataDirect Drivers Now

Connection Property Descriptions

The following table is an alphabetical list of connection properties with their default values. Each property is hyperlinked to its full description.
Note: The data type listed in each description is the Java data type used for the property value in a JDBC data source.
Table 15. Connection Properties with Defaults
Property
Default
AuditColumns=all;
MapCustomNamedIDFields=1;
MapSystemColumnNames=0;
UppercaseIdentifiers=true
1 (data type check is performed if column value is null)
notExist
user ID specified for the connection
true
true
100 (rows)
empty string
none
2048 (KB of memory)
empty string
false
ddlogging.properties
none
0 (no timeout)
none
0 (driver’s internal prepared statement pooling is not enabled)
report
none
empty string
empty string
0
empty string
1
-1
errorAlways
noTransactions
none
compress
0
0 (no retries for timed-out requests)
120 (seconds)
* ConfigOptions
* ConvertNull
* CreateDB
* DatabaseName
* EnableAccessRequestHeader
* EnablePagingWithOrderById
* FetchSize
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* InterfaceName
* JavaDoubleToString
* LogConfigFile
* LoginHost
* LoginTimeout
* ManagedObjects
* MaxPooledStatements
* OracleServiceCloudDatabase
* Password
* ProxyHost
* ProxyPassword
* ProxyPort
* ProxyUser
* RefreshDirtyCache
* RegisterStatementPoolMonitorMBean
* StmtCallLimit
* StmtCallLimitBehavior
* TransactionMode
* User
* WSCompressData
* WSFetchSize
* WSRetryCount
* WSTimeout