iphone “EXC_BAD_ACCESS” when doing sqlite3_open(":memory:", &memory_db)

Question

Hi there!

While developing for iphone i get “EXC_BAD_ACCESS” when doing

    sqlite3         *memory_db;
    if (sqlite3_open(":memory:", &memory_db) != SQLITE_OK)
    {
        sqlite3_close(memory_db);
        NSAssert(0, @"Failed to open in-memory database");
}

also doing

    NSString * memory_db_filename = @":memory:";
    if (sqlite3_open([memory_db_filename UTF8String], &memory_db) != SQLITE_OK)
    {
        sqlite3_close(memory_db);
        NSAssert(0, @"Failed to open in-memory database");
    }

does not help. Are in-memory sqlite3 databases not available on the iphone?

Any comments are appreciated!

Answer 1

EXC_BAD_ACCESS is not an SQLite3 error code. See this SO question.