代码之家 › 专栏 › 技术社区 › Dante

代码14:无法打开数据库

sqliteopenhelper sqlite database android java

1

Dante · 技术社区 · 7 年前

我知道以前有人问过这个问题。但是,问题是,相同的代码(用于数据库处理程序)正在为另一个应用程序工作,但不是我当前正在处理的应用程序。我甚至通过在“设置”中检查权限来确保授予权限。下面是日志:

05-13 15:35:45.693 29696-29696/com。实例乱劈更正程序E/SQLiteLog:(14)无法打开[5a3022e081]第31282行的文件 (14) os\U unix。c: 31282:(21)打开(/data/user/0/com.example.hack.corrector/databases/)- 05-13 15:35:45.694 29696-29696/com。实例乱劈更正程序E/SQLITEDABASE:未能打开数据库“/数据/用户/0/com”。实例乱劈校正器/数据库/'。安卓数据库sqlite。SqliteContoPendatabaseException:未知错误(代码14):无法打开数据库在android上。数据库sqlite。SQLiteConnection。nativeOpen(本机方法) 在android上。数据库sqlite。SQLiteConnection。打开(SQLiteConnection.java:207) 在android上。数据库sqlite。SQLiteConnection。打开(SQLiteConnection.java:191) 在android上。数据库sqlite。SQLiteConnectionPool。openConnectionLocked(SQLiteConnectionPool.java:463) 在android上。数据库sqlite。SQLiteConnectionPool。打开(SQLiteConnectionPool.java:185) 在android上。数据库sqlite。SQLiteConnectionPool。打开(SQLiteConnectionPool.java:177) 在android上。数据库sqlite。SQLiteDatabase。openInner(SQLiteDatabase.java:806) 在android上。数据库sqlite。SQLiteDatabase。打开(SQLiteDatabase.java:791) 在android上。数据库sqlite。SQLiteDatabase。openDatabase(SQLiteDatabase.java:694) 在android上。数据库sqlite。SQLiteDatabase。openDatabase(SQLiteDatabase.java:669) 在com。实例hakc。校正器。VocabDatabase。openDataBase(VocabDatabase.java:127) 在com。实例hakc。校正器。刮伤服务。createDB(scrapeservice.java:31) 在com。实例hakc。校正器。刮伤服务。onStartCommand(scrapeservice.java:23) 在android上。应用程序。ActivityThread。handleServiceArgs(ActivityThread.java:3049) 在android上。应用程序。ActivityThread。access$2300(ActivityThread.java:154) 在android上。应用程序。ActivityThread$H.handleMessage(ActivityThread.java:1479) 在android上。操作系统。处理程序。dispatchMessage(Handler.java:102) 在android上。操作系统。活套。循环(Looper.java:157) 在android上。应用程序。ActivityThread。main(ActivityThread.java:5571) 在java。lang.reflect。方法调用(本机方法) 在com。安卓内部的操作系统。ZygoteInit$MethodandArgscaler。运行(ZygoteInit.java:745) 在com。安卓内部的操作系统。合子岩。main(ZygoteInit.java:635)

下面是数据库处理程序代码:

package com.example.hack.corrector;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;

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


public class VocabDatabase extends SQLiteOpenHelper {

//The Android's default system path of your application database.
private static String DB_PATH = "";

private static String DB_NAME = "ztr.db";

private SQLiteDatabase myDataBase;

private final Context myContext;

/**
 * Constructor
 * Takes and keeps a reference of the passed context in order to access to the application assets and resources.
 *
 * @param context
 */
public VocabDatabase(Context context) {

    super(context, DB_NAME, null, 1);
    this.myContext = context;
    this.DB_PATH = context.getApplicationInfo().dataDir + "/databases/";
}

/**
 * Creates a empty database on the system and rewrites it with your own database.
 */
public void createDataBase() throws IOException {

    boolean dbExist = checkDataBase();

    if (dbExist) {
        //do nothing - database already exist
    } else {
        //By calling this method and empty database will be created into the default system path
        //of your application so we are gonna be able to overwrite that database with our database.
        this.getWritableDatabase();

        try {
            copyDataBase();
        } catch (IOException e) {
            throw new Error("Error copying database");

        }

    }

}

/**
 * Check if the database already exist to avoid re-copying the file each time you open the application.
 *
 * @return true if it exists, false if it doesn't
 */
private boolean checkDataBase() {
    this.getReadableDatabase();

    SQLiteDatabase checkDB = null;

    try {
        String myPath = DB_PATH;
        checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);

    } catch (SQLiteException e) {
        e.printStackTrace();
    }

