wood burning stoves*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 30076
    
149

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: 30076
    
149

Maybe you have more users now and that is introducing a deadlock?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Can't find record in 'tablename
 
Similar Threads
QuerySyntaxException: "Tablename is not mapped"
Create procedure for inserting record into table : Table name dynamically as an Param
SQLException beteen correlation and exposed name
Can't find record in 'tablename' on select in MqSql
Create procedure for inserting record into table : Table name dynamically as an Param