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();
       }

score 2 · Answer 1 · edited May 23 '17 at 12:33

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 '17 at 12:33

Community

1
1

answered Jun 06 '11 at 07:31

Aleadam

40,203
9
86
108

score 0 · Answer 2 · edited May 23 '17 at 12:15

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 '17 at 12:15

Community

1
1

answered Jun 06 '11 at 08:28

Jaydeep Khamar

5,975
3
32
30

access .db file from assets in android

2 Answers2