cordova-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Bowser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CB-2639) SQLite error: 23 "not authorized" on Android
Date Tue, 12 Mar 2013 20:09:14 GMT

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

Joe Bowser commented on CB-2639:
--------------------------------

The latest version of Cordova is 2.5.0.  You were using 2.2.0, which is three versions old
at least.  We test everything against the master branch of Cordova to see if it affects our
upcoming release.  I tested this on Android 2.3.6 (Nexus S), 4.0.3 (HTC One X) and 4.2.2 (Nexus
4).
                
> SQLite error: 23 "not authorized" on Android
> --------------------------------------------
>
>                 Key: CB-2639
>                 URL: https://issues.apache.org/jira/browse/CB-2639
>             Project: Apache Cordova
>          Issue Type: Bug
>          Components: Android
>    Affects Versions: 2.2.0
>         Environment: Several Android devices, apparently pre-4.1.  See details below.
>            Reporter: Nolan Lawson
>            Assignee: Joe Bowser
>
> (Moved from a comment I mistakenly added to CB-592.)
> I am unable to insert/update to the SQLite database using the standard {{window.openDatabase()}}
approach described in the [Storage docs|http://docs.phonegap.com/en/1.2.0/phonegap_storage_storage.md.html].
 The transaction fails with the error "23: not authorized".
> I'm using PhoneGap Build and PhoneGap v.2.2.0.
> All I do is create a database:
> {code:JavaScript}
> var db = window.openDatabase('myDatabase', '1.0', "My Database", 1000000);
> {code}
> Then I call a simple chain of two queries on it:
> {code:JavaScript}
> function query(tx) {
>     tx.executeSql('select 1 from sqlite_master');
> }
> function onError() {
>     ....
> }
> function onSuccess() {
>     db.transaction(query2, onError2, onSuccess2);
> }
> function query2(tx) {
>     tx.executeSql('create table mytable(mycolumn text)');
> }
> function onError2() {
>     ....
> }
> function onSuccess2() {
>     ....
> }
> db.transaction(query, onError, onSuccess);
> {code}
> The table below shows the Android devices that I tested this on, and the failure I got
in each.
> ||Device||Android||Working?||Result||Logcat|| SQLError object||
> |Galaxy Nexus|4.1.1|{color:green}Yes{color}|Logs an error, but still works.| {{SQLiteLog
 E  (23) not authorized}}||
> |Nexus One|2.3.7|{color:red}No{color}|Calls the {{onError2}} message above.|{{Database
 I  sqlite returned: error code = 23, msg = not authorized}}|{code:JavaScript} {"message":"not
authorized","code":1} {code}|
> |HTC Magic|2.1-update1|{color:red}No{color}|Calls the {{onError2}} message above.|None|{code:JavaScript}
{"code":1,"message":"not authorized"} {code}|
> |Galaxy Tab 8.9|4.0.4|{color:red}No{color}|Calls the {{onError2}} message above.|{{SqliteDatabaseCpp
 I  sqlite returned: error code = 23, msg = not authorized, db=xxx}}|{code:JavaScript} {"code":5,"message":"not
authorized"} {code}|
> |Samsung GT-I9001|2.3.6|{color:red}No{color}|Calls the {{onError2}} message above.|None|{code:JavaScript}
{"message":"not authorized","code":1} {code}|
> I've also tested on an iPod Touch (5th generation) with no issues.
> Based on the comments in CB-592, it seems like the problem is caused by Android's native
Web SQL Database implementation.  Apparently they've supported it going back to 2.1 ([link|http://caniuse.com/sql-storage]),
and the [Cordova docs|http://docs.phonegap.com/en/1.2.0/phonegap_storage_storage.md.html]
say they defer to the native interface if it's available, meaning that it has nothing to do
with Cordova's implementation.
> I'm really hoping there's a workaround for this, since otherwise I'm unable to use SQLite
on Android using Cordova.

--
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

Mime
View raw message