
November 21st, 2006, 09:06 AM
|
|
Registered User
|
|
Join Date: Nov 2006
Posts: 2
Time spent in forums: 12 m 21 sec
Reputation Power: 0
|
|
|
Deadlock found when trying to get lock, try restarting transaction.
Hello,
Im getting the following SQLException during an insert or a delete or an update statement. "Deadlock found when trying to get lock; try restarting transaction message from server: lock wait timeout exceeded; try restarting transaction". I have a jsp page which does an insert, i have another jsp page which has a delete query that deletes a particular row, and then tries to insert (using an id,which is a primary key), then there is an update statement. In both these pages, i sometimes get the above mentioned exception. When the Tomcat server is restarted, i do not get the exception.
Kindly help..
|