java.lang.illegalstateexception database not open android

Question

When I am trying to insert to data base log cat shows an error like java.lang.illegalstateexception database not open android.

But I have opened the db using

   db = SQLiteDatabase.openDatabase(DATABASE_PATH, null,
                SQLiteDatabase.OPEN_READWRITE);

The error is not occurring frequently.Anybody know the reason for this?

score 13 · Accepted Answer · answered May 29 '12 at 11:15

13

Try it like this:

  if (!db.isOpen()) {
       db = getApplicationContext().openOrCreateDatabase(DATABASE_PATH, SQLiteDatabase.OPEN_READWRITE, null);
     }

answered May 29 '12 at 11:15

Simon Dorociak

33,374
10
68
106

I tried this but instead of getApplicationContext() I have added SQLiteDatabase.How will get applicationcontext in a class extended from SQLiteOpenHelper – user1414146 May 29 '12 at 11:20
1

so contructor of your `SQLiteOpenHelper` takes one parameter `Context context` so `context.openOrCreateDatabase()` ... – Simon Dorociak May 29 '12 at 11:25

score 2 · Answer 2 · answered May 29 '12 at 11:11

2

try

DatabaseHelper dataHelper;
SQLiteDatabase mDb;
    public DbManager openDB() throws SQLException {

    mDb = dataHelper.getWritableDatabase();
    return this;
}

and call this method where your re writing your current code.

answered May 29 '12 at 11:11

GAMA

5,958
14
79
126

score 0 · Answer 3 · answered May 29 '12 at 11:26

Try this code

 public class DataBaseHelper extends SQLiteOpenHelper{
    public SQLiteDatabase openDataBase() throws SQLException{

            //Open the database

            File dbFile = _myContext.getDatabasePath( DB_PATH + DB_NAME ); 
            _myDataBase = SQLiteDatabase.openDatabase(dbFile.toString(), null, SQLiteDatabase.OPEN_READWRITE);

            return _myDataBase;
        }//end of openDataBase() method
}

score -1 · Answer 4 · answered May 29 '12 at 11:11

-1

maybe you are opening an opened Database. close your database every time your work is done.

answered May 29 '12 at 11:11

Bob

22,810
38
143
225

java.lang.illegalstateexception database not open android

4 Answers4

Linked