Having trouble with SQLite and local storage in Android PhoneGap app specifically on Samsung Galaxy devices

Question

Having trouble with SQLite and local storage in Android PhoneGap app specifically on Samsung Galaxy devices

My PhoneGap app is running smoothly on iOS and most Android devices, but I'm encountering an issue specifically with Samsung Galaxy S3 and S4.

Upon the initial page load, the app creates a local SQL database to store question and answer values. However, on the Samsung devices, the database fails to load properly the first time the app is launched. Subsequently, if the user exits the app completely and relaunches it, the database is created without any errors. Since the first page of the app requires users to input their age, which is then stored in the SQL database, they are mistakenly assuming that the app has frozen at this stage.

The database initialization code is as follows:

index.html

document.addEventListener("deviceready", onDeviceReady, false);

function onDeviceReady() {
    populateDB(); 
}

...

Following the age_button_pressed function, there is no further progress and the database does not update accordingly.

This issue seems to be specific to Samsung Galaxy S3 and S4, leading me to speculate whether Samsung's WebKit is contributing to the problem.

javascript android sql sqlite cordova

Answer 1

Answer №1

The issue could possibly be due to opening the database multiple times. Ensure that you only open it once and perform all transactions on that same instance. Additionally, confirm that any previous transaction has completed before initiating a new one. While it's unexpected, based on my encounters, Cordova's (PhoneGap) WebSQL can be a little unpredictable.

Answer 2

The issue could possibly be due to opening the database multiple times. Ensure that you only open it once and perform all transactions on that same instance. Additionally, confirm that any previous transaction has completed before initiating a new one. While it's unexpected, based on my encounters, Cordova's (PhoneGap) WebSQL can be a little unpredictable.

Answer 3

Answer №2

My experience with phonegap was smooth from version 2.0 to 3.1 on Samsung and HTC devices, without encountering any major issues. Which version of phonegap are you currently using? I recommend sticking to stable versions rather than beta releases.

One possible reason for your problem could be a synchronization issue on app startup. To troubleshoot, try adding the deviceready event in your index.html file and then redirecting to your main page. Perform database operations like table creation and data insertion on this main page.

Additionally, make sure to monitor error messages in the errorCB function. This function receives a parameter containing an error code and message that can provide insights into the issue at hand.

If you're using a Samsung Galaxy S4 with Android 4.4, consider leveraging Chrome for debugging your JavaScript code. Debugging capabilities in phonegap, especially when used with Chrome, can greatly facilitate troubleshooting.

Answer 4

My experience with phonegap was smooth from version 2.0 to 3.1 on Samsung and HTC devices, without encountering any major issues. Which version of phonegap are you currently using? I recommend sticking to stable versions rather than beta releases.

One possible reason for your problem could be a synchronization issue on app startup. To troubleshoot, try adding the deviceready event in your index.html file and then redirecting to your main page. Perform database operations like table creation and data insertion on this main page.

Additionally, make sure to monitor error messages in the errorCB function. This function receives a parameter containing an error code and message that can provide insights into the issue at hand.

If you're using a Samsung Galaxy S4 with Android 4.4, consider leveraging Chrome for debugging your JavaScript code. Debugging capabilities in phonegap, especially when used with Chrome, can greatly facilitate troubleshooting.

Answer 5

Answer №3

In my opinion, the issue may not lie with the device itself but rather with it being overloaded. One solution could be to try executing each database order sequentially, using callbacks:

DB.transaction(
  function(tx){
     tx.executeSql("CREATE TABLE IF NOT EXISTS SessionData (\n\
        id INTEGER PRIMARY KEY,\n\
        field1 TEXT NOT NULL,\n\
        field2 TEXT NOT NULL)");
  },
  function(err){
    console.log("Error code: "+err.code);
  },
  function(){
      DB.transaction(function(tx){
         tx.executeSql("CREATE TABLE IF NOT EXISTS Table2 (\n\
          id INTEGER PRIMARY KEY,\n\
          field1 TEXT NOT NULL,\n\
          field2 TEXT NOT NULL)");
      },
      function(err){
          console.log("Error code: "+err.code);
      },
      function(){
      });
  });

Answer 6

In my opinion, the issue may not lie with the device itself but rather with it being overloaded. One solution could be to try executing each database order sequentially, using callbacks:

DB.transaction(
  function(tx){
     tx.executeSql("CREATE TABLE IF NOT EXISTS SessionData (\n\
        id INTEGER PRIMARY KEY,\n\
        field1 TEXT NOT NULL,\n\
        field2 TEXT NOT NULL)");
  },
  function(err){
    console.log("Error code: "+err.code);
  },
  function(){
      DB.transaction(function(tx){
         tx.executeSql("CREATE TABLE IF NOT EXISTS Table2 (\n\
          id INTEGER PRIMARY KEY,\n\
          field1 TEXT NOT NULL,\n\
          field2 TEXT NOT NULL)");
      },
      function(err){
          console.log("Error code: "+err.code);
      },
      function(){
      });
  });

Answer 7

Answer №4

Experiment with a larger database size, increasing it from 20000 to 200000

var db = window.openDatabase("Database", "1.0", "My Database", 200000);

Answer 8

Experiment with a larger database size, increasing it from 20000 to 200000

var db = window.openDatabase("Database", "1.0", "My Database", 200000);

Having trouble with SQLite and local storage in Android PhoneGap app specifically on Samsung Galaxy devices

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Can files be saved using AngularJS JavaScript with Windows-1250 encoding?

Is it possible to access the HTML code of an app that uses a WebView?

Ways to substitute the $(document).ready function?

Troubleshooting Problem with GenyMotion Alert Dialog on Android

android datepicker without using the dialog

Ensuring proper execution of the next callback function in an Express get request

How can I create reactivity for this hook in Vue 3?

Determining Equality in JavaScript: Comparing 2 Objects

Gaps and Islands Using Start and End Dates (Validity Periods)

A different approach to fixing the error "Uncaught (in promise) TypeError: fs.writeFile is not a function" in TensorFlow.js when running on Chrome

The 'xxx' type does not have an index signature, so the element is implicitly assigned an 'any' type

When the "change" event listener is added to an input element, the innerHTML is updated as the value increases but not when it decreases

Detect Flash Player Event using Javascript

The TextFieldParser is having difficulty parsing the final line

Is it considered acceptable to house a myriad of variables within the token object in NodeJS?

Issue with window.location.href and unexpected behavior in Firefox 7

Content not being displayed by ng-repeat

Retrieve specific information from checkboxes within a form

Conceal a div once the user scrolls to a certain position using vanilla JavaScript

React Native Application in the Absence of Reliable Internet Connectivity