vendredi 24 juillet 2015

Simultaneous access SQLITE JAVA SERVICE / CordovaJS APP errors

Aloa

I am trying to make an app (Android to begin, and then IOS) that one side (JAVA) executes SQL statements on a database stored on the phone (imported once from the www folder and using SQLiteOpenHelper ..) in java from a background service starting at the boot. No worries on that side.

On the other hand (CordovaJS) I check / update the same database from the same application, but in the GUI (webview) via the cordova Cordova-storage-sqlite plugin. No worries either on that side ...

But when JAVA and CordovaJS try to use the database at the same time, the app crash sometimes...

How can I do to access to the base of both sides simultaneously? Otherwise what would be the best solution:

  1. Create two separate databases with the same information that I would need to synchronize regularly between JAVA and CordovaJS in the two ways? Synchronization can possibly lead to the same problem of dual access ...
  2. Create two bases, and communicate via flat files containing JSON data ...
  3. Not to use databases and move only by flat files in JSON?
  4. Any other ideas?

I'd rather largely retain only one database ... Thank you in advance for review

PS: Sorry for my English, I'm French :(

Aucun commentaire:

Enregistrer un commentaire