SQL Lite Error Code 23 - Not Authorized in Phonegap

[m4sey1]

Hi all,

I'm in the process of developing a PhoneGap app whereby the SQL Lite
data storage is used to store some basic data capture points from a
form.

The problem is when an update SQL is executed against the database
(exactly as per http://docs.phonegap.com/en/1.6.1/index.html), i
intermitantly recieve an error message in the LogCat of eclipse which
states:

"SqliteDatabaseCpp(4453): sqlite returned: error code = 23, msg = not
authorized, db=/data/data/com.packageName/databases/webview.db"

Sometimes the update works, most of the time it fails.

After allot of hair pulling, I found this post (http://
comments.gmane.org/gmane.comp.handhelds.phonegap/22780). Which
mentions changing the version number of the openDatabase() after a
first run of the application. Weirdly this seems to alleviate the
problem - however, its not feasible to do this every time especially
when the app will be deployed to remote users. - And therefore either
think its something that I'm doing wrong or is a bug in Phonegap -
i've updated to the latest release candidate (out today) but this
hasn't made any difference.

Has anybody come across this, and if so whats the work around?

Android 3.1 is the test machine.

Thanks,

[Shazron]

Please file an issue for Android at:
https://issues.apache.org/jira/browse/CB

> --
> You received this message because you are subscribed to the Google
> Groups "phonegap" group.
> To post to this group, send email to phon...@googlegroups.com
> To unsubscribe from this group, send email to
> phonegap+u...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/phonegap?hl=en?hl=en
>
> For more info on PhoneGap or to download the code go to www.phonegap.com