Thibault Durand created CB-2912:
-----------------------------------
Summary: 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: Critical
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
