In hybris why database session gets inactive and holds lock

[Former Member]

In hybris application I can see database sessions are getting inactive . From our code we are just calling modelservice.save(cart). But From there how db session can be inactive and holds lock for cat id. If exception comes hybris should close connection and release the connection to connection pool.Why session will be inactive for long time and does not closed until we kill the sesssion from db end. Please reply.

[Former Member]

Inactive sessions in DB are nothing wrong or right - they just sit there because client application (Hybris) opened connections and holding them without explicit close action. It happens because Hybris maintains a pool of connections to be used by application logic for communicating with DB. So observing inactive sessions in DB is OK. An inactive session cannot hold the lock, so you should provide more information on the subject, how do you see that there is a lock and why you consider the session holding the lock "inactive".