topic Quote:Phil P. (Pete) wrote: in Software Archive

Adding Third party plugin itehelpers/Cordova-sqlite-storage showing 'sqllite-connector.jar' file not find

kulkarni__sameer — Fri, 07 Apr 2017 10:01:42 GMT

I am developing app using sqlite plugin. while fetching plugin from github link it's shwing that sqlite-connector.jar file not found.I am not getting why this is showing or is there any suitable method for local database better than sqlite.Please help me.

Regards

Sameer Kulkarni

Please carefully read this

PaulF_IntelCorp — Fri, 07 Apr 2017 17:20:00 GMT

Please carefully read this section of the README on that plugin's github repo. This plugin can only be used with Cordova CLI. The last version that worked with either PhoneGap Build or the XDK build system was version 1.2.2.

Not sure why you're using the

Phil_P___Pete_ — Fri, 07 Apr 2017 17:22:21 GMT

Not sure why you're using the plugin, SQLLite is built in natively and works pretty well. (I have 4 apps using the native functionality). Some features are a little trickier than you might think but that's about the only issue.

IF you really feel the need to use the plugin, I'd suggest downloading it and then adding it via the 3rd party option. Note though that some plugins won't unzip because the path is too long.

Quote:Phil P. (Pete) wrote:

kulkarni__sameer — Sat, 08 Apr 2017 05:22:22 GMT

Phil P. (Pete) wrote:

Not sure why you're using the plugin, SQLLite is built in natively and works pretty well. (I have 4 apps using the native functionality). Some features are a little trickier than you might think but that's about the only issue.

IF you really feel the need to use the plugin, I'd suggest downloading it and then adding it via the 3rd party option. Note though that some plugins won't unzip because the path is too long.

As your suggestion , now plugin is added .i tried sample code from github but it's not working only showing OPEN database: my.db in debugger but in emulator and app preview not showing anything . I don't know where i made mistake .Please help me.code snippet as below.

document.addEventListener('deviceready',onDeviceReady,false);
function onDeviceReady(event)
{
   var x= document.getElementById('alert');
    x.innerHTML="Hari Om";
    //navigator.notification.alert("Har Om");
    window.sqlitePlugin.selfTest(function() {
    console.log('SELF test OK');
        x.innerHTML="Test ok";
        navigator.notification.alert("Har Om");
  });
    
   
    var db = window.sqlitePlugin.openDatabase({ name: 'my.db', location: 'default' }, function (db) {
                    navigator.notification.alert("Har Om");
                                // Here, you might create or open the table.
                     db.transaction(function (tx) {
    // ...
    tx.executeSql('CREATE TABLE customerAccounts (firstname, lastname, acctNo)');
}, function (error) {
    console.log('transaction error: ' + error.message);
                          navigator.notification.alert(error.message);
}, function () {
    console.log('transaction ok');
                          navigator.notification.alert("ok");
});
        

          }, function (error) {
                    console.log('Open database ERROR: ' + JSON.stringify(error));
         navigator.notification.alert("ok");
          });
    
    
}

You cannot debug third-party

PaulF_IntelCorp — Sat, 08 Apr 2017 23:32:25 GMT

You cannot debug third-party plugins in the Simulate (Emulate) tab and in App Preview. You can only test that code in a built app. See these doc pages: