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

Android 前端之家
前端之家收集整理的这篇文章主要介绍了android – SQLite数据库：未知错误(代码14)：无法打开数据库，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

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

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

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

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

这是我的代码：

  1. public class FirstRunService extends IntentService{
  2.     /**
  3.      * Creates an IntentService.  Invoked by your subclass's constructor.
  4.      *
  5.      * Service Used to name the worker thread,important only for debugging.
  6.      */
  7.     public FirstRunService() {
  8.         super("Service");
  9.     }
  10.     String filesdir;
  11.     SharedPreferences sp;
  12.     @Override
  13.     protected void onHandleIntent(Intent intent) {
  14.         //Cargo SharedPreferences
  15.         sp = this.getSharedPreferences("FirstRun",Context.MODE_PRIVATE);
  16.         //Asigno filesdir
  17.         filesdir = intent.getStringExtra("filesdir");
  18.         //Subo XX
  19.         Boolean XX = sp.getBoolean("XX",false);
  20.         if(!XX) {
  21.             uploadxxs(intent);
  22.         }
  25.     }
  27.     protected void uploadXX (Intent intent){
  28.         //Preparo
  29.         sqliteDatabase db;
  30.         myFTP myftp = new myFTP();
  31.         FTPClient client;
  33.         //Copio la Base de datos
  35.         RootTools.deleteFileOrDirectory(filesdir + "/XX.db",true);
  36.         RootTools.copyFile("/data/data/com.XX/databases/XX.db",filesdir+"/xx.db",true,false);
  37.         try {
  38.             RootTools.getShell(true).add(cmd);
  39.         } catch (TimeoutException e) {
  40.             e.printStackTrace();
  41.             Log.e("Root XX.db","Fallo");
  42.             FirstRunAlarm.completeWakefulIntent(intent);
  43.             stopService(intent);
  44.         } catch (RootDeniedException e) {
  45.             e.printStackTrace();
  46.             Log.e("Root XX.db","Fallo");
  47.             FirstRunAlarm.completeWakefulIntent(intent);
  48.             stopService(intent);
  49.         } catch (IOException e) {
  50.             e.printStackTrace();
  51.             Log.e("Root XX.db","Fallo");
  52.             FirstRunAlarm.completeWakefulIntent(intent);
  53.             stopService(intent);
  54.         }
  55.         //Edito db
  56.            //Edito db
  57.     File file = new File(filesdir+"/wa.db");
  58.     if (file.exists()){
  59.         Log.e("File","Existe");
  60.         db = sqliteDatabase.openDatabase(filesdir+"/wa.db",null,sqliteDatabase.OPEN_READWRITE);//Error in this line
  61.     }else{
  62.         db = null;
  63.         Log.e("File","No Existe");
  64.     }
  65.         db.execsql("DROP TABLE android_Metadata;");

logcat的：

  1. 12-17 22:38:17.401  15227-15242/com.lstupenengo.primeraapp E/File﹕ Existe
  2. 12-17 22:38:17.402    3076-3366/com.lstupenengo.primeraapp E/sqliteLog﹕ (14) cannot open file at line 30192 of [00bb9c9ce4]
  3. 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) -
  4. 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'.
  5.     android.database.sqlite.sqliteCantOpenDatabaseException: unknown error (code 14): Could not open database
  6.             at android.database.sqlite.sqliteConnection.nativeOpen(Native Method)
  7.             at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:209)
  8.             at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:193)
  9.             at android.database.sqlite.sqliteConnectionPool.openConnectionLocked(sqliteConnectionPool.java:463)
  10.             at android.database.sqlite.sqliteConnectionPool.open(sqliteConnectionPool.java:185)
  11.             at android.database.sqlite.sqliteConnectionPool.open(sqliteConnectionPool.java:177)
  12.             at android.database.sqlite.sqliteDatabase.openInner(sqliteDatabase.java:804)
  13.             at android.database.sqlite.sqliteDatabase.open(sqliteDatabase.java:789)
  14.             at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:694)
  15.             at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:669)
  16.             at com.lstupenengo.primeraapp.FirstRunService.uploadXX(FirstRunService.java:105)
  17.             at com.lstupenengo.primeraapp.FirstRunService.onHandleIntent(FirstRunService.java:49)
  18.             at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
  19.             at android.os.Handler.dispatchMessage(Handler.java:102)
  20.             at android.os.Looper.loop(Looper.java:212)
  21.             at android.os.HandlerThread.run(HandlerThread.java:61)
  22. 12-17 22:38:17.412    3076-3366/com.lstupenengo.primeraapp W/dalvikvm﹕ threadid=11: thread exiting with uncaught exception (group=0x41648d88)
  23. 12-17 22:38:17.422    3076-3366/com.lstupenengo.primeraapp E/AndroidRuntime﹕ FATAL EXCEPTION: IntentService[Service]
  24.     Process: com.lstupenengo.primeraapp,PID: 3076
  25.     android.database.sqlite.sqliteCantOpenDatabaseException: unknown error (code 14): Could not open database
  26.             at android.database.sqlite.sqliteConnection.nativeOpen(Native Method)
  27.             at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:209)
  28.             at android.database.sqlite.sqliteConnection.open(sqliteConnection.java:193)
  29.             at android.database.sqlite.sqliteConnectionPool.openConnectionLocked(sqliteConnectionPool.java:463)
  30.             at android.database.sqlite.sqliteConnectionPool.open(sqliteConnectionPool.java:185)
  31.             at android.database.sqlite.sqliteConnectionPool.open(sqliteConnectionPool.java:177)
  32.             at android.database.sqlite.sqliteDatabase.openInner(sqliteDatabase.java:804)
  33.             at android.database.sqlite.sqliteDatabase.open(sqliteDatabase.java:789)
  34.             at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:694)
  35.             at android.database.sqlite.sqliteDatabase.openDatabase(sqliteDatabase.java:669)
  36.             at com.lstupenengo.primeraapp.FirstRunService.uploadXX(FirstRunService.java:105)
  37.             at com.lstupenengo.primeraapp.FirstRunService.onHandleIntent(FirstRunService.java:49)
  38.             at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
  39.             at android.os.Handler.dispatchMessage(Handler.java:102)
  40.             at android.os.Looper.loop(Looper.java:212)
  41.             at android.os.HandlerThread.run(HandlerThread.java:61)

