When we deploy a RHPAM environment (for example, production or trial) with an external database that needs special parameters, the only way to inject these parameters is via the JDBC URL. The problem is that when using a MYSQL or MARIADB external database, some other parameters are injected automatically and the final JDBC URL is wrong, for example:

• If we set the JDBC URL to jdbc:mysql:mysql-57.hosts.prod.upshift.rdu2.redhat.com:3306/dballo02*?useSSL=false*

In templates, this is done by setting the parameter RHPAM_URL.
In Operators, this is done by setting the field .Database.ExternalConfig.JdbcURL

• Then, the kieserver tries to startup using the next JDBC URL:

jdbc:mysql:mysql-57.hosts.prod.upshift.rdu2.redhat.com:3306/dballo02*?useSSL=false?pinGlobalTxToPhysicalConnection=true&enabledTLSProtocols=TLSv1.2*

Which is not working due to the double character "?". The expected result would be: jdbc:mysql:mysql-57.hosts.prod.upshift.rdu2.redhat.com:3306/dballo02?useSSL=false&pinGlobalTxToPhysicalConnection=true&enabledTLSProtocols=TLSv1.2

We think the cause might be around this line.

As far I know, there is no workaround to append parameters to the external database connection.