GeeCON Prague 2014*
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


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: 2501
    
    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
 
GeeCON Prague 2014
 
subject: SQL Error : Incorrect key file for table