Hi
We are using Hibernate in our project to talk to oracle 8 server.
IN our application we are facing the problem of DB locks.

By looking the db statistic if looks like a session is trying to have the row exclusive lock on the table with SELECT sql statement and at the same time other session is trying to obtain the row exclusive lock on the same row with DELETE sql statement.

Due to the above condition we are facing the db dead lock condition. if we kill SELECT statement session then all the DB deadlock get cleared.

Can anybody suggest why hibernate issue lock for select statement? Is hibernate issuing SELECT ... FOR UPDATE statement in case of selec?. If yes then how we control hibernate to stop issuing locks?

Any suggestions

Shaleen

Post your code. If not, any answer is likely to be a guess !