Configure command does not configure the JDBC connection
Merative ™ Social Program Management “configure” command line target does not configure the JDBC connection between Oracle and WebSphere correctly in WAS 22.214.171.124 and WAS 126.96.36.199 and later WebSphere fix packs
Merative Social Program Management “configure” command line target does not configure the JDBC connection between Oracle and WebSphere correctly in WAS 188.8.131.52 and WAS 184.108.40.206 and later WebSphere fix packs
In Merative WebSphere Application Server (WAS) 220.127.116.11 and Merative WebSphere Application Server 18.104.22.168 (an upcoming release) and later fix pack releases, a change has been made to the templates which may be used to configure JDBC connections. This change now specifies a later version of the Oracle driver (ojdbc8.jar) in the template context used for configuring Oracle JDBC connections.
Merative Social Program Management (SPM) provides a “configure” target which can be used to configure the application server before the application is deployed. This target uses these templates when configuring the JDBC connection to be used between the application server and the database.
This target, when used against these versions of WAS, now configures the JDBC connection incorrectly as the version of the Oracle driver shipped with SPM is ojdbc6.jar (and not ojdbc8.jar). Although the “configure” target will run to completion, the targets to deploy the application will subsequently fail, as the JDBC connection configuration has not been set up correctly.
If this target is still required to be run against these versions of WAS, it is recommended to address the issue by manually editing the JDBC connection configuration using the administration console of WebSphere. This is described on the documentation for Configure an Oracle Data Source page. i.e. review the Classpath and ensure the ORACLE_JDBC_DRIVER_PATH environment variable is correct. For version ojdbc6.jar of the Oracle driver, this must be the following syntax:
It should be noted that the issue only pertains to the following middleware combinations and versions:
|WAS 22.214.171.124 (and later fix packs)||Oracle 12.1|
|WAS 126.96.36.199 (and later fix packs)||Oracle 12.2|
|WAS 188.8.131.52 (and later fix packs)||Oracle 12.1|
|WAS 184.108.40.206 (and later fix packs)||Oracle 12.2|
Note: At the time of publishing this tech note, WAS 220.127.116.11 is the next 8.5.5.x fixpack release. This release will contain the JDBC template change which causes this issue.
|Merative Social Program Management||Platform Independent||All Versions|
|Merative Social Program Management||AIX; HP-UX; Linux; Solaris; Windows; z/OS||7.0.2, 7.0.1, 7.0.0|
More support for:
Merative Social Program Management
7.0.2, 7.0.1, 7.0.0
AIX, HP-UX, Linux, Solaris, Windows, z/OS
25 September 2022