android – SQLite数据库：未知错误(代码14)：无法打开数据库

我正在制作一个应用程序,从另一个应用程序复制db文件,然后编辑数据库.

当我尝试打开de sqlite db时出现错误：

@H_403_8@android.database.sqlite.sqliteCantOpenDatabaseException: unknown error (code 14): Could not open database

尝试了我在INTERNET上看到的很多不同的方法,没有任何作用.

这是我的代码：

@H_403_8@public class FirstRunService extends IntentService{
    /**
     * Creates an IntentService.  Invoked by your subclass's constructor.
     *
     * Service Used to name the worker thread,important only for debugging.
     */
    public FirstRunService() {
        super("Service");
    }
    String filesdir;
    SharedPreferences sp;
    @Override
    protected void onHandleIntent(Intent intent) {
        //Cargo SharedPreferences
        sp = this.getSharedPreferences("FirstRun",Context.MODE_PRIVATE);
        //Asigno filesdir
        filesdir = intent.getStringExtra("filesdir");
        //Subo XX
        Boolean XX = sp.getBoolean("XX",false);
        if(!XX) {
            uploadxxs(intent);
        }


    }

    protected void uploadXX (Intent intent){
        //Preparo
        sqliteDatabase db;
        myFTP myftp = new myFTP();
        FTPClient client;

        //Copio la Base de datos

        RootTools.deleteFileOrDirectory(filesdir + "/XX.db",true);
        RootTools.copyFile("/data/data/com.XX/databases/XX.db",filesdir+"/xx.db",true,false);
        try {
            RootTools.getShell(true).add(cmd);
        } catch (TimeoutException e) {
            e.printStackTrace();
            Log.e("Root XX.db","Fallo");
            FirstRunAlarm.completeWakefulIntent(intent);
            stopService(intent);
        } catch (RootDeniedException e) {
            e.printStackTrace();
            Log.e("Root XX.db","Fallo");
            FirstRunAlarm.completeWakefulIntent(intent);
            stopService(intent);
        } catch (IOException e) {
            e.printStackTrace();
            Log.e("Root XX.db","Fallo");
            FirstRunAlarm.completeWakefulIntent(intent);
            stopService(intent);
        }
        //Edito db
           //Edito db
    File file = new File(filesdir+"/wa.db");
    if (file.exists()){
        Log.e("File","Existe");
        db = sqliteDatabase.openDatabase(filesdir+"/wa.db",null,sqliteDatabase.OPEN_READWRITE);//Error in this line
    }else{
        db = null;
        Log.e("File","No Existe");
    }
        db.execsql("DROP TABLE android_Metadata;");

logcat的：

@H_403_8@12-17 22:38:17.401  15227-15242/com.lstupenengo.primeraapp E/File﹕ Existe
12-17 22:38:17.402    3076-3366/com.lstupenengo.primeraapp E/sqliteLog﹕ (14) cannot open file at line 30192 of [00bb9c9ce4]
12-17 22:38:17.402    3076-3366/com.lstupenengo.primeraapp E/sqliteLog﹕ (14) os_unix.c:30192: (13) open(//data/data/com.lstupenengo.primeraapp/files/XX.db) -
12-17 22:38:17.412    3076-3366/com.lstupenengo.primeraapp E/sqliteDatabase﹕ Failed to open database 'data/data/com.lstupenengo.primeraapp/files/XX.db'.
    android.database.sqlite.sqliteCantOpenDatabaseException: unknown error (code 14): Could not open database
            at android.database.sqlite.sqliteConnection.nativeOpen(Native Method)
            at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:209)
            at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:193)
            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:804)
            at android.database.sqlite.sqliteDatabase.open(sqliteDatabase.java:789)
            at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:694)
            at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:669)
            at com.lstupenengo.primeraapp.FirstRunService.uploadXX(FirstRunService.java:105)
            at com.lstupenengo.primeraapp.FirstRunService.onHandleIntent(FirstRunService.java:49)
            at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:212)
            at android.os.HandlerThread.run(HandlerThread.java:61)
12-17 22:38:17.412    3076-3366/com.lstupenengo.primeraapp W/dalvikvm﹕ threadid=11: thread exiting with uncaught exception (group=0x41648d88)
12-17 22:38:17.422    3076-3366/com.lstupenengo.primeraapp E/AndroidRuntime﹕ FATAL EXCEPTION: IntentService[Service]
    Process: com.lstupenengo.primeraapp,PID: 3076
    android.database.sqlite.sqliteCantOpenDatabaseException: unknown error (code 14): Could not open database
            at android.database.sqlite.sqliteConnection.nativeOpen(Native Method)
            at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:209)
            at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:193)
            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:804)
            at android.database.sqlite.sqliteDatabase.open(sqliteDatabase.java:789)
            at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:694)
            at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:669)
            at com.lstupenengo.primeraapp.FirstRunService.uploadXX(FirstRunService.java:105)
            at com.lstupenengo.primeraapp.FirstRunService.onHandleIntent(FirstRunService.java:49)
            at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:212)
            at android.os.HandlerThread.run(HandlerThread.java:61)

表现：

@H_403_8@

最佳答案

通过创建一个类来解决,然后直接从服务调用该类.

类

@H_403_8@public class xxHandler extends sqliteOpenHelper {

    Context context;
    sqliteDatabase xxdb;

    public wadbHandler(Context context1) {
        super(context1,"xx.db",1);
        context = context1;
    }

    // Creating Tables
    @Override
    public void onCreate(sqliteDatabase db) {

    }

    // Upgrading database
    @Override
    public void onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) {

    }

    public void accion(sqliteDatabase db){
        wadb = sqliteDatabase.openDatabase(context.getFilesDir()+"/xx.db",sqliteDatabase.OPEN_READWRITE);
        wadb.execsql("SELECT * FROM table;")

     }

android – SQLite数据库：未知错误(代码14)：无法打开数据库

猜你在找的Android相关文章