Question
Anthem
US
Last activity: 19 Apr 2021 12:35 EDT
Tomcat JDBC setting "Validation Query" not compatible with PRPC8.X ?
Hi @CelesteDufresne_GCS @KevinZheng_GCS @JimKelly_GCS @TomS_GCS @Harish_GCS
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.
Thank you.
Anthem
US
@MarissaRogers Please help obtain response from one of the following GCS members : @CelesteDufresne_GCS @KevinZheng_GCS @JimKelly_GCS @TomS_GCS @Harish_GCS
Pegasystems Inc.
US
@PradeepPydiHi Pradeep, What version of tomcat and driver?
Settings have changed. Also updated drivers use an embeded api so the query itself is not needed
Updated: 19 Apr 2021 12:35 EDT
Anthem
US
Hi Jim,
PRPC version : 8.4.2
Tomcat version : 8.5.13 and sqljdbc42.jar
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.
Thank you.