Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error in database

 
Nimish Patel
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

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.
Nimish
 
Dave Salter
Ranch Hand
Posts: 293
Java Mac OS X Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you show us the SQL that is being executed in the transaction?

Are there multiple transactions being performed at this time?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic