android - 无法以读/写模式打开数据库

Question

我正在尝试从我的 SD 卡加载数据库文件，但出现异常。以下是异常(exception)情况

org.sqlite.database.sqlite.SQLiteException: not an error (code 0): Could not open the database in read/write mode.

这是我的代码:

public void csr_test_1() throws Exception 

{

DB_PATH=new File("/storage/sdcard1/sk2.db");
   SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(DB_PATH, null);
   String res = "";


Cursor c = db.rawQuery("SELECT synsetid, w2.lemma FROM sense LEFT JOIN word AS w2 ON   w2.wordid=sense.wordid WHERE sense.synsetid IN (SELECT sense.synsetid FROM word AS w1 LEFT      JOIN sense ON w1.wordid=sense.wordid WHERE w1.lemma='"+ "life" + "') AND w2.lemma<>'" + "life" + "'", null);
if( c!=null ){
 boolean bRes;
 for(bRes=c.moveToFirst(); bRes; bRes=c.moveToNext()){
String x = c.getString(0);
res = res + "." + x;
}
}else{
}
test_result("csr_test_1.1", res, ".one.two.three");

db.close();
test_result("csr_test_1.2", db_is_encrypted(), "unencrypted");
}

这些是我正在使用的权限

<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.ACCESS_WIFI_STATE" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.WRITE_SETTINGS" />
<uses-permission android:name="android.permission.EXPAND_STATUS_BAR" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="com.android.vending.BILLING" />

![enter image description here][1]
![enter image description here][2]

请帮帮我……谢谢

Answer 1

如果 sqlite3_db_readonly() returns non-zero 则抛出此异常.它可以返回非零，如果

• 数据库文件是只读的，或者

• 数据库文件不存在。

( Reference )

您有一个硬编码路径 "/storage/sdcard1/sk2.db" - 很可能那里不存在数据库。使用来自 Environment 的变量访问您的外部存储而不是硬编码路径。