android database sqlite SQLiteCantOpenDatabaseException unknown error code 14 Could not open database

Question

I have read various on site about this issue but I am not able to figure this out  I am using pre-build database for this app   I am using jellybean for this app   AndroidManifest xml   lt  xml version  1 0  encoding  utf-8   gt       lt manifest xmlns android  http   schemas android com apk res android          package  com example quotes          android versionCode  1          android versionName  1 0   gt            lt uses-sdk             android minSdkVersion  8              android targetSdkVersion  17    gt            lt application             android allowBackup  true              android icon   drawable ic launcher              android label   string app name              android theme   style AppTheme   gt               lt activity                 android name  com example quotes MainActivity                  android label   string app name   gt                   lt intent-filter gt                       lt action android name  android intent action MAIN    gt                        lt category android name  android intent category LAUNCHER    gt                   lt  intent-filter gt               lt  activity gt           lt  application gt        lt  manifest gt    Logcat Output  according to logcat it s caused by SQLiteCantOpenDatabaseException  06-10 23 07 01 831  E Trace 4419   error opening trace file  No such file or directory  2  06-10 23 07 03 611  E SQLiteLog 4419    14  cannot open file at line 30176 of  00bb9c9ce4  06-10 23 07 03 621  E SQLiteLog 4419    14  os unix c 30176   2  open  data data com example quotes databasesQuotesdb  -  06-10 23 07 03 641  E SQLiteDatabase 4419   Failed to open database   data data com example quotes databasesQuotesdb   06-10 23 07 03 641  E SQLiteDatabase 4419   android database sqlite SQLiteCantOpenDatabaseException  unknown error  code 14   Could not open database 06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection nativeOpen Native Method  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 209  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 193  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool openConnectionLocked SQLiteConnectionPool java 463  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 185  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 177  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openInner SQLiteDatabase java 804  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase open SQLiteDatabase java 789  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 694  06-10 23 07 03 641  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 669  06-10 23 07 03 641  E SQLiteDatabase 4419       at com example quotes DataBaseHelper checkDataBase DataBaseHelper java 94  06-10 23 07 03 641  E SQLiteDatabase 4419       at com example quotes DataBaseHelper createDataBase DataBaseHelper java 58  06-10 23 07 03 641  E SQLiteDatabase 4419       at com example quotes MainActivity onCreate MainActivity java 34  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app Activity performCreate Activity java 5104  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app Instrumentation callActivityOnCreate Instrumentation java 1080  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app ActivityThread performLaunchActivity ActivityThread java 2144  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app ActivityThread handleLaunchActivity ActivityThread java 2230  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app ActivityThread access 600 ActivityThread java 141  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app ActivityThread H handleMessage ActivityThread java 1234  06-10 23 07 03 641  E SQLiteDatabase 4419       at android os Handler dispatchMessage Handler java 99  06-10 23 07 03 641  E SQLiteDatabase 4419       at android os Looper loop Looper java 137  06-10 23 07 03 641  E SQLiteDatabase 4419       at android app ActivityThread main ActivityThread java 5041  06-10 23 07 03 641  E SQLiteDatabase 4419       at java lang reflect Method invokeNative Native Method  06-10 23 07 03 641  E SQLiteDatabase 4419       at java lang reflect Method invoke Method java 511  06-10 23 07 03 641  E SQLiteDatabase 4419       at com android internal os ZygoteInit MethodAndArgsCaller run ZygoteInit java 793  06-10 23 07 03 641  E SQLiteDatabase 4419       at com android internal os ZygoteInit main ZygoteInit java 560  06-10 23 07 03 641  E SQLiteDatabase 4419       at dalvik system NativeStart main Native Method  06-10 23 07 03 731  E SQLiteLog 4419    14  cannot open file at line 30176 of  00bb9c9ce4  06-10 23 07 03 731  E SQLiteLog 4419    14  os unix c 30176   2  open  data data com example quotes databasesQuotesdb  -  06-10 23 07 03 781  E SQLiteDatabase 4419   Failed to open database   data data com example quotes databasesQuotesdb   06-10 23 07 03 781  E SQLiteDatabase 4419   android database sqlite SQLiteCantOpenDatabaseException  unknown error  code 14   Could not open database 06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection nativeOpen Native Method  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 209  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 193  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool openConnectionLocked SQLiteConnectionPool java 463  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 185  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 177  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openInner SQLiteDatabase java 804  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase open SQLiteDatabase java 789  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 694  06-10 23 07 03 781  E SQLiteDatabase 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 669  06-10 23 07 03 781  E SQLiteDatabase 4419       at com example quotes DataBaseHelper openDataBase DataBaseHelper java 145  06-10 23 07 03 781  E SQLiteDatabase 4419       at com example quotes MainActivity onCreate MainActivity java 44  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app Activity performCreate Activity java 5104  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app Instrumentation callActivityOnCreate Instrumentation java 1080  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app ActivityThread performLaunchActivity ActivityThread java 2144  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app ActivityThread handleLaunchActivity ActivityThread java 2230  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app ActivityThread access 600 ActivityThread java 141  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app ActivityThread H handleMessage ActivityThread java 1234  06-10 23 07 03 781  E SQLiteDatabase 4419       at android os Handler dispatchMessage Handler java 99  06-10 23 07 03 781  E SQLiteDatabase 4419       at android os Looper loop Looper java 137  06-10 23 07 03 781  E SQLiteDatabase 4419       at android app ActivityThread main ActivityThread java 5041  06-10 23 07 03 781  E SQLiteDatabase 4419       at java lang reflect Method invokeNative Native Method  06-10 23 07 03 781  E SQLiteDatabase 4419       at java lang reflect Method invoke Method java 511  06-10 23 07 03 781  E SQLiteDatabase 4419       at com android internal os ZygoteInit MethodAndArgsCaller run ZygoteInit java 793  06-10 23 07 03 781  E SQLiteDatabase 4419       at com android internal os ZygoteInit main ZygoteInit java 560  06-10 23 07 03 781  E SQLiteDatabase 4419       at dalvik system NativeStart main Native Method  06-10 23 07 03 791  D AndroidRuntime 4419   Shutting down VM 06-10 23 07 03 791  W dalvikvm 4419   threadid 1  thread exiting with uncaught exception  group 0x40a71930  06-10 23 07 03 831  E AndroidRuntime 4419   FATAL EXCEPTION  main 06-10 23 07 03 831  E AndroidRuntime 4419   java lang RuntimeException  Unable to start activity ComponentInfo com example quotes com example quotes MainActivity   android database sqlite SQLiteCantOpenDatabaseException  unknown error  code 14   Could not open database 06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread performLaunchActivity ActivityThread java 2180  06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread handleLaunchActivity ActivityThread java 2230  06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread access 600 ActivityThread java 141  06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread H handleMessage ActivityThread java 1234  06-10 23 07 03 831  E AndroidRuntime 4419       at android os Handler dispatchMessage Handler java 99  06-10 23 07 03 831  E AndroidRuntime 4419       at android os Looper loop Looper java 137  06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread main ActivityThread java 5041  06-10 23 07 03 831  E AndroidRuntime 4419       at java lang reflect Method invokeNative Native Method  06-10 23 07 03 831  E AndroidRuntime 4419       at java lang reflect Method invoke Method java 511  06-10 23 07 03 831  E AndroidRuntime 4419       at com android internal os ZygoteInit MethodAndArgsCaller run ZygoteInit java 793  06-10 23 07 03 831  E AndroidRuntime 4419       at com android internal os ZygoteInit main ZygoteInit java 560  06-10 23 07 03 831  E AndroidRuntime 4419       at dalvik system NativeStart main Native Method  06-10 23 07 03 831  E AndroidRuntime 4419   Caused by  android database sqlite SQLiteCantOpenDatabaseException  unknown error  code 14   Could not open database 06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnection nativeOpen Native Method  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 209  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnection open SQLiteConnection java 193  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnectionPool openConnectionLocked SQLiteConnectionPool java 463  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 185  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteConnectionPool open SQLiteConnectionPool java 177  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteDatabase openInner SQLiteDatabase java 804  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteDatabase open SQLiteDatabase java 789  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 694  06-10 23 07 03 831  E AndroidRuntime 4419       at android database sqlite SQLiteDatabase openDatabase SQLiteDatabase java 669  06-10 23 07 03 831  E AndroidRuntime 4419       at com example quotes DataBaseHelper openDataBase DataBaseHelper java 145  06-10 23 07 03 831  E AndroidRuntime 4419       at com example quotes MainActivity onCreate MainActivity java 44  06-10 23 07 03 831  E AndroidRuntime 4419       at android app Activity performCreate Activity java 5104  06-10 23 07 03 831  E AndroidRuntime 4419       at android app Instrumentation callActivityOnCreate Instrumentation java 1080  06-10 23 07 03 831  E AndroidRuntime 4419       at android app ActivityThread performLaunchActivity ActivityThread java 2144  06-10 23 07 03 831  E AndroidRuntime 4419           11 more 06-10 23 07 04 083  D dalvikvm 4419   GC CONCURRENT freed 203K  11  free 2676K 3000K  paused 25ms 18ms  total 306ms 06-10 23 07 07 811  I Process 4419   Sending signal  PID  4419 SIG  9   DataBaseHelper java  public class DataBaseHelper extends SQLiteOpenHelper         The Android s default system path of your application database      private static String DB PATH     data data com example quotes databases        private static String DB NAME    Quotesdb           Table Names of Data Base      static final String TABLE Name    Quotes           Contacts Table Columns names       private static final String  Id     Id         private static final String quotes    quotes         private static final String author    author        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 DataBaseHelper Context context            super context  DB NAME  null  1           this myContext   context                        Creates a empty database on the system and rewrites it with your own database                public void createDataBase   throws IOException           boolean dbExist   checkDataBase            SQLiteDatabase db Read   null           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              db Read   this getReadableDatabase                 db Read close                 try                   copyDataBase                  catch  IOException e                      throw new Error  Error copying database                    e toString                                                  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             SQLiteDatabase checkDB   null           try              String myPath   DB PATH   DB NAME              checkDB   SQLiteDatabase openDatabase myPath  null  SQLiteDatabase OPEN READONLY            catch SQLiteException e                 database does t exist yet                     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          while   length   myInput read buffer   gt 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   DB NAME          myDataBase   SQLiteDatabase openDatabase myPath  null  SQLiteDatabase OPEN READONLY                Override     public synchronized void close             if myDataBase    null              myDataBase close             super close                Override     public void onCreate SQLiteDatabase db               TODO Auto-generated method stub             Override     public void onUpgrade SQLiteDatabase db  int oldVersion  int newVersion               TODO Auto-generated method stub                 Getting single contact     public List lt Quotes gt  getQuote int id            ArrayList lt Quotes gt             getReadableDatabase             Cursor cursor   db query TABLE Name  new String      Id                  qotes author     Id         new String     String valueOf id                     null  null  null  null              String query    SELECT  Id  qotes  author From   TABLE Name            String query    SELECT   From Quotes              Cursor cursor   db rawQuery query  null            if  cursor    null              cursor moveToFirst            Quotes quotes   new Quotes Integer parseInt cursor getString 0            cursor getString 1  cursor getString 2            QuoteList add quotes           return QuoteList

