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?

Does this answer your question? Embed a database in the .apk of a distributed application [Android] — user4157124
– user4157124, Commented Aug 12, 2022 at 17:20

user1342582 · Accepted Answer · 2011-03-08 22:56:05Z

18

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

answered Mar 8, 2011 at 22:56

user1342582

Sign up to request clarification or add additional context in comments.

Comments

Ali Hitawala · Accepted Answer · 2012-11-02 14:28:08Z

6

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.

answered Nov 2, 2012 at 14:28

Ali Hitawala

612 silver badges6 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:46:52Z

5

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.

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Feb 14, 2011 at 11:35

SteD

14.1k13 gold badges69 silver badges77 bronze badges

1 Comment

user616076 Over a year ago

The second link has solved the problem but I will take the advice and create the table on startup and populate the table the first time to prevent the Apk from being too large. Thanks for your help.

Vishal Vaishnav · Accepted Answer · 2017-07-28 09:17:48Z

3

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

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

answered Jul 28, 2017 at 9:17

Vishal Vaishnav

3,4303 gold badges29 silver badges59 bronze badges

Comments

RivieraKid · Accepted Answer · 2011-02-14 11:49:00Z

2

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.

answered Feb 14, 2011 at 11:49

RivieraKid

5,9694 gold badges40 silver badges47 bronze badges

1 Comment

user616076 Over a year ago

Thanks for the reply, you are correct. I have now resolved it by creating the database on startup and populating the data the first time the app is loaded to prevent the Apk from being too large.

Marlon · Accepted Answer · 2018-11-02 13:49:30Z

1

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

answered Nov 2, 2018 at 13:49

Marlon

1,9072 gold badges21 silver badges42 bronze badges

Comments

Muwaffaq imam · Accepted Answer · 2014-08-05 09:16:46Z

0

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

answered Aug 5, 2014 at 9:16

Muwaffaq imam

1

Comments

Neuron · Accepted Answer · 2019-02-28 18:16:32Z

0

I just had a simple mistake.

Reason:

Solution:

answered Feb 28, 2019 at 18:16

Neuron

1,1272 gold badges15 silver badges28 bronze badges

Comments

Tim Meehan · Accepted Answer · 2019-04-05 04:04:52Z

0

Just happened to me. I don't exactly know why but changing the DB_VERSION attribute to a bigger number made it work. The thing is: each time i'm changing the fields of the DB (attributes of the SQLiteDB class), i need to change that number.

answered Apr 5, 2019 at 4:04

Tim Meehan

3003 silver badges8 bronze badges

Comments

Noor Hossain · Accepted Answer · 2022-08-12 10:12:12Z

0

Here is my answer according to the description of @ReivieraKid.

No, Uninstall, No Restart, Just checking the app memory if it is your real database, if return false, then copy the database to the memory again. Then You will All set. But to apply this method, you have to know the minimum size of your database.

https://stackoverflow.com/a/73332470/7608371

answered Aug 12, 2022 at 10:12

Noor Hossain

1,8712 gold badges21 silver badges29 bronze badges

Collectives™ on Stack Overflow

SQLiteException: no such table

10 Answers 10

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related