How to access sqlite database in the asset folder of an android project?

Question

I need help to use use my existing sqlite database in android.

i am placing my sqlite database in "/assets/(mydatabase)" but unable to use it.

i am using following code. some times it show error "unable to open database" and some times shows error like "can not find table". when i pull out database file from ddms and open it using sqlite browser it dropes my table means my table do not exist any more.

so please help me to get the way how i can use my existing sqlite databse in android just for read and rite operations.

private SQLiteDatabase MyDataBase;
private String path="/data/data/mypackagename/mydatabase";
try{
      MyDataBase=SQLiteDatabase.openDatabase(path, null,SQLiteDatabase.OPEN_READWRITE);
      Cursor myDbCursor;
      myDbCursor=MyDataBase.rawQuery("select user,password from login_master", null);
      String username=myDbCursor.getString(0);
      String password=myDbCursor.getString(01);
      Toast.makeText(getBaseContext(), username, 10).show();
      Toast.makeText(getBaseContext(), password, 10).show();
      MyDataBase.close();
  }
  catch(SQLiteException e){
      Toast.makeText(getBaseContext(), e.getMessage(), 10).show();
  }

Thanks pinakin had the problem and this post helped +1 for u :) — samir
– samir, Commented Nov 23, 2012 at 6:14

Hardik Nadiyapara · Accepted Answer · 2012-08-03 18:20:48Z

1

not sure but this can help you

void checkDB() throws Exception {
    try {
        SQLiteDatabase dbe = SQLiteDatabase
                .openDatabase(
                        "/data/data/yourpackagename/databases/yourfilename.sqlite",
                        null, 0);
        Log.d("opendb", "EXIST");
        dbe.close();
    } catch (Exception e) {

        AssetManager am = getApplicationContext().getAssets();
        OutputStream os = new FileOutputStream(
                "/data/data/yourpackagename/databases/yourfilename.sqlite");
        byte[] b = new byte[100];

        int r;
        InputStream is = am.open("yourfilename.sqlite");
        while ((r = is.read(b)) != -1) {
            os.write(b, 0, r);
        }
        Log.i("DATABASE_HELPER", "Copying the database ");
        is.close();
        os.close();
    }

}

answered Aug 3, 2012 at 18:20

Hardik Nadiyapara

2,4462 gold badges18 silver badges25 bronze badges

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

1 Comment

Pinakin Kansara Over a year ago

This Really works Hardik . i missed copying portion in my code. Thanks

Community · Accepted Answer · 2017-05-23 11:48:14Z

0

Duplication: SQLite Android . unable to open database file

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Aug 3, 2012 at 18:31

Maxim

4,2448 gold badges53 silver badges77 bronze badges

Collectives™ on Stack Overflow

How to access sqlite database in the asset folder of an android project?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related