Usage Of Sqliteopenhelper.getwritabledatabase

According to http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html#getWritableDatabase%28%29 Once opened successfully, the database is cached, so yo

Solution 1:

When you open a data base by using db openHelperImplObj.getWritableDatabase(); then following thing check

1>If database is not created then it create database and open it for write mode else created first then open.

2>Second and most important what i have observed if data base is already created then it opened it but if its open already it do nothing, That means it occupy the old instance of data base that open DB already until you close it.Thats why its better practice to close DB once it use over

Hope you got