JR63896: CREATING A DEPLOYMENT ENVIRONMENT WITH THE MSSQL-JDBC-8.2.0.JRE8.JAR JDBC ENCOUNTERS AN ERROR

8.6.10019003-WS-BPM-IFJR63896

APAR status

• Closed as documentation error.

Error description

• If you are using MSSQL 2019 Enterprise Edition, it requires the
  usage of mssql-jdbc-8.2.0.jre8.jar JDBC driver or higher as
  detailed in the Microsoft documentation:
  https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc
  -driver-for-sql-server-support-matrix?view=sql-server-ver15
  
  IBM Business Automation Workflow says it supports MSSQL 2019,
  but the related drivers are not listed in Configuring JDBC
  drivers (
  https://www.ibm.com/docs/en/baw/19.x?topic=installation-configur
  ing-jdbc-drivers).
  
  In addition, if you attempt to create a deployment environment
  with the laster version of JDBC driver you get the following
  error:
  CWMCB0608E: The specified JDBC driver folder does not contain
  any of the following jars:
  [mssql-jdbc-7.0.0.jre8.jar, mssql-jdbc-6.4.0.jre8.jar,
  mssql-jdbc-6.2.2.jre8.jar,
  sqljdbc42.jar, sqljdbc41.jar, sqljdbc4.jar].
  
  Workaround:
  rename mssql-jdbc-8.2.0.jre8.jar to mssql-jdbc-7.0.0.jre8.jar
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that supports the
  mssql-jdbc-8.4.1.jre8.jar and mssql-jdbc-8.2.2.jre8.jar drivers
  in BPMConfig command.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels