JDBC datasource is not connecting to any encrypted database

No encryption support is present when using a Mid Server with JDBC DB2 database connection.

 

 

There is no support for an important feature:

It is not possible to create a JDBC connection (DB2) to an encrypted database.
No connections can be made to encrypted databases.

I created the problem because this is essential functionality.

This is expected behaviour. This problem can be solved by specifying the required encryption properties in the data source:

1. In the Data Source form, make the Properties field visible through context-menu/Configure/Form Layout.
2. Specify any required properties using the following format: key1=value1,key2=value2.

These properties are then passed to the DriverManager whenever a connection is established.

For DB2, it might be helpful to use the suggestion below, where the properties as specified should work, assuming Username and Password are filled in the form.

securityMechanism=com.ibm.db2.jcc.DB2BaseDataSource.ENCRYPTED_USER_AND_PASSWORD_SECURITY,encryptionAlgorithm=2

Ref: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/java/src/tpc/imjcc_cjvjcsen.html