cordova-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parmod Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CB-3010) Unable to get data from prepoulated database table.(Select Query not working.)
Date Thu, 11 Apr 2013 09:29:16 GMT

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

Parmod Kumar commented on CB-3010:
----------------------------------

In Cordova2.6 we are also not able to get data from prepopulated  table. We are copying our
database file to the location (/data/data/packagename/app_database/ ).From DDMS we are also
able to see our database file but when we query the database it show exception  "No such table"
found.
Can you please guide me how can we get the prepopulated data in cordova2.6 and it is occuring
only for Android(4.0+).

Exception logs are:-
04-11 14:49:11.570: E/SQLiteLog(6472): (1) no such table: tblProduct
04-11 14:49:11.570: W/System.err(6472): android.database.sqlite.SQLiteException: no such table:
tblProduct (code 1): , while compiling: SELECT * FROM tblProduct
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native
Method)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1012)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
04-11 14:49:11.575: W/System.err(6472):  at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
04-11 14:49:11.575: W/System.err(6472):  at org.apache.cordova.Storage.executeSql(Storage.java:173)
04-11 14:49:11.575: W/System.err(6472):  at org.apache.cordova.Storage.execute(Storage.java:83)
04-11 14:49:11.575: W/System.err(6472):  at org.apache.cordova.api.CordovaPlugin.execute(CordovaPlugin.java:66)
04-11 14:49:11.575: W/System.err(6472):  at org.apache.cordova.api.PluginManager.exec(PluginManager.java:224)
04-11 14:49:11.575: W/System.err(6472):  at org.apache.cordova.ExposedJsApi.exec(ExposedJsApi.java:44)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewCore.nativeMouseClick(Native
Method)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewCore.nativeMouseClick(Native
Method)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewCore.access$13100(WebViewCore.java:76)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewCore$EventHub.dispatchWebKitEvent(WebViewCore.java:2898)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewInputDispatcher.dispatchWebKitEvent(WebViewInputDispatcher.java:767)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewInputDispatcher.dispatchWebKitEvents(WebViewInputDispatcher.java:689)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewInputDispatcher.access$800(WebViewInputDispatcher.java:78)
04-11 14:49:11.575: W/System.err(6472):  at android.webkit.WebViewInputDispatcher$WebKitHandler.handleMessage(WebViewInputDispatcher.java:1257)
04-11 14:49:11.575: W/System.err(6472):  at android.os.Handler.dispatchMessage(Handler.java:99)
04-11 14:49:11.580: W/System.err(6472):  at android.os.Looper.loop(Looper.java:137)
04-11 14:49:11.580: W/System.err(6472):  at android.webkit.WebViewCore$WebCoreThread.run(WebViewCore.java:1066)
04-11 14:49:11.580: W/System.err(6472):  at java.lang.Thread.run(Thread.java:856)
04-11 14:49:11.580: I/System.out(6472): Storage.executeSql(): Error=no such table: tblProduct
(code 1): , while compiling: SELECT * FROM tblProduct
                
> Unable to get data from prepoulated database table.(Select Query not working.)
> ------------------------------------------------------------------------------
>
>                 Key: CB-3010
>                 URL: https://issues.apache.org/jira/browse/CB-3010
>             Project: Apache Cordova
>          Issue Type: Bug
>          Components: Android
>    Affects Versions: 2.6.0
>         Environment: Andriod(Only test on android no idea for IOS)
>            Reporter: Parmod Kumar
>
> When we are querying on the prepoulate database it shows an error of no such table. While
we can see that all the tables are present in database. If we create a new table at run time
it will create the table in parallel to the tables which are in our prepopulated database.
Bute we are unable to get reult from the prepopulated tables.
> While testing we also found that select query is not working.

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