Android target中的Haxe-SQLLite崩溃

Question

我正在做的事情：

>

使用数据库浏览器创建数据库并将其保存到资产/data/db/data.db

然后，当应用程序启动时，我将其复制到Lime.System.System.ApplicationStorageDirectory

<android target-sdk-version="26" install-location="preferExternal" if="android" />
<android permission="android.permission.WRITE_EXTERNAL_STORAGE"/>
<android permission="android.permission.WRITE_INTERNAL_STORAGE"/>

<haxelib name="openfl" />
<haxelib name="hxcpp" />

<assets path="assets/data/db" rename="db" />

package;
import haxe.io.Bytes;
import lime.Assets;
import openfl.system.System;
import sys.FileSystem;
import sys.db.Connection;
import sys.db.Sqlite;
import sys.io.File;

#if android
    // Make SQLite work on android by statically compiling the library
    import hxcpp.StaticSqlite;
#end

/**
 * ...
 * @author Sim
 */
class DBManager
{
    private var CLONE:String = "db/asset_database.db";
    private var NEW:String = "new_db.db";

    private var _conn:Connection = null;

    public function new()
    {
    }

    public function openDatabase():Void
    {
        trace("CREATING FILE");

        trace("targetPath: " +lime.system.System.applicationStorageDirectory);
        //trace("targetPath: " +lime.system.System.applicationDirectory); //Crashing the app
        trace("targetPath: " +lime.system.System.documentsDirectory);
        trace("targetPath: " +lime.system.System.desktopDirectory);

        var targetPath: String = lime.system.System.applicationStorageDirectory+ NEW;
        trace("targetPath " + targetPath);
        trace("FileSystem.exists(targetPath) " + FileSystem.exists(targetPath));

        //Debugging
        /*var bytes:Bytes = Assets.getBytes(CLONE);
        trace("bytes are here "+bytes);
        var content:String = bytes.toString();
        trace("content "+content);
        File.saveContent(targetPath, content);
        trace("Saved");*/

        //uncomment when done with errors
        /*if (FileSystem.exists(targetPath) == false)
        {
            var bytes:Bytes = Assets.getBytes(CLONE);
            var content:String = bytes.toString();
            File.saveContent(targetPath, content);
        }*/

        var bytes:Bytes = Assets.getBytes(CLONE);
        var content:String = bytes.toString();
        File.saveContent(targetPath, content);

        trace("Saved");

        try 
        {
            _conn = Sqlite.open(targetPath+NEW);
        }
        catch (e:Dynamic)
        {
            trace("Connection failed with error: "+e);
        }

        if (_conn != null)
        {
            trace("Connected to database " +_conn.dbName );

            //not getting any database name trying to query

            // and KaBoom app gone :D XD
            var result = _conn.request("SELECT * FROM TEST");
            trace("Query Result "+result.results());

            //if i comment then it will go and close the connection too
            //without breaking anything O_O             

            _conn.close();

        }
    }

}

Answer 1

我打了个盹，在梦中找到了答案

问题就在这里

_conn = Sqlite.open(targetPath+NEW);

修复：

_conn = Sqlite.open(targetPath);

var targetPath: String = lime.system.System.applicationStorageDirectory+ NEW;