logo标签列表

SQLiteAssetHelper：无法写入打开数据库（将尝试只读）

javaandroidandroid-sqlite
4

这个问题已经被许多人问过了，但是即使我按照他们的步骤来操作，仍然无法解决我的问题。我的应用在模拟器上运行良好，但在真实设备上却出现以下两个异常。第一个异常是第二个异常的主要原因，我猜测这可能是权限问题。我已经添加了

标签。

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>

将其添加到清单文件中但我得到了相同的结果。我的数据库非常简单，只有一个表。此外，我已经添加了“android_metadata”表，并编辑了我的其他表的id字段为“_id”。我确定我的数据库存在于资产文件夹中。
任何帮助将不胜感激。
第一个异常。
02-24 12:58:10.067: E/SQLiteAssetHelper(7107): Couldn't open Shajra for writing (will try read-only):
02-24 12:58:10.067: E/SQLiteAssetHelper(7107): com.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: Missing databases/Shajra file (or .zip, .gz archive) in assets, or target folder not writable
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.content.res.AssetManager.openAsset(Native Method)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.content.res.AssetManager.open(AssetManager.java:325)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.content.res.AssetManager.open(AssetManager.java:299)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.copyDatabaseFromAssets(SQLiteAssetHelper.java:436)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.createOrOpenDatabase(SQLiteAssetHelper.java:400)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getWritableDatabase(SQLiteAssetHelper.java:176)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:254)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.nannandotcom.MainActivity.onCreate(MainActivity.java:27)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1072)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1836)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1893)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.ActivityThread.access$1500(ActivityThread.java:135)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1054)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.os.Handler.dispatchMessage(Handler.java:99)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.os.Looper.loop(Looper.java:150)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at android.app.ActivityThread.main(ActivityThread.java:4389)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at java.lang.reflect.Method.invokeNative(Native Method)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at java.lang.reflect.Method.invoke(Method.java:507)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:849)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:607)
02-24 12:58:10.067: E/SQLiteAssetHelper(7107):  at dalvik.system.NativeStart.main(Native Method)

第二个异常

02-24 12:58:10.077: E/Database(7107): dbopen(): sqlite3_open_v2("/data/data/com.example.nannandotcom/databases/Shajra", &handle, 1, NULL) failed
02-24 12:58:10.077: E/Database(7107): dbopen(): errno = 2, error message = No such file or directory
02-24 12:58:10.077: D/AndroidRuntime(7107): Shutting down VM
02-24 12:58:10.077: W/dalvikvm(7107): threadid=1: thread exiting with uncaught exception (group=0x4011f5a0)
02-24 12:58:10.108: E/AndroidRuntime(7107): FATAL EXCEPTION: main
02-24 12:58:10.108: E/AndroidRuntime(7107): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.nannandotcom/com.nannandotcom.MainActivity}: android.database.sqlite.SQLiteException: unable to open database file
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1872)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1893)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread.access$1500(ActivityThread.java:135)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1054)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.os.Handler.dispatchMessage(Handler.java:99)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.os.Looper.loop(Looper.java:150)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread.main(ActivityThread.java:4389)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at java.lang.reflect.Method.invokeNative(Native Method)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at java.lang.reflect.Method.invoke(Method.java:507)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:849)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:607)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at dalvik.system.NativeStart.main(Native Method)
02-24 12:58:10.108: E/AndroidRuntime(7107): Caused by: android.database.sqlite.SQLiteException: unable to open database file
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.database.sqlite.SQLiteDatabase.dbopen(Native Method)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1962)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:906)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getReadableDatabase(SQLiteAssetHelper.java:264)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at com.nannandotcom.MainActivity.onCreate(MainActivity.java:27)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1072)
02-24 12:58:10.108: E/AndroidRuntime(7107):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1836)
02-24 12:58:10.108: E/AndroidRuntime(7107):     ... 11 more

数据库助手

package com.nannandotcom;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.nannandotcom.model.ProfileBean;
import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;

public class DatabaseHelper extends SQLiteAssetHelper {

    private static final String DATABASE_NAME = "Shajra";
    private static final int DATABASE_VERSION = 1;

    private Context context;

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.context = context;
    }

    public void copyDatabase() throws IOException{
    //  SQLiteDatabase checkDB = SQLiteDatabase.openDatabase(context.getAssets().+(DATABASE_NAME), null, SQLiteDatabase.OPEN_READONLY);
    //  checkDB.close();
    InputStream myInput = context.getAssets().open(DATABASE_NAME);      
    String outFileName =  "/data/data/"+ context.getPackageName() + "/databases/" + DATABASE_NAME;     
    OutputStream myOutput = new FileOutputStream(outFileName);

    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer))>0){
        myOutput.write(buffer, 0, length);
    }

    myOutput.flush();
    myOutput.close();
    myInput.close();
    }

    public ProfileBean getProfileBean(SQLiteDatabase database,int id){
        ProfileBean profileBean = new ProfileBean();
        try {
            Cursor c = database.query("Profiles",
                    new String[]{"_id","Name","Qualification","WorkingAt","LivesAt","MaritalStatus","NumberOfChildren",
                    "Telephone","Email","Picture","MarriedTo","Father","Mother","DOB","Gender"},
                    "_id=?",
                    new String[]{Integer.toString(id)},null, null, null);
            if (c != null ) {
                if  (c.moveToFirst()) {
                    do {

                    }while (c.moveToNext());
                } 
            }   
        }
        catch(Exception e){
            e.printStackTrace();
        }
        return profileBean;
    }
}

主活动

package com.nannandotcom;

import java.io.IOException;
import com.example.nannandotcom.R;

