Apologies if it sounds too trivial but I am facing some in querying database.
I am doing some data insertions in DB in 4-5 steps and
then based on further computation I am trying to update the status of data inserted in above steps and at that time it is taking too much time/being idle(thread in stepping state).

Same status update call if I do again by stopping application based on values inserted it is running successfully.

Does it has something to do with session/transaction that i am not flushing/clearing so some space/cache/memory is full and it is not making further db calls?: just a wild guess.
Any thoughts?

same issue came even when i am running "single simple select query" in a loop.
hibernate flush mode i have set to eager


On explicitly flushing and closing session it is running couple of extra loops.
Everytime I am creating a new session.