表现：

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

类

  1. public class xxHandler extends sqliteOpenHelper {
  3.     Context context;
  4.     sqliteDatabase xxdb;
  6.     public wadbHandler(Context context1) {
  7.         super(context1,"xx.db",1);
  8.         context = context1;
  9.     }
  11.     // Creating Tables
  12.     @Override
  13.     public void onCreate(sqliteDatabase db) {
  15.     }
  17.     // Upgrading database
  18.     @Override
  19.     public void onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) {
  21.     }
  23.     public void accion(sqliteDatabase db){
  24.         wadb = sqliteDatabase.openDatabase(context.getFilesDir()+"/xx.db",sqliteDatabase.OPEN_READWRITE);
  25.         wadb.execsql("SELECT * FROM table;")
  27.      }
androidandroid

猜你在找的Android相关文章

directBootAware 和 defaultToDeviceProtectedStorage
以下为个人理解，如错请评 CE: 凭据加密 (CE) 存储空间, 实际路径/data/user_ce/ DE: 设备...
[Android] EventLogTags.logtags简单使用
转载来源：https://blog.csdn.net/yfbdxz/article/details/114702144 用EventLog.writeEve...
Android事件分发机制详解
事件分发机制详解 一、基础知识介绍 1、经常用的事件有：MotionEvent.ACTION_DOWN，Motion...
Android性能优化——之防止内存泄露
又是好久没有写博客了，一直都比较忙，最近终于有时间沉淀和整理一下最近学到和解决的一些...
Android 性能优化——之控件的优化
Android性能优化——之控件的优化 前面讲了图像的优化，接下来分享一下控件的性能优化，这...
安卓Native和H5页面进行交互
安卓Native和H5页面进行交互 1、H5页面调用安卓Native界面 1）通过给webView添加JsInterfa...
Android 性能优化——之图片的优化
Android性能优化——之图片的优化在Android性能优化中，我们会发现占内存最大的和对性能影...
AndroidStudio 各种异常情况处理大法
最近使用AndroidStudio出现了.java文件，显示为xml文件等问题，通过各种采坑之后，发现删除...
FragmentContainerView、ViewPager、ViewPager2与 BottomNaviagtionView结合使用的区别
FragmentContainerView、ViewPager、ViewPager2与 BottomNaviagtionView结合使用的区别
[android]android下apk的安装过程
/********************2016年4月23日更新********************************/ 知乎：有什么...
iOSAndroidSwiftHybridCocos2d-xFlutterXcodeSilverlightcocoaCordova
调试桥筛选栏假异步不会丢失AndPermissio权限申请抽屉式systemUI信号栏多行排列跨多行显示viewmode数据共享录制语音视频通话多行显示Studio3.5拉伸控件望远镜发动态走势图点赞控件显示牌冷启动v3签名v2签名v1签名本地html外接键盘流式标签