    if (checkDB != null) {

        checkDB.close();

    }

    return (checkDB != null) ? true : false;
}

/**
 * Copies your database from your local assets-folder to the just created empty database in the
 * system folder, from where it can be accessed and handled.
 * This is done by transfering bytestream.
 */
private void copyDataBase() throws IOException {

    //Open your local db as the input stream
    InputStream myInput = myContext.getAssets().open(DB_NAME);

    // Path to the just created empty db
    String outFileName = DB_PATH + DB_NAME;

    //Open the empty db as the output stream
    OutputStream myOutput = new FileOutputStream(outFileName);

    //transfer bytes from the inputfile to the outputfile
    byte[] buffer = new byte[1024];
    int length = 0;
    while ((length = myInput.read(buffer)) > 0) {
        myOutput.write(buffer, 0, length);
    }

    //Close the streams
    myOutput.flush();
    myOutput.close();
    myInput.close();

}

public void openDataBase() throws SQLException {

    //Open the database
    String myPath = DB_PATH;
    myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);

}

@Override
public synchronized void close() {

    if (myDataBase != null)
        myDataBase.close();

    super.close();

}

@Override
public void onCreate(SQLiteDatabase db) {

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    if (newVersion > oldVersion) {
        try {
            copyDataBase();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

// Add your public helper methods to access and get content from the database.
// You could return cursors by doing "return myDataBase.query(....)" so it'd be easy
// to you to create adapters for your views.

//add your public methods for insert, get, delete and update data in database.

public Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy) {
    SQLiteDatabase db = this.getWritableDatabase();
    return db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy);
}

public long insert(String table, String nullColumnHack, ContentValues contentValues) {
    SQLiteDatabase db = this.getWritableDatabase();
    return db.insert(table, nullColumnHack, contentValues);
}

public Cursor rawQuery(String string, String[] selectionArguments) {
    SQLiteDatabase db = this.getWritableDatabase();
    return db.rawQuery(string, selectionArguments);
}

}

我已经检查了文件资源管理器,数据库已经复制到位。但错误仍在发生。我从未遇到过其他实现相同数据库处理程序代码(Vocabdatabase)的应用程序的问题。我花了一天半的时间试图解决这个问题,但什么都没用。。。

1 回复 | 直到 7 年前

1

2

MikeT 7 年前

您的问题是,您试图使用不包含数据库名称的路径打开。

i、 e.无法打开14用于

/data/user/0/com.example.hack.corrector/databases/

打开时应尝试打开 /data/user/0/com.example.hack.corrector/databases/ztr.db

不使用完整路径将导致两个问题,这很可能导致混淆。

当您检查数据库是否存在时,将发出消息(请注意,由于数据库永远不会被找到(打开),因此每次都会复制数据库)
当您尝试打开数据库时,也会发出这些消息,后者失败。

在这两种情况下,正确的用法应该是DB\u PATH+DB\u NAME,而不仅仅是DB\u PATH。

以下是重写的数据库处理程序,以合并上述内容,但也将对数据库的检查更改为对文件的检查,以便不显示非错误的打开错误14(从资产文件复制数据库时)。

评论 //<<<< ???? 指示更改。

:-

public class VocabDatabase extends SQLiteOpenHelper {

    //The Android's default system path of your application database.
    //private static String DB_PATH = ""; //<<<< RMVD
    private static String DB_PATH_ALT; //<<<< ADDED
    private static String DB_NAME = "ztr.db";
    private SQLiteDatabase myDataBase;
    private final Context myContext;

    /**
     * Constructor
     * Takes and keeps a reference of the passed context in order to access to the application assets and resources.
     *
     * @param context
     */
    public VocabDatabase(Context context) {
        super(context, DB_NAME, null, 1);
        this.myContext = context;
        //this.DB_PATH = context.getApplicationInfo().dataDir + "/databases/"; //<<<< RMVD
        this.DB_PATH_ALT = context.getDatabasePath(DB_NAME).getPath(); //<<<< ADDED

    }

