cordova-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thibault Durand (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CB-2912) Android 4.X SQLite issue ( maybe conflict using websql)
Date Fri, 05 Apr 2013 18:57:17 GMT

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

Thibault Durand edited comment on CB-2912 at 4/5/13 6:56 PM:
-------------------------------------------------------------

Did you have this switch for Android 4.x only since 2.6.0 ? Because i didn't have any issue
before.

And yes, normally i have the error with websql on creating table which exists, but it's not
causing the app to crash. 

And yes i know i shouldn't use websql anymore, but indexed db is just pain in the ass. Seems
websql will be supported on mobile device for a long time.
                
      was (Author: tdurand):
    Do you switch for Android 4.x only since 2.6.0 ? Because i didn't have any issue before.

And yes, normally i have the error with websql on creating table which exists, but it's not
causing the app to crash. 

And yes i know i shouldn't use websql anymore, but indexed db is just pain in the ass. Seems
websql will be supported on mobile device for a long time.
                  
> Android 4.X SQLite issue ( maybe conflict using websql)
> -------------------------------------------------------
>
>                 Key: CB-2912
>                 URL: https://issues.apache.org/jira/browse/CB-2912
>             Project: Apache Cordova
>          Issue Type: Bug
>          Components: Android
>    Affects Versions: 2.6.0
>         Environment: Android 4.0.3 , Android 4.2 
>            Reporter: Thibault Durand
>            Assignee: Joe Bowser
>            Priority: Minor
>
> Hello, 
> I have an issue with my app using the last version of cordova with cordova CLI (NPM ,
version @2.6.0)
> Cordova version is master : commit 47593b2bc1dba9bf46545b1da24577f937966e12 
> My app use websql, and it seems there are some conflict with SQLite on Android 4.X ,
android 2.X works just fine (i don't really know what websql api uses...)
> Here is the stacktrace, the database seems to be initialized but each request trigger
a System error : 
> 04-05 11:58:13.413: W/System.err(5739): android.database.sqlite.SQLiteException: table
user_card already exists: , while compiling: CREATE TABLE user_card( id INTEGER NOT NULL PRIMARY
KEY AUTOINCREMENT, card_stat_id INTEGER, es TEXT, fr TEXT, it TEXT, de TEXT, esperanto TEXT,
en TEXT, txt_es TEXT, txt_fr TEXT, txt_en TEXT, txt_it TEXT, txt_de TEXT, txt_esperanto TEXT,
typeCard TEXT, usage TEXT, genre TEXT, image TEXT, licence TEXT, sound TEXT, linked_card TEXT,
tags TEXT, category TEXT, level INTEGER );
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native
Method)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2034)
> 04-05 11:58:13.413: W/System.err(5739):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1974)
> 04-05 11:58:13.413: W/System.err(5739):     at org.apache.cordova.Storage.executeSql(Storage.java:169)
> 04-05 11:58:13.413: W/System.err(5739):     at org.apache.cordova.Storage.execute(Storage.java:83)
> 04-05 11:58:13.413: W/System.err(5739):     at org.apache.cordova.api.CordovaPlugin.execute(CordovaPlugin.java:66)
> 04-05 11:58:13.413: W/System.err(5739):     at org.apache.cordova.api.PluginManager.exec(PluginManager.java:222)
> 04-05 11:58:13.413: W/System.err(5739):     at org.apache.cordova.ExposedJsApi.exec(ExposedJsApi.java:44)
> 04-05 11:58:13.413: W/System.err(5739):     at android.webkit.JWebCoreJavaBridge.sharedTimerFired(Native
Method)
> 04-05 11:58:13.413: W/System.err(5739):     at android.webkit.JWebCoreJavaBridge.sharedTimerFired(Native
Method)
> 04-05 11:58:13.413: W/System.err(5739):     at android.webkit.JWebCoreJavaBridge.fireSharedTimer(JWebCoreJavaBridge.java:92)
> 04-05 11:58:13.413: W/System.err(5739):     at android.webkit.JWebCoreJavaBridge.handleMessage(JWebCoreJavaBridge.java:108)
> 04-05 11:58:13.413: W/System.err(5739):     at android.os.Handler.dispatchMessage(Handler.java:99)
> 04-05 11:58:13.413: W/System.err(5739):     at android.os.Looper.loop(Looper.java:137)
> 04-05 11:58:13.413: W/System.err(5739):     at android.webkit.WebViewCore$WebCoreThread.run(WebViewCore.java:823)
> 04-05 11:58:13.413: W/System.err(5739):     at java.lang.Thread.run(Thread.java:856)
> Cordova 2.5.0 and under works fine.
> Thanks

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