android sqlite 日志,android – SQLiteDatabase错误,无用的日志

我发布了我的应用程序的更新,我收到了很多用户的错误,我无法重新创建它或指出问题所在.

我得到的两个错误：

java.lang.IllegalStateException：尝试重新打开已关闭的对象：SQLiteDatabase

java.lang.IllegalStateException：数据库未打开

错误发生在以下代码中的某处：

public DBUserC getUser(int _id){

synchronized (DBAdapter.LOCK){

M.openDB(context);

Cursor cursor = M.database.query(DBUserHelper.TABLE_USERS,

VUser.allColumns, DBUserHelper.COLUMN_ID + " = '"+_id+"'", null, null, null, null);

DBUserC user;

if (cursor.moveToFirst()){

user = cursorToInfo(cursor);

} else{

user = newUser();

}

cursor.close();

M.closeDB();

return user;

}

}

在这个版本中,有一个数据库升级,我通过db.execSql执行三个查询.它不在一个单独的线程中.

在每次调用数据库时(onUpgrade除外),我同步,然后打开它,运行我的代码,然后关闭它.在升级之前我没有遇到任何问题,但无法找到问题.

任何帮助将不胜感激.

编辑：要打开我的数据库,我做：

if (helper==null)

helper = new DBAdapter(context);

if (database==null){

database = helper.getWritableDatabase();

} else if (!database.isOpen())

database = helper.getWritableDatabase();

并关闭：

helper.close();

helper = null;

database = null;

获取信息的示例方法：

public DBUserC getUser(int _id){

synchronized (DBAdapter.LOCK){

openDB(context);//this is the open code above

Cursor cursor = M.database.query(DBUserHelper.TABLE_USERS,

VUser.allColumns, DBUserHelper.COLUMN_ID + " = '"+_id+"'", null, null, null, null);

DBUserC user;

if (cursor.moveToFirst()){

user = cursorToInfo(cursor);//does not contain DB operations

} else{

user = newUser(); does not contain Database operations

}

cursor.close();

closeDB();//This is the close code above

return user;

}

}

AHost.onCreate

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

M.initializeDB(context); //synchronized call to the openDB code I posted above

M.openDataDB(context); //opens a different database by a different file name. This DB is not an issue

//irrelevant ui setup

int _id = pref.getInt(P.eLastUser, VUser.ID_NEW);//row id of user

M.requeryUser();//synchronized, access database

M.switchUser(_id);//synchronized, access database

}