detect db locks

[Nijeesh Balan]

Hi All,
We have a huge java application. Sometimes we experience database locking problems which we feel is because of db commit / rollback not being handled properly in the code. Is there a way, that this can be detected? some wrapper class or something of that sort which can log if db commit or rollback has not been invoked for insert/update/delete statements.. it would be helpful if u can give some example code.