As per my understanding:

while a connection object is created, it locks the database. related to that connection object. when the developer does not close the connection, the lock to the database...