After completion of a new installation using the 1.7.00 Ant scripts and documentation, the jar file for the appropriate database driver is not placed in $JBOSS_HOME/standalone/deployments/i2b2.war/WEB-INF/lib. This results in failure to execute queries in the webclient subsequent to login. JBoss logs NoClassDefFoundError entries in $JBOSS_HOME/standalone/log/server.log as well.
The i2b2 1.7 virtual machine has both sqljdbc4.jar and ojdbc.jar in $JBOSS_HOME/standalone/deployments/i2b2.war/WEB-INF/lib as well as $JBOSS_HOME/standalone/deployments. A current workaround for the installation process is to copy these files down into the i2b2.war/WEB-INF/lib directory.
I suggest the solution is either modification of the Ant scripts, or directions in the documentation to manually copy the appropriate driver. If there is a design reason for having both drivers, rather than just the one needed for the corresponding back-end database, it would be nice if that was documented.
See "i2b2 Install Help" Google Group topic "Once more?" dated 1/31/2014.
https://groups.google.com/forum/#!msg/i2b2-install-help/Mv8gK9x03_Y/7m8DBdFGb5sJ
Janice Donahoe
made changes -
22/May/14 5:58 PM
Field
Original Value
New Value
Workflow
classic default workflow
[ 10228
]
i2b2 Issues
[ 10305
]
Janice Donahoe
made changes -
23/May/14 12:10 PM
Component/s
Install
[ 10020
]
Janice Donahoe
made changes -
28/May/14 3:43 PM
Fix Version/s
1.7.01
[ 10090
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Resolved
[ 5
]
Janice Donahoe
made changes -
28/May/14 3:43 PM
Status
Resolved
[ 5
]
Closed
[ 6
]
Janice Donahoe
made changes -
29/May/14 4:07 PM
Workflow
i2b2 Issues
[ 10305
]
i2b2 Issues Workflow
[ 10596
]
Janice Donahoe
made changes -
05/Jun/14 6:21 PM
Component/s
Install
[ 10053
]
Component/s
Install
[ 10020
]
Fix Version/s
1.7.01
[ 10154
]
Fix Version/s
1.7.01
[ 10090
]
Key
LEOPARD-137
CORE-87
Project
i2b2
[ 10000
]
i2b2 Core Project
[ 10034
]
Affects Version/s
1.7.00
[ 10153
]
Affects Version/s
1.7.00
[ 10081
]
{"report":{"fcp":744.1999998092651,"ttfb":156.29999923706055,"pageVisibility":"visible","entityId":10228,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"82f48d4f-b71b-414e-adc5-0c9614dd1ade","navigationType":0,"readyForUser":790.6999998092651,"redirectCount":0,"resourceLoadedEnd":822.3999996185303,"resourceLoadedStart":161.0999994277954,"resourceTiming":[{"duration":8.100000381469727,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":161.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":169.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":9.600000381469727,"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":161.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":171,"responseStart":0,"secureConnectionStart":0},{"duration":189.60000038146973,"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":161.5999994277954,"connectEnd":195.89999961853027,"connectStart":172.39999961853027,"domainLookupEnd":172.39999961853027,"domainLookupStart":172.39999961853027,"fetchStart":161.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":195.89999961853027,"responseEnd":351.19999980926514,"responseStart":215,"secureConnectionStart":184},{"duration":239.70000076293945,"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":161.79999923706055,"connectEnd":197.0999994277954,"connectStart":173.29999923706055,"domainLookupEnd":173.29999923706055,"domainLookupStart":173.29999923706055,"fetchStart":161.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":197.19999980926514,"responseEnd":401.5,"responseStart":221.0999994277954,"secureConnectionStart":185.29999923706055},{"duration":227.19999980926514,"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":162,"connectEnd":374,"connectStart":351.19999980926514,"domainLookupEnd":351.19999980926514,"domainLookupStart":351.19999980926514,"fetchStart":162,"redirectEnd":0,"redirectStart":0,"requestStart":374,"responseEnd":389.19999980926514,"responseStart":387.5999994277954,"secureConnectionStart":362.29999923706055},{"duration":264.5999994277954,"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":162.19999980926514,"connectEnd":412,"connectStart":389.0999994277954,"domainLookupEnd":389.0999994277954,"domainLookupStart":389.0999994277954,"fetchStart":162.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":412.0999994277954,"responseEnd":426.79999923706055,"responseStart":425.3999996185303,"secureConnectionStart":400.19999980926514},{"duration":265.4000005722046,"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":162.29999923706055,"connectEnd":413.0999994277954,"connectStart":389.69999980926514,"domainLookupEnd":389.69999980926514,"domainLookupStart":389.5999994277954,"fetchStart":162.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":413.0999994277954,"responseEnd":427.69999980926514,"responseStart":426.0999994277954,"secureConnectionStart":401},{"duration":12.899999618530273,"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":162.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":175.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":266.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":162.5999994277954,"connectEnd":415.0999994277954,"connectStart":392,"domainLookupEnd":392,"domainLookupStart":392,"fetchStart":162.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":415.19999980926514,"responseEnd":429.3999996185303,"responseStart":428.29999923706055,"secureConnectionStart":403.29999923706055},{"duration":23.199999809265137,"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":285.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":285.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":308.29999923706055,"responseStart":0,"secureConnectionStart":0},{"duration":356,"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":285.19999980926514,"connectEnd":625.3999996185303,"connectStart":602.1999998092651,"domainLookupEnd":602.1999998092651,"domainLookupStart":602.1999998092651,"fetchStart":285.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":625.3999996185303,"responseEnd":641.1999998092651,"responseStart":639.7999992370605,"secureConnectionStart":613.5},{"duration":365.1000003814697,"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":313.79999923706055,"connectEnd":664.2999992370605,"connectStart":641,"domainLookupEnd":641,"domainLookupStart":641,"fetchStart":313.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":664.7999992370605,"responseEnd":678.8999996185303,"responseStart":678,"secureConnectionStart":652.3999996185303},{"duration":128.9000005722046,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":541.2999992370605,"connectEnd":653.3999996185303,"connectStart":629.5999994277954,"domainLookupEnd":629.5999994277954,"domainLookupStart":629.5999994277954,"fetchStart":541.2999992370605,"redirectEnd":0,"redirectStart":0,"requestStart":653.7999992370605,"responseEnd":670.1999998092651,"responseStart":669.2999992370605,"secureConnectionStart":641.5},{"duration":151.89999961853027,"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":555.5,"connectEnd":693.7999992370605,"connectStart":670.0999994277954,"domainLookupEnd":670.0999994277954,"domainLookupStart":670.0999994277954,"fetchStart":555.5,"redirectEnd":0,"redirectStart":0,"requestStart":693.8999996185303,"responseEnd":707.3999996185303,"responseStart":706.5,"secureConnectionStart":681.8999996185303},{"duration":120.5,"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":701.8999996185303,"connectEnd":806.5,"connectStart":780.8999996185303,"domainLookupEnd":780.8999996185303,"domainLookupStart":780.8999996185303,"fetchStart":701.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":806.5999994277954,"responseEnd":822.3999996185303,"responseStart":821.5999994277954,"secureConnectionStart":793.5}],"fetchStart":0,"domainLookupStart":13,"domainLookupEnd":72,"connectStart":72,"connectEnd":110,"secureConnectionStart":84,"requestStart":110,"responseStart":156,"responseEnd":389,"domLoading":159,"domInteractive":839,"domContentLoadedEventStart":839,"domContentLoadedEventEnd":878,"domComplete":1363,"loadEventStart":1363,"loadEventEnd":1363,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":815.6999998092651},{"name":"bigPipe.sidebar-id.end","time":816.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":816.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":819.0999994277954},{"name":"activityTabFullyLoaded","time":896.0999994277954}],"measures":[],"correlationId":"cb92b6e506d248","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":258,"dbReadsTimeInMs":60,"dbConnsTimeInMs":76,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}