    /**
     * Creates a empty database on the system and rewrites it with your own database.
     */
    public void createDataBase() throws IOException {

        //boolean dbExist = checkDataBase();  //<<<< RMVD 
        boolean dbExist = checkDataBaseAlt(); //<<<< CHANGED
        if (dbExist) {
            //do nothing - database already exist
        } else {
            //By calling this method and empty database will be created into the default system path
            //of your application so we are gonna be able to overwrite that database with our database.
            this.getWritableDatabase();

            try {
                copyDataBase();
            } catch (IOException e) {
                throw new Error("Error copying database");
            }
        }
    }
    //<<<< ADDED Alternative method checks the file rather than database
    //<<<<       as such no open error 14 messages
    /**
     * Check if the database already exist to avoid re-copying the file each time you open the application.
     *
     * @return true if it exists, false if it doesn't
     */
    private boolean checkDataBaseAlt() {
        //File chkdb = new File(myContext.getDatabasePath(DB_NAME).getPath()); //<<<< RMVD
        File chkdb = new File(DB_PATH_ALT); //<<<< ADDED
        return chkdb.exists();
    }

    /**
     * Check if the database already exist to avoid re-copying the file each time you open the application.
     *
     * @return true if it exists, false if it doesn't
     */
    private boolean checkDataBase() {
        this.getReadableDatabase();
        SQLiteDatabase checkDB = null;
        try {
            //String myPath = DB_PATH; //<<<< RMVD so no open error 14 uses alt method
            checkDB = SQLiteDatabase.openDatabase(
                    DB_PATH_ALT, //<<<< CHANGED
                    null, 
                    SQLiteDatabase.OPEN_READWRITE
            ); 

        } catch (SQLiteException e) {
            e.printStackTrace();
        }
        if (checkDB != null) {
            checkDB.close();
        }
        return checkDB != null; //<<<< simplified
    }

    /**
     * Copies your database from your local assets-folder to the just created empty database in the
     * system folder, from where it can be accessed and handled.
     * This is done by transfering bytestream.
     */
    private void copyDataBase() throws IOException {

        //Open your local db as the input stream
        InputStream myInput = myContext.getAssets().open(DB_NAME); //<<<< CHANGED

        // Path to the just created empty db
        //String outFileName = DB_PATH + DB_NAME;

        //Open the empty db as the output stream
        OutputStream myOutput = new FileOutputStream(DB_PATH_ALT); //<<<< CHANGED

        //transfer bytes from the inputfile to the outputfile
        byte[] buffer = new byte[1024];
        int length = 0;
        while ((length = myInput.read(buffer)) > 0) {
            myOutput.write(buffer, 0, length);
        }
        //Close the streams
        myOutput.flush();
        myOutput.close();
        myInput.close();

    }

    public void openDataBase() throws SQLException {
        //Open the database
        //String myPath = DB_PATH; //<<<< RMVD
        myDataBase = SQLiteDatabase.openDatabase(
                DB_PATH_ALT, //<<<< CHANGED
                null, 
                SQLiteDatabase.OPEN_READWRITE
        );

    }

    @Override
    public synchronized void close() {
        if (myDataBase != null)
            myDataBase.close();
        super.close();
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        if (newVersion > oldVersion) {
            try {
                copyDataBase();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

// Add your public helper methods to access and get content from the database.
// You could return cursors by doing "return myDataBase.query(....)" so it'd be easy
// to you to create adapters for your views.

//add your public methods for insert, get, delete and update data in database.

    public Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy) {
        SQLiteDatabase db = this.getWritableDatabase();
        return db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy);
    }

    public long insert(String table, String nullColumnHack, ContentValues contentValues) {
        SQLiteDatabase db = this.getWritableDatabase();
        return db.insert(table, nullColumnHack, contentValues);
    }

    public Cursor rawQuery(String string, String[] selectionArguments) {
        SQLiteDatabase db = this.getWritableDatabase();
        return db.rawQuery(string, selectionArguments);
    }
}