Will DB session terminate when client close DB connection I have several questions about database connection and database sessions. I assume questions below are apply to all databases (RDBMS). 


In most of the cases, one database session is on one database connection. If client close the DB connection, will the DB session terminate straight away?
If the DB session contain a row level lock created via select for update query, will closing the DB connection without commit or rollback release the lock?
What is the impact if database statements are not close?
If the DB connection is closed the session will get an error the next time it attempts to query the database. But will work on subsequent tries as it establishes a new connection.
I believe this answer varies by RDBMS, but to answer you question, I believe the general answer is no. You can however manually kill the session, which should release the locks.
You should commit or rollback your transactions, you should not leave them open.