[module 1.0.x] close underlying jdbc connection to avoid leaks

Rather than waiting for the GC to eventually collect sessions and close
the underlying JDBC Connection objects, instead explicitly close the
underlying connection.