Android: unable to open database file [duplicate]

Question

When I tried to open a sqlite database, it caught exception :

android.database.sqlite.SQLiteException : unable to open databse file.

My code is :

 final String  DATABASENAME   =    "MY_DB"; 
 SQLiteDatabase   objDb =  this.openOrCreateDatabase(DATABASENAME, MODE_PRIVATE, null);

Edited

This is working fine android 2.2. But it caught exception in android 2.1.

Please help me... Thank you..

show your DATABASENAME value

Nataliia.dev
– Nataliia.dev

2012-03-15 19:33:32 +00:00
Commented Mar 15, 2012 at 19:33 — Nataliia.dev
– Nataliia.dev, Commented Mar 15, 2012 at 19:33

nhahtdh · Accepted Answer · 2012-09-19 17:39:52Z

2

File sdcardfile = Environment.getExternalStorageDirectory();

db = SQLiteDatabase.openOrCreateDatabase(sdcardfile.getPath()
                                         + "/BadBrain/question.db", null);

Make sure the "BadBrain" directory exists, or you can create it!

edited Sep 19, 2012 at 17:39

nhahtdh

56.9k15 gold badges131 silver badges164 bronze badges

answered Sep 19, 2012 at 14:49

user1683371

213 bronze badges

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

Comments

Kislingk · Accepted Answer · 2012-05-04 18:41:38Z

1

Please also check permission(android.permission.WRITE_EXTERNAL_STORAGE) on manifest.xml.

answered May 4, 2012 at 18:41

Kislingk

1,45715 silver badges23 bronze badges

Comments

RootCode · Accepted Answer · 2013-10-14 05:21:09Z

1

I got the same error while running my app on JB devices. I was because they altered database path /data/data/{package_name}/databases/. To resolve use Android inbuilt API method as follows rather than hard coded path

mContext.getDatabasePath(DATABASE_NAME).getPath();

answered Oct 14, 2013 at 5:21

RootCode

5797 silver badges13 bronze badges

Comments

Anju · Accepted Answer · 2011-03-09 09:11:35Z

0

Try and see like this.

SQLiteDataBase objDb = SQLiteDatabase.openDatabase(DATABASENAME, null, SQLiteDatabase.OPEN_READWRITE);

answered Mar 9, 2011 at 9:11

Anju

9,48915 gold badges60 silver badges96 bronze badges

1 Comment

Jomia Over a year ago

I am still getting the same error

Stevanicus · Accepted Answer · 2011-05-18 23:51:15Z

0

do you have the table android_meta data and locale set in your table?

Look at first steps here: http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/

answered May 18, 2011 at 23:51

Stevanicus

7,7819 gold badges52 silver badges73 bronze badges

Collectives™ on Stack Overflow

Android: unable to open database file [duplicate]

Edited

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Edited

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Linked

Related