This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQL Error : Incorrect key file for table 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 "SQL Error : Incorrect key file for table" Watch "SQL Error : Incorrect key file for table" New topic
Author

SQL Error : Incorrect key file for table

Abhishek Shirodkar
Greenhorn

Joined: May 08, 2009
Posts: 26
Hi
I am getting the following Sql Exception

java.sql.SQLException: Incorrect key file for table 'C:\WINDOWS\TEMP\#sql_46c_0.MYI'; try to repair it

Any Idea why its coming..

Thanks in advance.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

Can you give us some info?

- what is the database you run?
- has anything changed since it worked?
- has it ever worked?
- when is the error occurring?
- have you tried to repair it, as the error message says?


OCUP UML fundamental and ITIL foundation
youtube channel
 
Don't get me started about those stupid light bulbs.
 
subject: SQL Error : Incorrect key file for table
 
Similar Threads
if table has reference ,then could i put refered table with refering table seperately
SQLException incorrect key file for table
Syntax error in SQL
creating backup tables
Federal Air Transportation Airport Security Service