access .db file from assets in android

Question

i have a .db file with 2MB of size. i put it in assets folder in my project. And wrote the code as follow.but i got exception no table exits.please help me How to access .db file without copying into /databases.

db = openOrCreateDatabase("assets\\TDP.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
    db.setVersion(1);
    db.setLocale(Locale.getDefault());
    db.setLockingEnabled(true);
  //  db.execSQL("create table TD_ASSEMBLY(name Text,password Text);");
  Cursor cur = db.query("TD_ASSEMBLY", 
            null, null, null, null, null, null);
       cur.moveToFirst();
       while (cur.isAfterLast() == false) {
         String first= cur.getString(0); 
         String second=cur.getString(1);
         tx.append(first+"  "+second);
         cur.moveToNext();
       }

Community · Accepted Answer · 2017-05-23 12:33:14Z

2

Don't use a regular path to retrieve a file from assets. Use getAssets() instead.

The best option is to save it on first run to the database folder in your app. See my answer here: The data disappear after moving the application on a real device in android and the link therein for an example.

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Jun 6, 2011 at 7:31

Aleadam

40.4k9 gold badges88 silver badges108 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:15:07Z

0

refer these links' answers to copy database from assets:

adding your own SQLite database to an android application

Database not copying from assets

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jun 6, 2011 at 8:28

Jaydeep Khamar

5,9933 gold badges34 silver badges30 bronze badges

Collectives™ on Stack Overflow

access .db file from assets in android

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related