我使用以下代码从assets导入一个预填充(ORMLite)数据库。在多个设备上运行良好,但在Galaxy Note 10.1上关闭操作完成后会出现异常:“error code = 11, msg = database corruption at line ....”。当我从设备下载数据库并在SqliteBrowser中打开时,一切似乎都是正常的。有什么想法吗?
public class MySQLiteOpenHelper extends SQLiteOpenHelper {
// {....}
public void importDB() {
InputStream is = context.getAssets().open("DBName.db");
try {
close();
FileOutputStream os = new FileOutputStream(new File(Environment.getDataDirectory(), dbPath));
try {
byte[] buffer = new byte[4096];
for (int n; (n = is.read(buffer)) != -1;) {
os.write(buffer, 0, n);
}
} finally {
os.close();
}
} finally {
is.close();
}
getWritableDatabase().close();
}
错误:
I/SqliteDatabaseCpp(684): sqlite returned: error code = 11, msg = database corruption at line 48171 of [ed759d5a9e], db=/data/data/app_name/databases/DBName_db
I/SqliteDatabaseCpp(684): sqlite returned: error code = 11, msg = database disk image is malformed, db=/data/data/app_name/databases/DBName_db
E/SqliteDatabaseCpp(684): sqlite3_exec - Failed to set synchronous mode = 1(Normal)
I/SqliteDatabaseCpp(684): sqlite returned: error code = 11, msg = database corruption at line 48171 of [ed759d5a9e], db=/data/data/app_name/databases/DBName_db
I/SqliteDatabaseCpp(684): sqlite returned: error code = 11, msg = database disk image is malformed, db=/data/data/app_name/databases/DBName_db
E/SqliteDatabaseCpp(684): CREATE TABLE android_metadata failed
E/DefaultDatabaseErrorHandler(684): Corruption reported by sqlite on database: /data/data/app.name/databases/DBName.db
E/DefaultDatabaseErrorHandler(684): deleting the database file: /data/data/app.name/databases/DBName.db
SQLiteAssetHelper
中可以找到:https://github.com/jgilfelt/android-sqlite-asset-helper - CommonsWaregetWritableDatabase().close()
吗? - Wolfram Rittmeyer