A SQLiteConnection object for database 'xxx/db' was leaked!

4,078 views
Skip to first unread message

赵坤

unread,
Nov 19, 2014, 9:03:13 AM11/19/14
to gree...@googlegroups.com
I got this WARNING, and I don't know how to solve this problem (>﹏<), someone can help me ? thank you!

11-19 21:57:53.329: W/SQLiteConnectionPool(19882): 
A SQLiteConnection object for database '/data/data/com.yah.one/databases/one-db' was leaked!  Please fix your application to end transactions in progress properly and to close the database when it is no longer needed.

Mahdi Sharifi

unread,
May 5, 2015, 8:55:27 AM5/5/15
to gree...@googlegroups.com
i solve this with :
private void initializeDB() {
helper = new DaoMaster.DevOpenHelper(getActivity(), DATABASE_NAME, null);
if (db == null) {
db = helper.getWritableDatabase();
logE("initializeDB->: db==null");
} else {
if (!db.isOpen()) {
db = helper.getWritableDatabase();
logE("initializeDB->: db!=null && !db.isOpen()");
} else {
logE("initializeDB->: db!=null && db.isOpen()");
}

}
daoMaster = new DaoMaster(db);
daoSession = daoMaster.newSession();

userDao = daoSession.getUserDao();

}
private void closeDb() {
db.close();
}
before every query i call initDB then CloseDB.
:)
Reply all
Reply to author
Forward
0 new messages