tag:blogger.com,1999:blog-2145951238828046925.post7239401156524529795..comments2023-11-03T03:22:13.312-07:00Comments on brodyspark: Using SQLCipher for Android with Cordova/PhoneGapChris Brodyhttp://www.blogger.com/profile/09092706286054078026noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2145951238828046925.post-46080098440227764592013-04-08T14:47:33.428-07:002013-04-08T14:47:33.428-07:00Nice job on the SQLitePlugin. It works great. I ha...Nice job on the SQLitePlugin. It works great. I have tried added SQLCipher to my app, but can't get it to work. I am getting the NPObject error when I try to open a database with a 'key' property. Do you have any patches for the JavaScript with SQLCipher. I believe it is missing the code to include in the 'key' parameter. I have managed to get the SQLitePlugin to work without using SQLCipher. I added all the patches to the Java code and managed to get it to work if I hard code the 'key' value in the Java:<br /><br />this.openDatabase(dbname, 'mykey');<br /><br />I also looked in the JavaScript and there is not reference to the 'key' property in the 'openargs' parameter. I downloaded the JS from https://github.com/brodyspark/PhoneGap-SQLitePlugin-Android.Anonymoushttps://www.blogger.com/profile/03726945685519466447noreply@blogger.comtag:blogger.com,1999:blog-2145951238828046925.post-62440045294623368742013-03-13T10:56:40.319-07:002013-03-13T10:56:40.319-07:00Hi Chris
Thanks for this article
android 4.1 as s...Hi Chris <br />Thanks for this article<br />android 4.1 as sdk <br />cordova 2.4.0 <br />and your last version of the sqliteplugin for android<br /><br /> I followed this article I found an issue <br />your plugin was working for me without the sqlcipher integration but now it is requesting close a cursor when an insert is do it. <br /><br />Did you see this error ?<br /><br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): Releasing statement in a finalizer. Please ensure that you explicitly call close() on your cursor: INSERT INTO Test (id, name, <br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): net.sqlcipher.database.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at net.sqlcipher.database.SQLiteCompiledSql.(SQLiteCompiledSql.java:62)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at net.sqlcipher.database.SQLiteProgram.(SQLiteProgram.java:103)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at net.sqlcipher.database.SQLiteStatement.(SQLiteStatement.java:39)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at net.sqlcipher.database.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1243)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at com.cordova.plugins.sqlitePlugin.SQLitePlugin.executeSqlBatch(SQLitePlugin.java:243)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at com.cordova.plugins.sqlitePlugin.SQLitePlugin.execute(SQLitePlugin.java:116)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at org.apache.cordova.api.CordovaPlugin.execute(CordovaPlugin.java:61)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at org.apache.cordova.api.PluginManager.exec(PluginManager.java:224)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at org.apache.cordova.ExposedJsApi.exec(ExposedJsApi.java:45)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at android.webkit.JWebCoreJavaBridge.nativeServiceFuncPtrQueue(Native Method)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at android.webkit.JWebCoreJavaBridge.nativeServiceFuncPtrQueue(Native Method)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at android.webkit.JWebCoreJavaBridge.handleMessage(JWebCoreJavaBridge.java:113)<br />03-13 15:38:57.932: W/SQLiteCompiledSql(2879): at android.os.Handler.dispatchMessage(Handler.java:99) Marcohttps://www.blogger.com/profile/11148118852251540809noreply@blogger.comtag:blogger.com,1999:blog-2145951238828046925.post-27847298504131667632013-02-11T19:47:00.997-08:002013-02-11T19:47:00.997-08:00Nice post.Give it up. Thanks for share this articl...Nice post.Give it up. Thanks for share this article. For more visit:<a href="http://www.catasoftware.com.au/" rel="nofollow">android development</a>Anonymoushttps://www.blogger.com/profile/14168040308874326196noreply@blogger.com