User · Answer

Replace the checkDataBase   code with the code below   File dbFile   myContext getDatabasePath DB NAME   return dbFile exists

User · Answer

The DB PATH was pointing to different database  Change it in database helper class  and my code working      private static String DB PATH     data data com example abc

User · Answer

I don t think this is your problem  but it still looks pretty bad to me   You have a duplicate layer of com examples quote in your project   Your Activity section in your AndroidManifest xml should look more like this            lt activity             android name   MainActivity              android label   string app name   gt               lt intent-filter gt                   lt action android name  android intent action MAIN    gt                    lt category android name  android intent category LAUNCHER    gt               lt  intent-filter gt           lt  activity gt    You may even have your classes under src com example quotes com example quotes instead of just in com example quotes   I m not sure if this is causing your problem  But it looks a bit messed up   All your other stuff looks pretty standard to me

User · Answer

I lately came up with this error  But it was even more odd  I was working on Android N and everything was going smoothly OK  until I test it on JellyBeans and Lollipop  In which I kept on getting the same DB error      android database sqlite SQLiteCantOpenDatabaseException  unknown error    code 14   Could not open database 06-10 23 07 03 641    E SQLiteDatabase 4419     I had the right permissions in my manifest  including    lt uses-permission android name  android permission WRITE EXTERNAL STORAGE    gt    The problem was this line in my DataBaseHelper java   private static String DB PATH     data data com example quotes databases     which needed to be loaded from the context this way   String DB PATH   getContext   getApplicationInfo   dataDir   databases      Now is working properly form SDK 17

