Uncaught TypeError cannot call the 'opendatabase' method from an undefined -SQLite plugin with 3.5

Question

I do not know why this is happening. I am using the Sqlite plugin in my application. It is working fine. I can store and retrieve data from the database. But the problem is that when I try to get data on the home page (for example, the start page of the application), I get the following error:

But if I use the same code on the second page of my application, it works fine. So, how can I fill in the initial page of the application of the values ​​of DB values.

code

$( document ).ready(function() { redirectHomePage(); }); function redirectHomePage() { alert("go to home page"); var db = window.sqlitePlugin.openDatabase({name: "test.db"}); db.transaction(function (tx) { tx.executeSql("select distinct Category from Locationlog;", [], function (tx, res) { $("#select-choice").empty(); var optionheading = '<option value="Select Category">Select Category</option>'; $("#select-choice").append(optionheading); alert("length: "+ res.rows.length); for (var i = 0; i < res.rows.length; i++) { var opt = '<option value="'; opt += res.rows.item(i).Category; opt += '">'; opt += res.rows.item(i).Category; opt += '</option>'; $("#select-choice").append(opt).selectmenu('refresh'); $("#locationList").empty(); } }); }); $.mobile.changePage('#homePage', "slide", false, true); } 

The identifier of my application’s homepage is “homepage”. I work on the Android platform with a corridor-3.5. Any suggestions on filling out the database before loading the first page. I tried the "pages", I have the same error. Any other methods?

Answer 1

The statement in your code will not be executed if you have not included the sqlite plugin in your project.

 var db = window.sqlitePlugin.openDatabase({name: "test.db"}); 

You should also wait for the deviceready event to fire before using cordova plugins.
You can use the window.openDatabase () call, which creates sqlite DB and does not need the sqlite plugin.
Below is the code for using the openDatabase call in your application.

if your sqlite plugin is working correctly then change the db call to.

 var db = window.sqlitePlugin.openDatabase({name: "test.db"}); 

which does not use the sqlite plugin.

 // Wait for device API libraries to load // document.addEventListener("deviceready", onDeviceReady, false); // device APIs are available // function onDeviceReady() { var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); db.transaction(populateDB, errorCB, successCB); } // Populate the database // function populateDB(tx) { tx.executeSql('DROP TABLE IF EXISTS DEMO'); tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)'); tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")'); tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")'); } // Transaction error callback // function errorCB(err) { alert("Error processing SQL: "+err); } // Transaction success callback // function successCB() { alert("success!"); } 

The above code snippet is taken from the Cordoba API document. See here for more details. Although the documentation is rated at 3.0, it should work at 3.5