Using PrePopulated SQlite database in android

Question

I have tried to open Sqlite database using react-native for android application but couldn't open using prepopulated database stored inside assets directory of the project.

I have removed location and createfromLocation from the openDataBase code databae was created in android device which would be empty without schema and data. I can populate data from the code but this doesn't make any sense. So What might be the mistake that I am making.Am I missing something here?

Code(App.js file):

 const db = SQLite.openDatabase(
      {
        name: 'Recipe.db',
        location: 'default',
        createFromLocation: '~Recipe.db',
      }

Log:

 OPEN database: Recipe.db
05-20 09:22:23.620  5975  6009 I ReactNativeJS: new transaction is waiting for open operation
05-20 09:22:23.629  5975  6009 I ReactNativeJS: OPEN database: Recipe.db failed, aborting any pending transactions
05-20 09:22:23.632  5975  6009 I ReactNativeJS: { [Error: Could not open database]
05-20 09:22:23.632  5975  6009 I ReactNativeJS:   code: 0,
05-20 09:22:23.632  5975  6009 I ReactNativeJS:   line: 100047,
05-20 09:22:23.632  5975  6009 I ReactNativeJS:   column: 27,

Michael Dougan · Accepted Answer · 2019-05-20 15:46:32Z

1

You can't open a SQLite DB for writing if it is stored in the Assets folder. Typically, on startup, an app will check to see if it has a SQLite database in its own /data/data/database folder. If not, it copies the database from the Assets folder to the /data/data/database folder, then opens that copy for writing.

Changes made to the database while in the /data/data/database folder will persist, even if the app is updated. But, it will be deleted if the user deletes the app. Then the app will have to do the database copy again.

answered May 20, 2019 at 15:46

Michael Dougan

1,7081 gold badge9 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SGC Over a year ago

I am trying to use database for write operation only. So Do the above code copy the Recipe.db from assets directory to the /data/data/database so that I can perform read operation on Recipe database? I have deleted the databases from /data/data/database location and start the app but still got an issue.

Michael Dougan Over a year ago

You need to add code in your app, which before you execute any code to read or write to the database, you call a method to see if the database exists in the /data/data/database folder, and if so, Open it. If it does not exist, then copy the database from the Assets folder to the /data/data/database folder then Open it from there.

SGC Over a year ago

My be there was an issue in configuration. Issue got resolved with same code. Thanks for the help.

Collectives™ on Stack Overflow

Using PrePopulated SQlite database in android

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related