System information

49
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
• setOracle()
• setSybase()
• setInformix()
• setMSSQL()
Note: The qtimeout option is not supported by all databases.
For more information about DataDirect JDBC Connect, see:
• http://www.datadirect.com/techres/jdbcproddoc/index.ssp (for PDF)
• http://media.datadirect.com/download/docs/jdbc/alljdbc/wwhelp/wwhimpl/js/html/wwhelp.htm (for HTML)
Enabling SSL Connection
Do the following to enable SSL connection:
1 In the ColdFusion Administrator, go to Data & Services > Data Sources.
2 Select the data source to enable SSL Connection.
3 In the data source page, click Show Advanced Settings.
4 In the Connection String text box, specify the connection properties as per the SSL requirements.
Connection properties
The following table provides details of the connection properties and specifies which database the properties apply to:
Property Relevance Description Applies to
KeyStore Applies only if client authentication is enabled
on database server
The directory of the keystore file to be used DB2, Oracle
KeyStorePassword Applies only if client authentication is enabled
on database server
The password to access the keystore file DB2, Oracle
KeyPassword Optional
Used if keys in keystore file have a different
password than the keystore file
The password to access the individual keys in
the keystore file
DB2, Oracle
TrustStore Ignored if
ValidateServerCertificate=false
The directory of the truststore file DB2, Microsoft SQL
Server, Oracle, Sybase
TrustStorePassword Ignored if
ValidateServerCertificate=false
The password to access the truststore file DB2, Microsoft SQL
Server, Oracle, Sybase
ValidateServerCertifi
cate
Optional true|false
Determines whether the driver validates the
certificate sent by the database server
DB2, Microsoft SQL
Server, Oracle, Sybase
HostNameInCertificat
e
Optional
Applies if EncryptionMethod=SSL and
ValidateServerCertificate=true
host_name | #SERVERNAME#
Host name for certificate validation
DB2, Microsoft SQL
Server, Oracle, Sybase
useSSL Required for enabling SSL true|false
Use SSL when communicating with the
server
MySQL