[RHPAM operator] jdbcURL cannot specify enabledTLSProtocols or pinGlobalTxToPhysicalConnection properties with MySQL DB

When installing RHPAM with the KieApp custom resourcemin the OpenShift environment, the jdbcURL of the server cannot include, in case of MySQL DB, any of these connection parameters:

• enabledTLSProtocols
• pinGlobalTxToPhysicalConnection

In fact, these two are automatically included by the startup scripts (namely, bin/launch/jboss-kie-kieserver.sh) and the JDBC driver would raise a misleading error to complain about the duplication.

E.g., if we use:

jdbc:mysql://DBHOST:3306/DBNAME?useSSL=true&enabledTLSProtocols=TLSv1.2

The following URL would be generated in standalone-openshift.xml:

jdbc:mysql://DBHOST:3306/DBNAME?useSSL=true&enabledTLSProtocols=TLSv1.2&pinGlobalTxToPhysicalConnection=true&enabledTLSProtocols=TLSv1.2

And this error would be raised by the driver:

Malformed database URL, failed to parse the connection string near '=TLSv1.2'.

The documentation should clearly state that these settings are not accepted instead (and maybe also specify the reason for having them automatically added).

We are raising this issue to the documentation but clearly expectation should be to prevent this from happening (either in the operator level or in the startup script)

Tested with RHPAM 7.9.1 and also 7.13 with the same result.
At the first glance, the same issue also affects Maria DB connections