Issue #2754: Restore autocommit flag in withTransaction() and review getDataSourceURL() code

Restore autocommit flag in DBApi.withTransaction() method call
DBApi.getDataSourceURL() now using withConnection() for automatic resource management