What will happen when ResultSet is not closed?In a pooled database connection, it is returned to the pool and could close only after expiring its life time. In the mean time many result sets might opened and left unclosed. If it happens on a single database by multiple applications, the data updation is not perfect and may violate ACID properties rule for data presuming.
|