User · Answer

Clearing application data helped me in this  It may help you

User · Answer

I think it s because your DB Path finishes without a      When you concatenate the path with the database  the variable myPath has the following string    data data com example quotes databasesQuotesdb    I propose these changes   private static String DB PATH     data data com example quotes databases    private static String DB NAME    Quotesdb db     And another thing  you should open the database in the Main activity  and implement the onPause   and onResume   methods with database close   and database open   respectively  This is my example for the Main Activity  used with Cordova  web design and all the stuff  P    package home shell accessApp   import android os Bundle  import android util Log   import org apache cordova     public class AccessApp extends CordovaActivity            private SellitDAO db    This is the class name for my SQLiteOpenHelper       Override     public void onCreate Bundle savedInstanceState            db   new SellitDAO this           db open             super onCreate savedInstanceState           super init               Set by  lt content src  index html    gt  in config xml         super loadUrl Config getStartUrl               super loadUrl  file    android asset www index html               Override     public void onPause             super onPause            db close                Override     public void onResume             super onResume            db open              Good Luck

User · Answer

In runtime problems like these firstly open logcat if you are using android studio  try to analyse trace tree  go to the beginning from where exception started to rise  since that is usually the source of the problem  Now check for two things    Check in device file explorer on the bottom right  there exist a database created by you  mostly you find it in DATA -  DATA -  com example hpc demo your pakage name  -  DATABASE -  demo db Check that in your helper class you have added required     for example like below DB location    data data     mcontext getPackageName       database

