Hi all,
We are using Sturts,Ejb and Hibernate with Oracle 10g database with clustered environment for our application.When we do more number of transaction in a particular day, then always only one table is geeting locked and we are getting the following exception.At this time we are executing normal delete query.

[3/24/09 10:23:07:084 GST] 00000080 SystemErr R org.hibernate.exception.LockAcquisitionException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:87)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:334)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:209)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1126)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at com.ifacts.dao.frontoffice.TransactionBuySellDAO.deleteTransaction(TransactionBuySellDAO.java:1056)
at com.ifacts.bo.bean.frontoffice.PaymentDtlBean.confirm(PaymentDtlBean.java:369)
at com.ifacts.bo.remote.frontoffice.EJSRemoteStatelessTxnPayment_e8e274ab.confirm(Unknown Source)


Can any one help me how to resolve this exception.
On which scenarios this dead lock will occur.

Thanks
siva.

i just went through this forum where i found there is thread

http://forum.hibernate.org/viewtopic.ph ... 1b972ecdad

which is related to this...

Is there any confguration need to be done from DBSide to resolve this problem?