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) as per your requirements.
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#;
|
Oracle
|
Oracle
|
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#};
|
Sybase
|
Sybase
|
EncryptionMethod=SSL;TrustStore=path to keystore; TrustStorePassword=trustStorePassword; ValidateServerCertificate=true|false; HostNameInCertificate=host_name|#SERVERNAME#;
|
MySQL
|
MySQL (4/5)
|
useSSL=true&requireSSL=true|false& verifyServerCertificate=true|false&clientCertificateKeyStoreUrl=URLToClientCertificate&clientCertificateKeyStoreType=KeyStoreType&clientCertificateKeyStorePassword=keystorePassword&trustCertificateKeyStoreUrl=URLToRootCertificate&trustCertificateKeyStoreType= KeyStoreType&trustCertificateKeyStorePassword=trustedRootCertificatePassword
Note: Not
all MySQL (4/5) properties listed are supported by all MySQL versions.
See MySQL documentation for details of the supported properties
for your version.
|
Note: If the database driver attempts to connect to a database
server that does not support SSL, connection might hang. You can
avoid issues when connecting to a server that does not support SSL
by setting a login timeout.
For more information on enabling SSL for DB2, Microsoft SQL Server,
Oracle, and Sybase, see the DataDirect documentation available at
the following URL:
http://media.datadirect.com/download/docs/jdbc/alljdbc/wwhelp/wwhimpl/js/html/wwhelp.htm
For more information on enabling SSL for MySQL, see MySQL documentation available
at the following URL:
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html