User · Answer

You may face this issue if you are running your app on Android s Marshmallow or later version  API level 23 or greater   because of the new Real-time Permissions model introduced in this      Beginning in Android 6 0  API level 23   users grant permissions to apps while the app is running  not when they install the app  This approach streamlines the app install process  since the user does not need to grant permissions when they install or update the app    For getting permissions at runtime  you will have to request the user  You can do that in following way   First request for permissions   String   permissions    Manifest permission WRITE EXTERNAL STORAGE           requestPermissions permissions  WRITE REQUEST CODE     And then you can check the results in    Override public void onRequestPermissionsResult int requestCode  String permissions    int   grantResults        switch  requestCode           case WRITE REQUEST CODE           if grantResults 0     PackageManager PERMISSION GRANTED                Permission granted               Continue with writing files                      else               Permission denied                     break            Here is good learning source requesting-runtime-permissions-in-android-marshmallow

User · Answer

Add this permission to your project s AndroidManifest xml file  in the manifest tag  which should be the top level tag     lt uses-permission android name  android permission WRITE EXTERNAL STORAGE    gt

User · Answer

This can be caused by bad permissions or SELinux  Ensure the permissions  and owner group are correctly set  Then run this   restorecon  data data your app folder databases your db   restorecon restores file default SELinux security context

User · Answer

Android s default system path of your application database is   data data YOUR PACKAGE databases YOUR DB NAME  Your logcat clearly says Failed to open database   data data com example quotes databasesQuotesdb   Which means there is no file present on the given path or You have given the wrong path for the data file  As I can see there should be     after databases folder   Your DB PATH variable should end with a       private static String DB PATH     data data com example quotes databases     Your correct path will be now   data data com example quotes databases Quotesdb

User · Answer

you must use this way for path   DB PATH   context getDatabasePath DB NAME  getPath

User · Answer

android database sqlite SQLiteCantOpenDatabaseException  unknown error  code 14   Could not open database   If you are getting this after replacing your database files using the Device File Explorer  sometimes this happens due to permissions and SELinux security contexts   The Device File Explorer  as of AS3 6 3  will upload them with root permissions rwxrwxrwx set for all  777    Look around in your app folders for the user id  used for your app   Execute the following commands in terminal      adb devices    emulator-5554    adb root    adb -s emulator-5554 shell    cd  data data com yourorg yourapp    ls -l   You ll get a listing like   drwxrwx--x 2 u0 a85 u0 a85 4096 2020-04-23 16 09 cache drwxrwx--x 2 u0 a85 u0 a85 4096 2020-04-23 16 09 code cache drwxrwx--x 2 u0 a85 u0 a85 4096 2020-04-23 16 09 databases drwxrwx--x 2 u0 a85 u0 a85 4096 2020-04-23 16 09 shared prefs   u0 a85  or whatever it might be  will be the app owner and group id  Delete your databases on the device  drop in your replacement database files using Device File Explorer  and in terminal  execute the following  keeping in mind the owner id    cd databases chown u0 a85   db  chgrp u0 a85   db  chmod 600   db  restorecon   db   This changes the database files to their appropriate owner group id  RW permissions  and resets the SELinux security contexts for those files   Although I have had success replacing database files NOT having to do this  this problem seems to happen randomly enough that doing this works

User · Answer

