A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
error in database
Joined: Jun 29, 2005
Jul 22, 2005 06:12:00
i use mysql database.
i get some error like...
java.sql.SQLException: Deadlock found when trying to get lock; Try restarting transaction message from server: "Lock wait timeout exceeded; try restarting transaction".
my application first is login process( related to login tabel in mysql).
it do successfully
second is adddata.it is also completed. (it is related subscriber table in mysql). add data in table using "insert query".
but third process is connected with anothe table.
when i try to insert record in this table i get error.in this insert process , i use primary key of above table.
and i get exception given above.
please help me .
thanks in advance.
Joined: Jul 20, 2005
Jul 22, 2005 07:06:00
Can you show us the SQL that is being executed in the transaction?
Are there multiple transactions being performed at this time?
I agree. Here's the link:
subject: error in database
Transaction or Table Locking?
jsp and mysql error
Trouble with Spring @Transactional and dead locks
Problem with transaction.timeout
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014