[
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 7:10 PM:
-------------------------------------------------------------
Did you have implemented 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 android/ios device for a long time.
was (Author: tdurand):
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 android/ios 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
