CODEWITHSUNDEEP
androidsqlite
kiran
kiran

Reputation: 3264

How to over come database not opened exception?

I am implementing an app related to database.

So many times I am calling open and close database connection to insert, update and delete.

It is working fine.

But some times I am getting a database not opened exception in different situations.

How to solve these issues?

Upvotes: 0

Views: 106

Answers (2)

avepr
avepr

Reputation: 1896

Based on the information you provided I can assume that the problem is in your business logic and nobody but you should be able to tell you the root cause. Without your code here, we won't be able to point you to exact place. One of the possible reasons can be that by your business logic you are trying to do some operation (insert, update whatever) on closed database.

You can do some workaround to try to ensure that your DB is always open when it is needed. If you implement database getter method with so called lazy initialization approach it will guarantee at least, that the DB is open when you need to access it.

Here is what I am talking about: 1. make a public method which supposed to return DB object:

public SQLiteDatabase getDB() {
    if ((mDataBase == null) || (!mDataBase.isOpen())) {
        // create or open your database using an OpenHelper
        mDataBase = SQLiteOpenHelper.getWritableDatabase();
    }
    return mDataBase;
}

Now, everywhere in your code use this method to access the DB instead of directly accessing a variable mDataBase.

Note that the code is just to give you an idea and not actually compilable. Still, I would recommend you to fix your business logic instead of using this workaround.

Upvotes: 1

Jigar Pandya
Jigar Pandya

Reputation: 5987

Well unless you put proper exception handling you would never know what causes this.

However a good idea is to adopt good ORM mapper for SQL Light with Android and this will improve your database interactions and exception handling and opening and closing it efficiently.

You can opt for SUGAR or ORMLight if you wish; In my opinion this should help you to fix your problem.

Upvotes: 1

Related Questions