System information

50
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
Specifying connection properties
The following table details the connection properties that you must specify for each database driver to enable SSL
connection. The table provides all possible values for each driver. Specify the optional values (see the table in the
section
“Enabling SSL Connection” on page 49) as per your requirements.
requireSSL Optional true|false
Require SSL connection if useSSL=true
MySQL
verifyServerCertificat
e
Optional true|false
Determines whether to validates the
certificate sent by the database server
MySQL
clientCertificateKeySt
oreUrl
Applies only if client authentication is enabled
on the database server
URL to the client certificate KeyStore. If not
specified, use defaults.
MySQL
clientCertificateKeySt
oreType
Optional
Depends on the keystore type supported by
your JVM
KeyStore type for client certificates. NULL or
empty means use default. Standard keystore
types supported by the JVM are "JKS" and
"PKCS12". Your environment might have
more types available depending on the
security products available to the JVM.
MySQL
clientCertificateKeySt
orePassword
Applies only if client authentication is enabled
on database server
Password for the client certificate KeyStore MySQL (4/5)
trustCertificateKeySt
oreUrl
Applies only if
verifyServerCertificate=true
URL to the trusted root certificate KeyStore. If
not specified, use defaults.
MySQL (4/5)
trustCertificateKeySt
oreType
Optional
Depends on the keystore type supported by
your JVM
KeyStore type for trusted root certificates.
NULL or empty means use default. Standard
keystore types supported by the JVM are
"JKS" and "PKCS12". Your environment might
have more types available depending on the
security products available to the JVM.
MySQL (4/5)
trustCertificateKeySt
orePassword
Required if
verifyServerCertificate=true
Password for the trusted root certificate
KeyStore
MySQL (4/5)
Database Database Driver Connection Property
DB2 DB2 Universal
Database
EncryptionMethod=SSL; KeyStore=path to keystore; KeyStorePassword=keystore
Password; KeyPassword=key Password; TrustStore=path to keystore;
TrustStorePassword=trustStorePassword;
ValidateServerCertificate=true|false;
HostNameInCertificate=host_name|#SERVERNAME#};
Microsoft SQL
Server
Microsoft SQL
Server
EncryptionMethod=SSL; TrustStore=path to keystore;
TrustStorePassword=trustStorePassword;
ValidateServerCertificate=true|false;
HostNameInCertificate=host_name|#SERVERNAME#;
Property Relevance Description Applies to