Hi ...
I'm trying to use SQLCipher to protect my database , but I faced some problems.
this an example to my problem ..
http://www.mediafire.com/file/uyp5aibeznsore9/SQLCipher.rar
I used "DB Browser for SQLite" to create a database with one table.
when I try to do "SELECT * FROM table" , the application crash immediately
Note :
- I copied icudt46l.zip to Files folder
- Test it on Samsung Note 4 ( 6.0.1 )
Thank you
I'm trying to use SQLCipher to protect my database , but I faced some problems.
this an example to my problem ..
http://www.mediafire.com/file/uyp5aibeznsore9/SQLCipher.rar
I used "DB Browser for SQLite" to create a database with one table.
when I try to do "SELECT * FROM table" , the application crash immediately
B4X:
** Service (starter) Create **
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
main_activity_create (java line: 356)
net.sqlcipher.database.SQLiteException: near "table": syntax error: , while compiling: SELECT * FROM table
at net.sqlcipher.database.SQLiteCompiledSql.native_compile(Native Method)
at net.sqlcipher.database.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:91)
at net.sqlcipher.database.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:64)
at net.sqlcipher.database.SQLiteProgram.<init>(SQLiteProgram.java:83)
at net.sqlcipher.database.SQLiteQuery.<init>(SQLiteQuery.java:49)
at net.sqlcipher.database.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:42)
at net.sqlcipher.database.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1758)
at net.sqlcipher.database.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1723)
at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.ExecQuery2(SQLCipher.java:196)
at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.ExecQuery(SQLCipher.java:183)
at b4a.example.SQLCipher.main._activity_create(main.java:356)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:179)
at b4a.example.SQLCipher.main.afterFirstLayout(main.java:102)
at b4a.example.SQLCipher.main.access$000(main.java:17)
at b4a.example.SQLCipher.main$WaitForLayout.run(main.java:80)
at android.os.Handler.handleCallback(Handler.java:739)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:158)
at android.app.ActivityThread.main(ActivityThread.java:7225)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)Note :
- I copied icudt46l.zip to Files folder
- Test it on Samsung Note 4 ( 6.0.1 )
Thank you