IBM Data Server Driver for JDBC and SQLJ enhancements for Db2 11.5.9
The IBM Data Server Driver for JDBC and SQLJ contains security and usability enhancements for the Db2 11.5.9 mod pack release.
Attention: This mod pack release is currently available for
the following Db2 products:
- Db2 Distributed (on-premises)
- The single container deployment of Db2 Warehouse.
- The container micro-service deployment of Db2 on Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
- Db2 for cloud service providers
- Db2 on Cloud
- Db2 Warehouse on Cloud
11.5.9 enhancements
| Enhancement | Description |
|---|---|
| Changed default security mechanism for better security. | The default security mechanism for connections to a data server with the IBM Data Server Driver for JDBC and
SQLJ is changed from
CLEAR_TEXT_PASSWORD_SECURITY to
ENCRYPTED_USER_AND_PASSWORD_SECURITY, if the data server supports
ENCRYPTED_USER_AND_PASSWORD_SECURITY.For more information, see Security under the IBM Data Server Driver for JDBC and SQLJ. |
| SQLJ profile customizer option to control the driver action for an input data type and column data type mismatch. | The onTypeMismatch option is added to the SQLJ profile customizer
(db2zsqljcustomize). This option specifies the action that the driver takes when there is a mismatch
between a host variable data type and the data type of the column to which the host variable is
bound. For more information, see db2sqljcustomize - SQLJ profile customizer. |
| Property to control the driver action when truncation of input data occurs. | The Connection and data DataSource property onDataTruncation and configuration property db2.jcc.onDataTruncation specify the action that the driver takes when an input value is
inserted into a column, and the value is too large for that column.For more information, see Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products. |
| Driver support for IBM Semeru Runtimes. | The IBM Data Server Driver for JDBC and SQLJ supports the IBM Semeru Runtimes. Applications that use the IBM Data Server Driver for JDBC and SQLJ can now migrate to version 21 of the IBM Semeru Runtimes. |
| Empty user value allowed for CP4D connections with plug-in security. | For IBM Data Server Driver for JDBC and SQLJ connections that use plug-in security (securityMechanism value is PLUGIN_SECURITY (15)) to connect to IBM Cloud Pak for Data (CP4D) servers, a value does not need to be specified for the user property. |
| Driver certification for more platforms. | The IBM Data Server Driver and JDBC and SQLJ is now supported for:
|