Are you aware of the following Tomcat JDBC setting “validation query” not being compatible with PRPC842 version or any other PRPC8.X version?
With the same setting intact, we never ran into JVM interruptions during a database node failover in PRPC731. Unfortunately, starting from PRPC8.X, we were consistently running into the plethora of application jvm's related issues during the event of every DB node failover.
Note : Nothing changed from a Tomcat and Database perspective.
***Edited by Moderator Marissa to update Platform Capability tags****
SQL server driver : Microsoft SQL Server 2012 (SP4-GDR) (KB4532098) - 11.0.7493.4 (X64) Dec 24 2019 19:33:24 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600)
SQL Server version : 11.0.7493.4
As aforementioned, nothing got changed from our Tomcat and DB perspective. Do you recommend any changes to be implemented from our Tomcat JDBC settings or PRPC 8.4.2 perspective ?? Please suggest the next best course of action items (INC-171545 created for the same issue) and help understand this disruption with the upgraded PEGA version.