JDBC Driver 4.2.2.0100 Readme

Overview

This patch is applicable for JDBC drivers running Identity Manager 4.7.2 or later. The driver version will be changed to 4.2.2.0100 after the patch is applied.

This Readme comprises the following sections:

• Upgrading the Driver
• Technical Support Information

System Requirements

Identity Manager 4.8 or later

Upgrading the Driver

The driver upgrade process involves the following tasks:

• Upgrading the Driver Packages
• Upgrading the Driver Files

Upgrading the Driver Packages

1. Download the following packages:

   Name	Package Name	Version	Build Date	Build Number
   MySQL Base	NOVLJDBCMYBS	2.4.2	20220613	153906
   MySQL Indirect Sync InnoDB Engine Sample	NOVLMYSINSYN	2.2.1	20220613	154404
   MySQLFanout Indirect Sync InnoDB Engine Sample	NETQFIMYINSY	1.1.2	20220714	162754
   SQL Server Default	NOVLJDBCSSDC	2.4.7	20220420	161953
   SQL Server Base	NOVLJDBCSSBS	2.4.7	20220420	161927

   Note:

   • MySQL Base and MySQL Indirect Sync InnoDB Engine Sample packages are for MySQL 8.x support.
   • MySQLFanout Indirect Sync InnoDB Engine Sample has been appended to the to the original document's package details.


2. Open the project in Designer to deploy the driver.


3. Navigate to Help menu and select Check for Package Updates. Install the above JDBC packages.


4. Drag the driver from Designer Pallet > Tools.


5. Configure the driver as mention in JDBC Implementation Guide.


6. To verify driver configuration and packages, right click the connector line and navigate to Properties > Packages.

Upgrading the Driver Files

1. Take a back-up of the current driver configuration.


2. (Conditional) If the driver is running locally, stop the driver instance and the Identity Vault.


3. (Conditional) If the driver is running with a Remote Loader instance, stop the driver and the Remote Loader instance.


4. Download and unzip the contents of the IDM_JDBC_4.2.2_P1.zip file to a temporary location on your computer.


5. (Conditional) To update the driver files as a root user:


1. On the server where you want to apply the driver patch, log in as root.


2. Perform the following steps based on your platform:


• Linux:
• Navigate to the <extracted IDM_JDBC_4.2.2_P1.zip>/Linux directory.
• Install the novell-DXMLjdbc.rpm by running the following command in a terminal window:

rpm -Uvh (patch-path)/linux/novell-DXMLjdbc.rpm

NOTE: If the driver is installed with Remote Loader, run the above command on the machine where Remote Loader is installed.

• Windows:
• If the driver is installed locally:
• Navigate to the <extracted IDM_JDBC_4.2.2_P1.zip>/Windows folder.
• Copy and replace the idm_db2.jar , JDBCConfig.jar, JDBCShim.jar, and JDBCUtil.jar files in the C:\NetIQ\IDM\NDS\lib folder.
• If the driver is installed with Remote Loader:
• Navigate to the <extracted IDM_JDBC_4.2.2_P1.zip>/Windows folder.
• Copy and replace the idm_db2.jar , JDBCConfig.jar, JDBCShim.jar, and JDBCUtil.jar files in the C:\NetIQ\IDM\RemoteLoader\64bit\lib folder.




6. (Conditional) To update the driver files as a non-root user:


1. Verify that <non-root edirectory="" location="">/rpm directory exists and contains _db.* file.

The _db.* file is created during a non-root installation of the Identity Manager engine. Absence of this file might indicate that Identity Manager is not properly installed. Reinstall Identity Manager to correctly place the file in the directory.

2. To set the root directory to the location of non-root Identity Vault, enter the following command in the command prompt:

ROOTDIR=<non-root eDirectory location>

This will set the environmental variables to the directory where Identity Vault is installed as a non-root user.

3. To install the driver files, enter the following command:

For example, to install the JDBC driver RPM, use this command:

rpm --dbpath $ROOTDIR/rpm -Uvh --relocate=/usr=$ROOTDIR/opt/novell/eDirectory --relocate=/etc=$ROOTDIR/etc --relocate=/opt/novell/eDirectory=$ROOTDIR/opt/novell/eDirectory --relocate=/opt/novell/dirxml=$ROOTDIR/opt/novell/dirxml --relocate=/var=$ROOTDIR/var --badreloc --nodeps --replacefiles /home/user/novell-DXMLjdbc.rpm

where /opt/novell/eDirectory is the location where non-root eDirectory is installed and /home/user/ is the home directory of the non-root user.

7. (Conditional) If the driver is running locally, start the Identity Vault and the driver instance.


8. (Conditional) If the driver is running with a Remote Loader instance, start the Remote Loader instance and the driver instance.

Technical Support Information

Issues Fixed in this Release

• Defect 230966 - 1165278 dhost.exe is leaking memory when latest 4.2.1.1 JDBC driver is running.
• Defect 436118 : JDBC Base packages contain logic
• Defect 436117 : SQL Server Base - 2.4.5.20190802130411 contains logic

Issues Fixed in Previous Version 4.2.2.0000

• Defect 229693 - 1090463 Password Synchronization package adds policy NOVLPWDSYNC-pub-ctp-DefaultPwd policy twice to the pub command transform
• Defect 229731 - 1095386 java.lang.UnsupportedOperationException: Store does not support rollback
• Defect 230189 - 1090462 Upgrading the SQL Server Direct Synchronization Package, doesn't update Post Polling statements correctly
• Defect 231612 - 1172125 JDBC Driver 4.2.1.1 slower performance vs 4.1.x driver
• Defect 301235 - JDBC Driver will not use UPPERCASE state Directory as defined in Driver Parameters.
• Defect 327413 - JDBC Driver: Migrate into from iManager or manually, only fires off once with given amount of objects
• Defect 378035 - JDBC (Oracle) driver packages contain incomplete display-name strings for some left outer join choices