i2b2 Sponsored Project/s:
Developer Notes:
Hide
The updated jdbc jar files that reside in the JBoss deployments directories have been made available for installation.
These updated drivers are optional and can be installed by running one of the following command lines:
Linux command:
ant copy_new_jdbc_jar
Windows command:
%ANT_HOME%\bin\ant.bat copy_new_jdbc_jar
REMEMBER: if you choose to install the new jdbc jar files you also need to update your datasource files with the new driver information. This needs to be done for each cell in the i2b2 hive.
Show
The updated jdbc jar files that reside in the JBoss deployments directories have been made available for installation.
These updated drivers are optional and can be installed by running one of the following command lines:
Linux command:
ant copy_new_jdbc_jar
Windows command:
%ANT_HOME%\bin\ant.bat copy_new_jdbc_jar
REMEMBER: if you choose to install the new jdbc jar files you also need to update your datasource files with the new driver information. This needs to be done for each cell in the i2b2 hive.
Testing Notes:
Hide
Verified the script removes the existing drivers and deploys the new drivers correctly.
Manually updated the ds.xml files for each cell and verified the Web Client is able to communicate with each cell. The verification was done by running queries, performing searches in Find Terms & Find Previous Queries as well as expand folders in Navigate terms, Workplace and Previous queries.
Show
Verified the script removes the existing drivers and deploys the new drivers correctly.
Manually updated the ds.xml files for each cell and verified the Web Client is able to communicate with each cell. The verification was done by running queries, performing searches in Find Terms & Find Previous Queries as well as expand folders in Navigate terms, Workplace and Previous queries.
An updated version of the JDBC drivers for Oracle, PostgreSQL and SQL Server will be provided. The new version of JDBC drivers are optional and will not be installed automatically.
IMPORTANT: Sites that choose to upgrade their JDBC drivers will be required to also updated the datasource files for all of their cells.
{"report":{"fcp":1316.1000000089407,"ttfb":824.4000000059605,"pageVisibility":"visible","entityId":10961,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"55cd8d3c-6c4c-4c9b-9865-a5963c1b8aa0","navigationType":0,"readyForUser":1390.5,"redirectCount":0,"resourceLoadedEnd":1183.1000000089407,"resourceLoadedStart":830,"resourceTiming":[{"duration":8.400000005960464,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":830,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":830,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":838.4000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":8.599999994039536,"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":830.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":830.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":838.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":71.90000000596046,"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":830.4000000059605,"connectEnd":830.4000000059605,"connectStart":830.4000000059605,"domainLookupEnd":830.4000000059605,"domainLookupStart":830.4000000059605,"fetchStart":830.4000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":830.4000000059605,"responseEnd":902.3000000119209,"responseStart":902.3000000119209,"secureConnectionStart":830.4000000059605},{"duration":106.20000000298023,"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":830.5,"connectEnd":830.5,"connectStart":830.5,"domainLookupEnd":830.5,"domainLookupStart":830.5,"fetchStart":830.5,"redirectEnd":0,"redirectStart":0,"requestStart":830.5,"responseEnd":936.7000000029802,"responseStart":936.7000000029802,"secureConnectionStart":830.5},{"duration":108.1000000089407,"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":830.7000000029802,"connectEnd":830.7000000029802,"connectStart":830.7000000029802,"domainLookupEnd":830.7000000029802,"domainLookupStart":830.7000000029802,"fetchStart":830.7000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":830.7000000029802,"responseEnd":938.8000000119209,"responseStart":938.8000000119209,"secureConnectionStart":830.7000000029802},{"duration":108.3999999910593,"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":830.8000000119209,"connectEnd":830.8000000119209,"connectStart":830.8000000119209,"domainLookupEnd":830.8000000119209,"domainLookupStart":830.8000000119209,"fetchStart":830.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":830.8000000119209,"responseEnd":939.2000000029802,"responseStart":939.2000000029802,"secureConnectionStart":830.8000000119209},{"duration":108.6000000089407,"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":831,"connectEnd":831,"connectStart":831,"domainLookupEnd":831,"domainLookupStart":831,"fetchStart":831,"redirectEnd":0,"redirectStart":0,"requestStart":831,"responseEnd":939.6000000089407,"responseStart":939.6000000089407,"secureConnectionStart":831},{"duration":110.29999999701977,"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":831.2000000029802,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":831.2000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":941.5,"responseStart":0,"secureConnectionStart":0},{"duration":108.90000000596046,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":831.2000000029802,"connectEnd":831.2000000029802,"connectStart":831.2000000029802,"domainLookupEnd":831.2000000029802,"domainLookupStart":831.2000000029802,"fetchStart":831.2000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":831.2000000029802,"responseEnd":940.1000000089407,"responseStart":940.1000000089407,"secureConnectionStart":831.2000000029802},{"duration":86,"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":856.2000000029802,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":856.2000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":942.2000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":84.5,"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":856.3000000119209,"connectEnd":856.3000000119209,"connectStart":856.3000000119209,"domainLookupEnd":856.3000000119209,"domainLookupStart":856.3000000119209,"fetchStart":856.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":856.3000000119209,"responseEnd":940.8000000119209,"responseStart":940.8000000119209,"secureConnectionStart":856.3000000119209},{"duration":249.5,"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":864.5,"connectEnd":864.5,"connectStart":864.5,"domainLookupEnd":864.5,"domainLookupStart":864.5,"fetchStart":864.5,"redirectEnd":0,"redirectStart":0,"requestStart":864.5,"responseEnd":1114,"responseStart":1114,"secureConnectionStart":864.5},{"duration":314.20000000298023,"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":868.9000000059605,"connectEnd":868.9000000059605,"connectStart":868.9000000059605,"domainLookupEnd":868.9000000059605,"domainLookupStart":868.9000000059605,"fetchStart":868.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":868.9000000059605,"responseEnd":1183.1000000089407,"responseStart":1183.1000000089407,"secureConnectionStart":868.9000000059605},{"duration":216.19999998807907,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1184.800000011921,"connectEnd":1184.800000011921,"connectStart":1184.800000011921,"domainLookupEnd":1184.800000011921,"domainLookupStart":1184.800000011921,"fetchStart":1184.800000011921,"redirectEnd":0,"redirectStart":0,"requestStart":1184.800000011921,"responseEnd":1401,"responseStart":1401,"secureConnectionStart":1184.800000011921},{"duration":80.09999999403954,"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":1428.6000000089407,"connectEnd":1428.6000000089407,"connectStart":1428.6000000089407,"domainLookupEnd":1428.6000000089407,"domainLookupStart":1428.6000000089407,"fetchStart":1428.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":1428.6000000089407,"responseEnd":1508.7000000029802,"responseStart":1508.7000000029802,"secureConnectionStart":1428.6000000089407}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":176,"connectEnd":794,"secureConnectionStart":779,"requestStart":795,"responseStart":824,"responseEnd":869,"domLoading":828,"domInteractive":1460,"domContentLoadedEventStart":1460,"domContentLoadedEventEnd":1510,"domComplete":1781,"loadEventStart":1782,"loadEventEnd":1782,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1431.1000000089407},{"name":"bigPipe.sidebar-id.end","time":1432.2000000029802},{"name":"bigPipe.activity-panel-pipe-id.start","time":1432.300000011921},{"name":"bigPipe.activity-panel-pipe-id.end","time":1433.300000011921},{"name":"activityTabFullyLoaded","time":1528.1000000089407}],"measures":[],"correlationId":"6f5454b2f3f874","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":56,"dbReadsTimeInMs":7,"dbConnsTimeInMs":9,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}