Android SQLITE Illegal State Exception

Question

I am using the following code to add items to the Database :

public static void insertQuestion(Context c,JSONArray jarr,String search) throws JSONException {
        DatabaseWrapper databaseWrapper = new DatabaseWrapper(c);
        SQLiteDatabase database = databaseWrapper.getWritableDatabase();
        ContentValues values = postToContentValues2(jarr);
        values.put(QuestionORM.COLUMN_SEARCH,search);
        long questionId = database.insert(QuestionORM.TABLE_NAME, "null", values);
        Log.e(TAG, "Inserted new Question with ID: " + questionId);
        database.close();
    }

But I get an error saying

"attempt to re-open an already-closed object"

on this line :

SQLiteDatabase database = databaseWrapper.getWritableDatabase();

How do I resolve this ?

Thanks !

Post the full stacktrace and your sqlite helper `onCreate()` / `onUpgrade()` callbacks. — laalto, Apr 30 '15 at 08:03

Imtiyaz Khalani · Accepted Answer · 2015-04-30T07:56:25.420

0

check before open it

if(database != null && database.isOpen()){
// if open then don't open
}

---- UPDATE ----

// add this method in your class calss

private SQLiteDatabase myDataBase;

...

    public boolean isDatabaseOpened() {
        if (myDataBase == null) {
            return false;
        }
        return myDataBase.isOpen();
    }

if method returns false then only call getWritableDatabase() or getReadableDatabas() as per your requirement.

edited Apr 30 '15 at 07:56

answered Apr 30 '15 at 07:38

Imtiyaz Khalani

2,037
18
32

Can you explain further in context to my question? Where exactly do I put this ? Above the second line ? – Shivam Bhalla Apr 30 '15 at 07:40
you have object databaseWrapper right? and override method in databaseWrapper class add my code in it. – Imtiyaz Khalani Apr 30 '15 at 07:46
But databaseWrapper doesn't have a method called isOpen() ? – Shivam Bhalla Apr 30 '15 at 07:51
@ShivamBhalla please check upate. – Imtiyaz Khalani Apr 30 '15 at 07:56
Yes this solves the problem. Though I am still unable to add items. The Log shown here is never displayed. Why is that ? – Shivam Bhalla Apr 30 '15 at 08:05
post log if you getting any problme – Imtiyaz Khalani Apr 30 '15 at 09:04
No there are no errors. I am just not getting any data in the database. – Shivam Bhalla Apr 30 '15 at 09:10

Android SQLITE Illegal State Exception

1 Answers1

Linked