[jira] [Comment Edited] (CB-592) SQLITE Error code = 23, msg = not authorized (Intermittently)

["Nolan Lawson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CB-592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13597372#comment-13597372 ] 

Nolan Lawson edited comment on CB-592 at 3/8/13 6:22 PM:
---------------------------------------------------------

Issue filed: CB-2639.  Thanks for the commentary, [~bowserj].

[edit] Moved my questions to the other bug; no sense in posting them here.
                
      was (Author: nolanlawson):
    Issue filed: CB-2639.  Thanks for the commentary, [~bowserj].

So if Android 4.x uses Cordova's implementation, any idea why it would fail on 4.0.4?  Also, would it be possible to simply use the Cordova implementation everywhere, assuming the native implementation on older Android devices is just hopelessly broken?

Also, if WebSQL is being deprecated, is the future-proof recommended solution to just use a native SQLite plugin ([such as this one|https://github.com/davibe/Phonegap-SQLitePlugin])?
                  
> SQLITE Error code = 23, msg = not authorized (Intermittently)
> -------------------------------------------------------------
>
>                 Key: CB-592
>                 URL: https://issues.apache.org/jira/browse/CB-592
>             Project: Apache Cordova
>          Issue Type: Bug
>          Components: Android, CordovaJS
>    Affects Versions: 1.6.1
>         Environment: Android 3.1. Cordova 1.6.1 but also older versions (also appears to be the same in "phonegap" 1.3.0. Motorola Xoom. Eclipse. JQuery Mobile.
>            Reporter: Carl Mason
>            Assignee: Joe Bowser
>            Priority: Minor
>
> Intermittently receiving the error message, when executing an update statement on SQLLite database. 
> 04-27 10:22:38.288: I/SqliteDatabaseCpp(1428): sqlite returned: error code = 23, msg = not authorized, db=/data/data/com.packagename/databases/webview.db
> (example)
> tx.executeSql('UPDATE JOB SET postcode = "' + $("#tbPostcode").val() + '" WHERE id = "' + window.localStorage.getItem("job_id") +'"', [], querySuccess, errorCB);
> It appears it could be to do with the version variable in openDatabase(..).
> When I fire openDatabase on a FIRST execution with a version "1.0", create some tables and insert some data - I will get the above error intermittently when trying to update. However, if I then change all of the database interaction to a version "1.1" (or anything different) deploy the application and execute a second time - and go on to create a second database and start updating/interacting with the database the error goes away. Obviously this is not a feasible workaround when deploying an app live. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira