SQLiteException: no such table

问题:

I am using my own SQLite3 database as opposed to creating a new one each time my app runs, as I have a few tables with static data that I am trying to display. I created my database and placed it in my assets folder. I then created my database helper and when I start my app I can open my database without problem but when I try to open my first table using the following code

private Cursor getData() 
{
    try
    {
        myDbHelper = new DatabaseHelper(this);
        SQLiteDatabase db = myDbHelper.getReadableDatabase();
        Cursor cursor = db.query("exhibitor", FROM, null, null, null,null, ORDER_BY);
        startManagingCursor(cursor);
        return cursor;
    }
    catch(SQLiteException e)
    {
        String err = e.toString();
        return null;
    }
}

It throws an error saying android.database.sqlite.SQLiteException: no such table: exhibitor: , while compiling: SELECT _id, EXHIBITOR FROM exhibitor ORDER BY EXHIBITOR but when I check the database exhibitor is there.

What am I missing?

回答1:

Have you moved the database from the assets folder to /data/data/YOUR_PACKAGE/databases/ on the emulator?

This is a good detailed post about moving the database to /data/data/YOUR_PACKAGE/databases/ if it does not exist.

Here is another short and simple solution to it.

回答2:

Settings -> Applications -> Manage Applications -> (Click on your application) -> Clear data

回答3:

Whenever you create new table in an existing database the table doesnt create because the OnCreate function of database handler will not be called everytime but only if required(like database not initiated). If that is not the case your newly created table actually hasnt created. Clear the data to force the db to instantiate itself.

回答4:

Clear Data and uninstall application from your device and re-install application in device...

Settings -> Applications -> Manage Applications -> Your Application Name -> Clear data

回答5:

Using SQLiteOpenHelper.onCreate() does not create a new database every time your app starts - rather it creates a database if it does not already exist.

It sounds like you might have an empty database created by or for your helper (if there was no database at all, I might expect a different exception), and your separate database that you created outside of Android. Looks like you and your app are not looking in the same place for your data.

回答6:

hapend to me once change your DATABASE_VERSION

if your DATABASE_VERSION =1 it will see just three table if your DATABASE_VERSION = 2 it will see just more table but i really didn't know how many

good luck

回答7:

Just clearing the data did not work for me.

What worked was:

• Uninstall app
• Restart device or emulator
• Disable Instant run (Not just the main group but all individual instant run settings)
• Build -> Clean Project
• Build -> Rebuild Project