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

ValidateServerCertificate

Optional

true|false

Determines whether the driver validates the certificate sent by the database server

DB2, Microsoft SQL Server, Oracle, Sybase

HostNameInCertificate

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

requireSSL

Optional

true|false

Require SSL connection if useSSL=true

MySQL

verifyServerCertificate

Optional

true|false

Determines whether to validates the certificate sent by the database server

MySQL

clientCertificateKeyStoreUrl

Applies only if client authentication is enabled on the database server

URL to the client certificate KeyStore. If not specified, use defaults.

MySQL

clientCertificateKeyStoreType

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

clientCertificateKeyStorePassword

Applies only if client authentication is enabled on database server

Password for the client certificate KeyStore

MySQL (4/5)

trustCertificateKeyStoreUrl

Applies only if verifyServerCertificate=true

URL to the trusted root certificate KeyStore. If not specified, use defaults.

MySQL (4/5)

trustCertificateKeyStoreType

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)

trustCertificateKeyStorePassword

Required if verifyServerCertificate=true

Password for the trusted root certificate KeyStore

MySQL (4/5)