Getting difficulty in removing database in SQLite

Question

I am using SQLite database in my application.I want to remove/delete the database but unable to do so.I have checked the location of the database and it is present at /data/data/org.secure.sms/databases but when i tried to delete it,it was not successful.Please help me. This is the code:

public static void DeleteDatabase(Context context)
{
    try
    {

    String filePath = context.getFilesDir()+ File.separator + "contactsManager";
    String filePath1 = context.getFilesDir()+ File.separator + "database";
    String filePath2 = context.getFilesDir()+ File.separator + "databases";

    context.deleteDatabase(filePath);
    context.deleteDatabase(filePath1);
    context.deleteDatabase(filePath2);

    File file = new File(filePath);
    File file1 = new File( filePath1 );

context.deleteFile(file.getName());
context.deleteFile(file1.getName());
    }
    catch(Exception e)
    {
        Toast.makeText(context,"Exception in DeleteDatabase",Toast.LENGTH_SHORT).show();
    }

}

Please help me.Thanks in advance.

can you please provide error stack?

Naresh J
– Naresh J

2012-10-16 09:59:41 +00:00
Commented Oct 16, 2012 at 9:59 — Naresh J
– Naresh J, Commented Oct 16, 2012 at 9:59

Yaqub Ahmad · Accepted Answer · 2012-10-16 10:12:56Z

2

I use this to delete my database, which is from a custom class which extends SQLiteOpenHelper.

private final static String DATABASE_NAME = "pain.db";

private static final String DB_PATH = "/data/data/YOUR.PACKAGE.NAME/databases/" + DATABASE_NAME;


@Override
    public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

        Log.d("DATABASE UPDATED", "DATABASE UPDATED");

        try {
            File file = new File(DB_PATH);
            file.delete();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

edited Oct 16, 2012 at 10:12

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

answered Oct 16, 2012 at 10:03

Richard_S

344 bronze badges

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

Comments

Naresh J · Accepted Answer · 2012-10-16 10:23:02Z

1

For deleting the database, this one is the code:

context.deleteDatabase(DATABASE_NAME);

In your code you are providing complete path.

edited Oct 16, 2012 at 10:23

answered Oct 16, 2012 at 10:01

Naresh J

2,1475 gold badges26 silver badges39 bronze badges

4 Comments

user1726619 Over a year ago

sir i have provided complete path but i am getting this message in logcat:

user1726619 Over a year ago

10-16 15:15:44.578: D/(9319): unable to unlink '/data/data/org.secure.sms/files/contactsManager': No such file or directory (errno=2) 10-16 15:15:44.607: D/(9319): unable to unlink '/data/data/org.secure.sms/files/database': No such file or directory (errno=2)

Naresh J Over a year ago

@YaqubAhmad : FYI check this developer.android.com/reference/android/content/…

Naresh J Over a year ago

@user1726619 : as error itself explains the database you are trying to delete is not present. Either path is wrong or try to add extension .db to your database name.

Yaqub Ahmad · Accepted Answer · 2012-10-16 10:16:28Z

0

You are missing the file Extension !! Try below:

String filePath = context.getFilesDir()+ File.separator + "yourDataBaseName.db";

answered Oct 16, 2012 at 10:16

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

Collectives™ on Stack Overflow

Getting difficulty in removing database in SQLite

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related