AdoptOpenJDK and JDBC driver versions shipped in TDM Portal 4.9.1

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I am looking for answers to the below questions between our installed version of 4.9.98.0 and the latest version available for CA TDM Portal 4.9.1

1. What version of JDBC is supplied with 4.9.98.0 and the latest 4.9.1?
2. What version of AdoptOpenJDK is supplier with 4.9.98.0 and 4.9.1?
3. Is SQL Server 2019 certified with either 4.9.98.0 or 4.9.1? If not, when is it going to be certified? 
4. How can I use a later version of Microsoft JDBC drivers with our installed 4.9.98.0?
5. Can I also upgrade to the latest or higher version of AdoptOpenJDK and Java?

 

Environment

Release : 4.9. - 4.9.1

Component : TDM Portal and FDM

Resolution

 

1. What version of JDBC is supplied with 4.9.98.0 and the latest 4.9.1?
   TDM 4.9.1 Portal ships with mssl-jdbc.7.2.2.jre8, which is located in the %ProgramFiles%\CA\CA Test Data Manager Portal\tomcat\lib directory.
   
   
2. What version of AdoptOpenJDK is supplied with 4.9.98.0 and 4.9.1?
   The TDM 4.9.1 GA release shipped with AdoptOpenJDK 1.8.0_212-b04. However, starting with the release of TDM Portal build 4.9.318.0, which is a TDM 4.9.1 release of Portal, Engineering upgraded to AdoptOpenJDK 1.0.8_292-b10. To find out what version of Java your TDM Portal server is running, open a command prompt or Power Shell, and enter the following command:  java -version.
   
   
3. Is SQL Server 2019 certified with either 4.9.98.0 or 4.9.1? If not, when is it going to be certified?
   Yes, SQL Server 2019 has been certified with TDM 4.9.1. For a list of supported Data Sources, see https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources.html
   
   
4. How can I use a later version of Microsoft JDBC drivers with our installed 4.9.98.0?
   If you have a newer MSSQL JBC driver you would like to use, I would place the updated driver in the %ProgramFiles%\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers directory and restart the CA Test Data Manager Portal service to cycle the tomcat web server.
   
   
5. Can I also upgrade to the latest or higher version of AdoptOpenJDK and Java?
   No, you cannot simply upgrade the AdoptOpenJDK release for TDM Portal. You must upgrade to the latest TDM Portal release, which installs the embedded Adopt OpenJDK 1.8.0_292 JRE. If you require a newer release of the AdoptOpenJDK JRE we will need to submit an Enhancement Request with Product Management informing them of the minimum release required.
   
   Note: FDM requires the AdoptOpenJDK 1.8 to be installed as a prerequisite, which is not embedded as a part of the FDM installation. Therefore, you can uninstall the older AdoptOpenJDK 1.8.0_212 release, that shipped with the FDM Installation media, and install the latest release of AdoptOpenJDK 1.8.0 release. Starting with FastDataMasker-4.9.169.0, we started shipping the AdoptOpenJDK 1.8.0_292 with the FDM installation media.https://techdocs.broadcom.com/content/dam/broadcom/techdocs/us/en/assets/docops/tdm/catestdatamanageracknowledgments_49.txt

Additional Information

The TDM 4.9.1 Release Notes can be found at https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/release-notes.html

Thrid-Party Acknowledgments can be found at https://techdocs.broadcom.com/content/dam/broadcom/techdocs/us/en/assets/docops/tdm/catestdatamanageracknowledgments_49.txt