[CORE-129] Improve datasource validations Created: 17/Jul/14 Updated: 30/May/19 Resolved: 10/Apr/18
|Project:||i2b2 Core Software|
|Reporter:||William Shuman||Assignee:||Janice Donahoe|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
|i2b2 Sponsored Project/s:||
Currently i2b2 1.7 uses the following validations for its default installations which are not ideal.
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.
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
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
|Comment by Mike Mendis [ 07/Feb/18 ]|
|I have commit the changes and the new datasources on currently on our qa evniroments.|
|Comment by Janice Donahoe [ 10/Apr/18 ]|
|This change was made to the databases in the testing environment 3 months ago and was tested throughout the process of testing the 1.7.10 release.|