My gremlin for this problem was bad directory permissions    Good permissions   drwxr-x--x u0 a20   u0 a20            2013-11-13 20 45 com google earth drwxr-x--x u0 a63   u0 a63            2013-11-13 20 46 com nuance xt9 input drwxr-x--x u0 a53   u0 a53            2013-11-13 20 45 com tf thinkdroid sg drwxr-x--x u0 a68   u0 a68            2013-12-24 15 03 eu chainfire supersu drwxr-x--x u0 a59   u0 a59            2013-11-13 20 45 jp co omronsoft iwnnime ml drwxr-x--x u0 a60   u0 a60            2013-11-13 20 45 jp co omronsoft iwnnime ml kbd white drwxr-x--x u0 a69   u0 a69            2013-12-24 15 03 org mozilla firefox   Bad permissions   root grouper  data data   ls -lad com mypackage                   drw-rw-r-- u0 a70   u0 a70            2014-01-11 14 18 com mypackage   How did they get that way  I set them that way  while fiddling around trying to get adb pull to work  Clearly I did it wrong    Hey Google  it would be awful nice if a permission error produced a meaningful error message  or failing that if you didnt have to hand tweak permissions to use the tools

User · Answer

Please make sure you are not trying to open and close the database repeatedly either from main thread or background thread   Make a singleton class in your application and try to create and open data from this class only   Is guarantees you that database open call is made only when it does not exist   In your entire application use the same approach of getting sqLiteDatabase object when it is required   I used below code and my problem is solved now after 1 5 days                                                                     In Your Activity class onCreate   method   public class MainActivity extends AppCompatActivity          private AssetsDatabaseHelper helper        Override         protected void onCreate Bundle savedInstanceState            helper   AssetsDatabaseHelper getInstance this             sqLiteDatabase   helper getDatabase                          public class AssetsDatabaseHelper           Context context          SQLiteDatabase sqLiteDatabase          DatabaseHelper databaseHelper          private static AssetsDatabaseHelper instance           private  AssetsDatabaseHelper Context context               this context   context               databaseHelper   new DatabaseHelper context               if databaseHelper checkDatabase                     try                      databaseHelper openDatabase                     catch SQLException sqle                       Log e  Exception in opening         database    sqle getCause       sqle getCause                                    else                  try                      databaseHelper createDatabase                     catch IOException ioe                       Log d  Exception in creating         database    ioe getCause       ioe getCause                                   try                      databaseHelper openDatabase                     catch SQLException sqle       Log e  Exception in opening         database      sqle getCause                                              sqLiteDatabase   databaseHelper getSqLiteDatabase                       public static AssetsDatabaseHelper getInstance Context context               if instance    null                   return instance               else                    instance   new AssetsDatabaseHelper context                   return instance                                   public SQLiteDatabase getDatabase                return sqLiteDatabase

User · Answer

Add before OpenDatabase this lines   File outFile   new File Environment getDataDirectory    outFileName   outFile setWritable true   SQLiteDatabase openDatabase outFile getAbsolutePath    null  SQLiteDatabase OPEN READWRITE

User · Answer

Another thing to note is Environment getExternalStorageDirectory   has been deprecated in API 29  so change this if you re using this to get the database path  https   developer android com reference android os Environment getExternalStorageDirectory    This method was deprecated in API level 29  To improve user privacy  direct access to shared external storage devices is deprecated  When an app targets Build VERSION CODES Q  the path returned from this method is no longer directly accessible to apps  Apps can continue to access content stored on shared external storage by migrating to alternatives such as Context getExternalFilesDir String   MediaStore  or Intent ACTION OPEN DOCUMENT

User · Answer

As mentioned by  CommonsWare  you will want to try android sqlite asset helper  It made opening a pre-existing db a piece of cake for me   I literally had it working in about a half hour after spending 3 hours trying to do it all manually  Funny thing is  I thought I was doing the same thing the library did for me  but something was missing

User · Answer

nmr also check the ownership and groups on the sqlite file itself    I d copied my database in from  sdcard as root so had to change the permissions    -rw-rw---- root     root       180224 2014-05-05 11 06 test sqlite   should be    -rw-rw---- u0 a80   u0 a80     180224 2014-05-05 11 06 test sqlite   Used the following commands to set the correct ownership and group   The u0 a80 I got from ls -al on other files in the directory  chown u0 a80 test sqlite chgrp u0 a80 test sqlite

[android] android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database

Examples related to android

Examples related to android-sqlite