SQLiteException: no such table

Question

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?

Answer 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.

Answer 2

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

Answer 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.

Answer 4

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

Answer 5

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

Answer 6

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.