method to check the connection now sets the autocommit to false and
readonly to false