*
The moose likes JDBC and the fly likes  Can't find record in 'tablename Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark " Can Watch " Can New topic
Author

Can't find record in 'tablename

sandhya sri
Greenhorn

Joined: Feb 11, 2009
Posts: 16
i am getting Can't find record in 'tablename' error. I am using MySql.
What is cause for this error?
As I know if we insert and delete from a table while selecting from the same table, We can get this error.
but what is my doubt is we also get 'lock wait time out exception'.

Can any one clarify this.

In advance thanks.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30293
    
150

What code is running when you get the error?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
sandhya sri
Greenhorn

Joined: Feb 11, 2009
Posts: 16
Actually In my application while running the code related to insert and delete on xxx table, another member clicks on some service which also related to this xxx table for selection from this xxx table.
that is my scenario.

but what my doubt is, for the same scenario i can get lock wait timeout exception.But y I got this Exception?
My application is running since one and half year in live but this is the first time I got this exception.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30293
    
150

Maybe you have more users now and that is introducing a deadlock?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can't find record in 'tablename