无法打开数据库文件（代码14）：在编译PRAGMA journal_mode时。

Question

这是我在DatabaseHelper类中所做的事情。

public DatabaseHelper(Context context)
    {
        super(context, DATABASENAME, null, VERSION);
        context.openOrCreateDatabase(DATABASENAME, context.MODE_PRIVATE, null);

    }


    @Override
    public void onCreate(SQLiteDatabase db) {

        String queryProductsAllData = "CREATE TABLE `"+TABLE_PRODUCTS+"` (\n" +
                        "\t`"+COLUMN_BRANDID                +"`\tINTEGER,\n" +
                        "\t`"+COLUMN_PRODUCTID              +"`\tINTEGER,\n" +
                        "\t`"+COLUMN_PRODUCTCODE            +"`\tINTEGER,\n" +
                        "\t`"+COLUMN_PIECESINCASE           +"`\tINTEGER,\n" +
                        "\t`"+COLUMN_PRODUCT_STOCK_UNITS    +"`\tINTEGER DEFAULT 0,\n" +
                        "\t`"+COLUMN_PRODUCTADDEDBY         +"`\tINTEGER,\n" +
                        "\t`"+COLUMN_BRANDCODE              +"`\tTEXT,\n" +
                        "\t`"+COLUMN_BRANDNAME              +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PRODUCTNAME            +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PRODUCTSHORTNAME       +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PIECENETVOLUME         +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PRICEPOINT             +"`\tTEXT,\n" +
                        "\t`"+COLUMN_TRADEPRICEPERCASE      +"`\tTEXT,\n" +
                        "\t`"+COLUMN_TRADEPRICEPERPIECE     +"`\tTEXT,\n" +
                        "\t`"+COLUMN_RETAILPRICEPERPIECE    +"`\tTEXT,\n" +
                        "\t`"+COLUMN_SERVICECHARGEPERPIECE  +"`\tTEXT,\n" +
                        "\t`"+COLUMN_SPDSHOPPERPRICEPERPIECE+"`\tTEXT,\n" +
                        "\t`"+COLUMN_JTAXPERCASE            +"`\tTEXT,\n" +
                        "\t`"+COLUMN_SPDPRICEPERCASE        +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PRODUCTADDEDON         +"`\tTEXT,\n" +
                        "\t`"+COLUMN_PRODUCTSTATUS          +"`\tINTEGER\n" +
                        ");";
    db.execSQL(queryProductsAllData);

    }

 @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
    {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_PRODUCTS);
}
`

这是我获取到的日志。

 12-28 10:27:52.509    2672-2672/? E/SQLiteLog﹕ (14) cannot open file at line 31278 of [2ef4f3a5b1]
12-28 10:27:52.509    2672-2672/? E/SQLiteLog﹕ (14) os_unix.c:31278: (24) open(/data/user/0/com.vergesystems.heartbeat/databases/Heart_Beat-journal) -
12-28 10:27:52.510    2672-2672/? E/SQLiteLog﹕ (14) cannot open file at line 31278 of [2ef4f3a5b1]
12-28 10:27:52.510    2672-2672/? E/SQLiteLog﹕ (14) os_unix.c:31278: (24) open(/data/user/0/com.vergesystems.heartbeat/databases/Heart_Beat-journal) -
12-28 10:27:52.510    2672-2672/? E/SQLiteLog﹕ (14) unable to open database file
12-28 10:27:52.512    2672-2672/? E/SQLiteDatabase﹕ Failed to open database '/data/user/0/com.vergesystems.heartbeat/databases/Heart_Beat'.
    android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14): , while compiling: PRAGMA journal_mode
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
            at android.database.sqlite.SQLiteConnection.executeForString(SQLiteConnection.java:632)
            at android.database.sqlite.SQLiteConnection.setJournalMode(SQLiteConnection.java:318)
            at android.database.sqlite.SQLiteConnection.setWalModeFromConfiguration(SQLiteConnection.java:292)
            at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:213)
            at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:191)
            at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
            at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
            at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
            at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:806)
            at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:791)
            at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
            at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:571)
            at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:269)
            at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
            at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
            at com.vergesystems.databases.ProductsTableHelper.<init>(ProductsTableHelper.java:29)

- Saraz

---

你使用了 <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/> 吗？ - IntelliJ Amiya

是的，我正在使用这个权限。 - Saraz

问题在这里 DATABASENAME。 - IntelliJ Amiya

DATABASENAME的值是多少？ - Kyle Emmanuel

我尝试更改数据库名称，但问题仍然存在。我尝试从ada shell命令中删除数据库，但仍然没有成功:( - Saraz

公共静态最终字符串 数据库名称 = "Heart_Beat"; - Saraz

Answer 1

我找到了代码的问题所在。我在其他helper类的构造函数中初始化TableHelper类，这导致再次调用DatabaseHelper的onCreate函数，从而导致数据库锁定。

我将TableHelper初始化的部分从其他TableHelper类的构造函数中移除，并放到需要的方法中。

谢谢。

- Saraz

Answer 2

移除

context.openOrCreateDatabase(DATABASENAME, context.MODE_PRIVATE, null);

你正在使用 SQLiteOpenHelper，它会为你处理数据库文件管理。

- laalto