import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends Activity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        DatabaseHelper databaseHelper = new DatabaseHelper(this);
        SQLiteDatabase database = databaseHelper.getReadableDatabase();

        try {
            databaseHelper.copyDatabase();
    }   
        }catch(SQLException sqle){

            throw sqle;

        }
        }
        catch(Exception e){
            Log.e("MainActivity", e.getMessage());
            e.printStackTrace();
        }

        final EditText enterName = (EditText) findViewById(R.id.editText1);
        Button submit = (Button) findViewById(R.id.button1);
        submit.setOnClickListener(new OnClickListener() {

            @Override
            public void onClick(View v) {
                Intent mainActivityIntent = new   Intent(MainActivity.this, Welcome.class);
                mainActivityIntent.putExtra("userName", enterName.getText().toString());
                startActivity(mainActivityIntent);
            }
        });
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }

}
你能添加一段代码吗？ - Unii
我已经添加了DatabaseHelper和MainActivity类。 - SSH
7个回答
4
我认为你在DATABASE_NAME中缺少了db扩展名。因此，请根据资产目录提供带有扩展名的特定DATABASE_NAME。请替换。
private static final String DATABASE_NAME = "Shajra";

带有

。
private static final String DATABASE_NAME = "Shajra.db";

或者

private static final String DATABASE_NAME = "Shajra.sqlite";
我正在使用sqlitestudio2.1.5，结果得到了"Shajra.file"，我有点困惑这是什么类型的文件以及如何给它一个扩展名...我需要将其转换吗... - SSH
现在它在模拟器中无法运行并出现以下异常.....java.lang.RuntimeException: 无法启动活动 ComponentInfo{com.example.nannandotcom/com.example.nannandotcom.MainActivity}: com.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: 在资产中缺少 databases/Shajra.sqlite 文件（或 .zip、.gz 存档文件），或目标文件夹不可写。 - SSH
我所做的就是在代码中更改了字符串，我的资产文件仍然是相同的，没有被修改。 - SSH
你是否已经将 Shajra.sqlite 存储在 assets 目录中？ - Chirag Ghori
4
整晚上都困扰着我同样的问题，我的解决方法是：
通过官方方式在Android Studio中创建“assets”文件夹：右键单击您的应用模块 -> 新建 -> 文件夹 -> assets
2

Android Studio有可能在您不知情的情况下更改DATABASE_NAME...

将db文件放在assets/databases子目录中。

然后请确保更改：

private static final String DATABASE_NAME = "databases/mydb.db";

to

private static final String DATABASE_NAME = "mydb.db";

这是我的问题。
2

噢，那是我的糟糕问题，最终我找到了解决方案！

所以你应该将数据库文件重命名，以小写字母开头，然后

private static final String DATABASE_NAME = "mydata.db";
    private static final int DATABASE_VERSION = 1;

    public DatabaseOpenHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
1
在我的情况下，SQLiteHelper继承了SQLiteOpenHelper，然后我有一个自定义类，利用这个SQLiteHelper来使用下面的3个方法（初始化、打开和关闭）。请看一下dbHelper.getWritableDatabase();方法。那可能是你需要的。
private SQLiteDatabase database;
private SQLiteHelper dbHelper;

public CallHistoryDataSource(Context context) {
    dbHelper = new SQLiteHelper(context);
}

private void open() throws SQLException {
    database = dbHelper.getWritableDatabase();
}

private void close() {
    dbHelper.close();
}
0

对我来说，它抛出了相同的错误，我通过以下步骤解决了问题

步骤1：添加权限

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

步骤2：添加运行时权限

if (ContextCompat.checkSelfPermission(MainActivity.this,
                Manifest.permission.READ_CONTACTS)
                != PackageManager.PERMISSION_GRANTED) {

            ActivityCompat.requestPermissions(MainActivity.this,
                    new String[]{Manifest.permission.WRITE_EXTERNAL_STORAGE},
                    101);
        }else {
            db=new DbUtils(MainActivity.this);
        }

步骤3：按照以下说明更改Assets文件夹中的文件名

private static final String DATABASE_NAME = "thirukkural.db";

在资源文件夹中的文件名（这是导致错误的原因）

旧文件名 thirukkural

新文件名 thirukkural.db

注意：没有扩展名的文件名

0

当您将数据库复制到SD卡时，请使用此方法分配路径。

String outFileName =  Environment.getExternalStorageDirectory() + "/databases/" + DATABASE_NAME;

只有在成功的情况下，如果您想从数据库中仅读取记录，则需要调用databaseHelper.getReadableDatabase();或者如果您想要读取和写入两者都需要调用databaseHelper.getWritableDatabase();

第一个异常通过使用databaseHelper.getWritableDatabase()解决了；谢谢这个。但是第二个仍然导致应用程序崩溃... - SSH
这是第一个还是第二个？你现在遇到了什么异常？ - Rakhita
现在我正在遇到这个问题...... java.lang.RuntimeException: 无法启动活动 ComponentInfo{com.example.nannandotcom/com.nannandotcom.MainActivity}: com.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: assets 中缺少 databases/Shajra 文件 (或 .zip、.gz 存档文件)，或目标文件夹不可写。 - SSH
使用....Environment.getExternalStorageDirectory() + "/databases/" + DATABASE_NAME;.......... E/MainActivity: /mnt/sdcard/databases/Shajra (权限被拒绝) W/System.err: java.io.FileNotFoundException: /mnt/sdcard/databases/Shajra (权限被拒绝) W/System.err: at org.apache.harmony.luni.platform.OSFileSystem.open(Native Method) - SSH
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接