Dear Members, I have web application which uses Hibernate for persistence. The Whole system is data centric that means lots of huge (involving millions) data operations happening at the back end (oracle).

I have very strange problem. I have front end where a link click results in one row insert in a table (for example TEST_TABLE).
But TEST_TABLE is locked (blocking) by one of database operation. So some times user gets exception and some times user has to wait minutes to see the saved record. But nothing happens because of locking. So he tries again and again.

Even after multiple tries he don't see any insert. Now after some hours he thought of trying again.
Now he saw is that there so many inserts already there. which are same in numbers as the number of his trials.

The problem is that now this is being taken as application is allowing duplicate inserts.

Please let me know .how to overcome the issue.

Thanks,
Pushpendra

If I understand it correct, the queries aren't executed at ones, but after a while.

Are you commiting?

Yes, the insert happened after some time.
I am using Spring Hibernate support for transaction management. The commit/rollback is done by Spring container.
Thanks,
Pushpendra