1797 - Fix the Blocker level issues found by SonarQube

[cogross]

This fixes most of the Blocker level issues found by SonarQube. A few will require more substantial refactoring or redesigning of the code, so those will remain as they are.

Most of the changes involve wrapping calls to connectors/files with a try-resource block and fixing some synchronization blocks.

[cogross]

Pushed up a new version, up to date w/ latest in integration and fixes for the things mentioned here.

[cogross]

Fixed the last few things -- a few comments were hidden.

[hlgp]

This appears to have broken internal tests