Hi all!!

Im using hibernate and sql server with the MS driver and only had one small problem.

Every now and then Im getting locked rows in a table. The locks persist even after shutting down the app server which uses the DB!

Im using transactions templates from the springframework for all write operations.

The problem comes when I try to access the affected row from ODBC. Does anyone know how to remove locks or check how to see them for a particular row?

Thanks in advance..

SQL server logs deadlocks in its error logs, but it doesn't do it at row level. There is no way in SQL Server to explicitly end a deadlock (other than bouncing the server ). SQL Server is supposed to clean these up for you. It does this by identifying and timing the deadlocked thread out. You can decrease the deadlock time out period with sp_configure (with the option "query wait").

(BTW: this isn't really a Hibernate question - you might want to try msdn next time)