IllegalArgumentException is thrown when using JDBC_PING

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.0.0 DXP FP35, 7.0.0 DXP SP7, 7.0.5 CE GA6, 7.0.X, 7.1.0 M1, 7.1.X, Master
• Component/s: Fault Tolerance > Clustering Framework
• Labels:
  • ee-ts
  • liferay-digital-enterprise-70-sp7
  • liferay-fixpack-de-35-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/53993

Description:
Clustering no longer works with JDBC_PING after patching to DE-34.

Steps To Reproduce:

1. Download and unzip Liferay DXP SP6
2. Prepare a MySQL database
3. Configure JDBC PING Unicast Cluster using the following steps (more information available here):
   • Acquire a tcp.xml file and rename it to "jdbc_ping_config.xml"
   • Replace the "<TCPPING" tag information with the following in the jdbc_ping_config.xml file:

     <JDBC_PING
         connection_url="jdbc:mysql://ipaddress/databaseName?useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false"
         connection_username="yourusername"
         connection_password="yourpassword"
         connection_driver="com.mysql.jdbc.Driver"/>

• • Add the following properties to the portal-ext.properties file to point to the jdbc_ping_config.xml file:

    cluster.link.channel.properties.control=pathToXml/jdbc_ping_config.xml
    cluster.link.channel.properties.transport.0=pathToXml/jdbc_ping_config.xml

• • Add the following to the portal-ext.properties file:

    cluster.link.enabled=true

• • Add the following to the JVM parameters in the setenv.sh/bat file for each node:

    -Djgroups.bind_addr=<node_address>

1. Startup Liferay and confirm that the no errors occur
2. Shut down Liferay and patch to DE34
3. Clear temp and work and osgi/state
4. Restart Liferay

Expected Results:
Liferay starts up normally and the cluster works as expected (you can see the cluster section in the log)

Actual Results:
The following appears in the logs:

Caused by: java.lang.IllegalArgumentException: JDBC Driver required for JDBC_PING protocol could not be loaded: 'com.mysql.jdbc.Driver'
at org.jgroups.protocols.JDBC_PING.loadDriver(JDBC_PING.java:327)
at org.jgroups.protocols.JDBC_PING.init(JDBC_PING.java:127)
at org.jgroups.stack.ProtocolStack.initProtocolStack(ProtocolStack.java:860)
at org.jgroups.stack.ProtocolStack.setup(ProtocolStack.java:481)
at org.jgroups.JChannel.init(JChannel.java:854)
at org.jgroups.JChannel.<init>(JChannel.java:159)
at org.jgroups.JChannel.<init>(JChannel.java:139)
at com.liferay.portal.cluster.multiple.internal.jgroups.JGroupsClusterChannel.<init>(JGroupsClusterChannel.java:62)
... 145 more