Why I cannot use cordova-sqlite-storage?

Question

I am writing an android app, I am using phonegap and with weinre for debugging.

Some info:

$ phonegap -v
5.3.9
$ cordova plugin list
cordova-plugin-whitelist 1.2.0 "Whitelist"
cordova-sqlite-storage 0.7.14 "Cordova sqlite storage plugin"

The plugin is installed, but when I run it with phonegap and open it in my phone, nothing shows up in the console. No error, nothing. The window object was printed in the console, but not everything else.

I am using the default configuration of phonegap, can anybody tell me why this is happenning?

This is the code I have written in my js script.

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

function onDeviceReady(event) {                              

    console.log(window);                                     
    //var db = window.sqlitePlugin.openDatabase({name: "my.db"});
    //var openDatabase = sqlitePlugin.openDatabase;          
    console.log(window.sqlitePlugin);                        
    console.log(window.sqlitePlugin.openDatabase);           

    var db = window.sqlitePlugin.openDatabase({name: "test.db"},
        function(db) {                                       
            console.log('db open succeeded');                
        },                                                   
        function(err) {                                      
            console.log('Open database ERROR: ' + JSON.stringify(err));
        }                                                    
    );                                                       

    db.executeSql("create table tmp 'column1' INT;", [], function (res) {
        console.log('got stringlength: ' + res.rows.item(0).stringlength);
    }, function(error) {                                     
        console.log('SELECT error: ' + error.message);       
    });                                                      

    db.executeSql("SELECT LENGTH('tenletters') AS stringlength", [], function (res) {
        console.log('got stringlength: ' + res.rows.item(0).stringlength);
    }, function(error) {                                     
        console.log('SELECT error: ' + error.message);       
    });                                                      
}

Possible duplicate of http://stackoverflow.com/questions/33879785/cordova-sqlite-plugin-not-functioning-with-android-studio/33894275#33894275 — Dhruv, Dec 12 '15 at 11:39

score 0 · Answer 1 · answered Dec 12 '15 at 21:11

0

I would suggest not using weinre, unless you really have to. Built-in alternatives for some devices, listed here: http://people.apache.org/~pmuellr/weinre/docs/latest/

answered Dec 12 '15 at 21:11

Patrick Mueller

697
1
6
13

score 0 · Answer 2 · answered Mar 31 '16 at 11:33

Hi Kindly do something like this in your onDeviceReady(). Maybe it is unable to work with sqllite db .

onDeviceReady: function() {
        app.receivedEvent('deviceready');
          if(window.sqlitePlugin !== undefined) {
            console.log('opening sqlite DB ');
            db = window.sqlitePlugin.openDatabase("ECM_MOBILE");
        } else {
            console.log('opening Web SQL DB ');
            db = window.openDatabase("ECM_MOBILE", "1.0", "Cordova Demo", 200000);
        }   

    }

if sqlite is not being installed properly then , you need to fix the installation for sqlite db .

score 0 · Answer 3 · answered May 31 '16 at 13:18

0

in newer versions of the SQLite plugin location must be set when opening a database :

var db = window.sqlitePlugin.openDatabase({name: "my.db", location: "default"});

answered May 31 '16 at 13:18

Bogdan Mircea Stanciu

222
1
11

Why I cannot use cordova-sqlite-storage?

3 Answers3