SQLCipher CREATE TABLE android_metadata failed

Question

I'm integrating SQLCipher in a application with a SQLite Db. when the app is launch, I receive a "application has stopped unexpectedly" error. When I look at LogCat I see the initial error is "CREATE TABLE android_metadata failed". The only change I have made to this application is adding the code to integrate SQLCIpher. I'm sure I have not coded it properly but am not sure what i missed. the following has been done:

1.java.io.file, info,guardianproject.database.sqlcipher.SQLiteDatabase, android.os.Bundle, and android.app.activity have been imported. 2. InitializeSQLCipher() has been added to the onCreate method of the splash activity

private void InitializeSQLCipher() {
    SQLiteDatabase.loadLibs(this);
    File databaseFile = getDatabasePath ("mydatabase.db");
    databaseFile.mkdirs();
    databaseFile.delete();
    SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(databaseFile, "password", null);
    database.execSQL("create table t1(a, b)");
    database.execSQL("insert into t1(a, b) values(?, ?)", new Object[]{"one for the money", "two for the show"});
     }

FWIW, here is a sample app showing SQLCipher in use: https://github.com/commonsguy/cw-advandroid/tree/master/Database/ConstantsSecure — CommonsWare, May 17 '12 at 14:39

score 0 · Answer 1 · answered May 18 '12 at 15:43

0

The most likely answer is that you have not moved the ICU resource files into the assets directory. Make sure you copy the icu*.zip into your assets folder and include it in your build.

answered May 18 '12 at 15:43

Stephen Lombardo

1,503
8
7

score 0 · Answer 2 · answered May 20 '12 at 00:12

0

CommonsWare has provided sample code illustrating the concept. Check it out here.

answered May 20 '12 at 00:12

Alex Lockwood

83,063
39
206
250

score 0 · Accepted Answer · answered Aug 21 '12 at 18:01

0

removed the "." from databasename.db (e.g.databasedb)

answered Aug 21 '12 at 18:01

user1165694

1,255
2
18
29

SQLCipher CREATE TABLE android_metadata failed

3 Answers3