i2b2 Sponsored Project/s:
Currently i2b2 1.7 uses the following validations for its default installations which are not ideal.
<validation>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
</validation>
If we encounter a situation in which a connection in the pool goes bad we will continue to use that connection which will cause errors in i2b2. The better solution would be to use validation.
<validation>
<validate-on-match>true</validate-on-match>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
<use-fast-fail>true</use-fast-fail>
</validation>
Obviously the sql will change per database engine but it should be easy to configure based on each of the datasources defined ie "SELECT 1" for MSSQL
{"report":{"fcp":840.3999999999942,"ttfb":114,"pageVisibility":"visible","entityId":10318,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"b84b50b6-5a95-40fd-8a2f-c937732346b7","navigationType":0,"readyForUser":909.1999999999825,"redirectCount":0,"resourceLoadedEnd":817.6999999999825,"resourceLoadedStart":125.69999999998254,"resourceTiming":[{"duration":7.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":125.69999999998254,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":125.69999999998254,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":133.19999999998254,"responseStart":0,"secureConnectionStart":0},{"duration":8.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":126,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":126,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":134.5,"responseStart":0,"secureConnectionStart":0},{"duration":216.20000000001164,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":126.19999999998254,"connectEnd":161.79999999998836,"connectStart":134.79999999998836,"domainLookupEnd":126.19999999998254,"domainLookupStart":126.19999999998254,"fetchStart":126.19999999998254,"redirectEnd":0,"redirectStart":0,"requestStart":161.89999999999418,"responseEnd":342.3999999999942,"responseStart":185.60000000000582,"secureConnectionStart":148.79999999998836},{"duration":268.79999999998836,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":126.60000000000582,"connectEnd":313.5,"connectStart":287,"domainLookupEnd":126.60000000000582,"domainLookupStart":126.60000000000582,"fetchStart":126.60000000000582,"redirectEnd":0,"redirectStart":0,"requestStart":313.5,"responseEnd":395.3999999999942,"responseStart":332.6000000000058,"secureConnectionStart":300.79999999998836},{"duration":260.6000000000058,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":126.69999999998254,"connectEnd":371.6000000000058,"connectStart":342.19999999998254,"domainLookupEnd":126.69999999998254,"domainLookupStart":126.69999999998254,"fetchStart":126.69999999998254,"redirectEnd":0,"redirectStart":0,"requestStart":371.6000000000058,"responseEnd":387.29999999998836,"responseStart":386.29999999998836,"secureConnectionStart":358.29999999998836},{"duration":264.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":126.79999999998836,"connectEnd":375.29999999998836,"connectStart":348,"domainLookupEnd":126.79999999998836,"domainLookupStart":126.79999999998836,"fetchStart":126.79999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":375.3999999999942,"responseEnd":391.29999999998836,"responseStart":390.5,"secureConnectionStart":362},{"duration":281.6000000000058,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":127,"connectEnd":387.1000000000058,"connectStart":357.8999999999942,"domainLookupEnd":127,"domainLookupStart":127,"fetchStart":127,"redirectEnd":0,"redirectStart":0,"requestStart":387.6000000000058,"responseEnd":408.6000000000058,"responseStart":407.3999999999942,"secureConnectionStart":372},{"duration":15.700000000011642,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":127.19999999998254,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":127.19999999998254,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":142.89999999999418,"responseStart":0,"secureConnectionStart":0},{"duration":284.70000000001164,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":127.29999999998836,"connectEnd":396.1000000000058,"connectStart":368.8999999999942,"domainLookupEnd":127.29999999998836,"domainLookupStart":127.29999999998836,"fetchStart":127.29999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":396.69999999998254,"responseEnd":412,"responseStart":411.1000000000058,"secureConnectionStart":383.1000000000058},{"duration":21.39999999999418,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":215.79999999998836,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215.79999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":237.19999999998254,"responseStart":0,"secureConnectionStart":0},{"duration":553.1999999999825,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":216,"connectEnd":744.2999999999884,"connectStart":712.2999999999884,"domainLookupEnd":216,"domainLookupStart":216,"fetchStart":216,"redirectEnd":0,"redirectStart":0,"requestStart":746.6000000000058,"responseEnd":769.1999999999825,"responseStart":765.8999999999942,"secureConnectionStart":727.2999999999884},{"duration":561.7000000000116,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":255.79999999998836,"connectEnd":795.7999999999884,"connectStart":769.1000000000058,"domainLookupEnd":255.79999999998836,"domainLookupStart":255.79999999998836,"fetchStart":255.79999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":796.1000000000058,"responseEnd":817.5,"responseStart":815.1000000000058,"secureConnectionStart":783},{"duration":530.3999999999942,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":287.29999999998836,"connectEnd":799.1999999999825,"connectStart":771,"domainLookupEnd":287.29999999998836,"domainLookupStart":287.29999999998836,"fetchStart":287.29999999998836,"redirectEnd":0,"redirectStart":0,"requestStart":799.6999999999825,"responseEnd":817.6999999999825,"responseStart":815.8999999999942,"secureConnectionStart":786.1999999999825},{"duration":291.29999999998836,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":524.5,"connectEnd":795.6999999999825,"connectStart":763.6000000000058,"domainLookupEnd":524.5,"domainLookupStart":524.5,"fetchStart":524.5,"redirectEnd":0,"redirectStart":0,"requestStart":795.8999999999942,"responseEnd":815.7999999999884,"responseStart":814.3999999999942,"secureConnectionStart":782.3999999999942},{"duration":177.60000000000582,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-atl.general/batch.js","startTime":841.7999999999884,"connectEnd":1002.7999999999884,"connectStart":975.2999999999884,"domainLookupEnd":841.7999999999884,"domainLookupStart":841.7999999999884,"fetchStart":841.7999999999884,"redirectEnd":0,"redirectStart":0,"requestStart":1002.8999999999942,"responseEnd":1019.3999999999942,"responseStart":1018.5,"secureConnectionStart":989.6999999999825}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":41,"connectEnd":86,"secureConnectionStart":55,"requestStart":86,"responseStart":114,"responseEnd":287,"domLoading":117,"domInteractive":975,"domContentLoadedEventStart":975,"domContentLoadedEventEnd":1009,"domComplete":1177,"loadEventStart":1177,"loadEventEnd":1177,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":947.1000000000058},{"name":"bigPipe.sidebar-id.end","time":947.8999999999942},{"name":"bigPipe.activity-panel-pipe-id.start","time":948},{"name":"bigPipe.activity-panel-pipe-id.end","time":949},{"name":"activityTabFullyLoaded","time":1023.2999999999884}],"measures":[],"correlationId":"8cb06e0a4c7bfe","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":187,"dbReadsTimeInMs":40,"dbConnsTimeInMs":46,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}