SQLite: DB error, "out of memory"

Question

I am using FMDB to create and add a record to a d/b. The method to create the d/b is:

//-----------------------    checkIfDatabaseExists    -----------------|
+ (void) openCreateDB  {

    NSArray *searchPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);  // Get the path to the database file
    NSString *documentPath = [searchPaths objectAtIndex:0];
    NSString *databasePath = [documentPath stringByAppendingPathComponent:@"ppcipher.s3db"];
    NSLog(@"d/b path: /%@", databasePath);

    char * errmsg = nil;   

    NSFileManager *fileManager = [NSFileManager defaultManager];
    [fileManager removeItemAtPath:databasePath error:NULL];  //  <------------  delete d/b  TESTING ONLY! 

    BOOL fileExists = [fileManager fileExistsAtPath:databasePath];
    if(!fileExists)  {
        FMDatabase* _db = [FMDatabase databaseWithPath: databasePath]; 

        if (![_db open]) {
            NSLog(@"Could not open/create database");
        }

        [_db executeUpdate:@"CREATE TABLE CardData (card_id TEXT PRIMARY KEY NOT NULL, card_name TEXT NOT NULL, "
         @"card_type TEXT, code_val TEXT, create_date TEXT DEFAULT CURRENT_DATE, user_notes TEXT, gps_loc TEXT)"];

        if(errmsg != nil)
            NSLog(@"error: %s", errmsg);  //  DEBUGGING ONLY!  (REMOVE when done!)
    }
    return;
}

Which causes NO errors. However, when I next do one (1) "insert" after the "open", I get an error from FMDB saying DB Error: 7 "out of memory". And every sql statement after this, I get the same error (only the creation of the d/b gave no errors!). Here is the code for the insert:

//---------------------    addRecordToDatabase    ----------------------|
+ (void)addRecordToDatabase: (ZBarSymbol *)symbol  {


    FMDatabase* _db = [FMDatabase sharedFMDatabase];

    [_db setLogsErrors:1];  //  log all of the SQLite d/b errors

    [_db executeUpdate: @"INSERT INTO CardData (card_id, card_name, code_val) VALUES (?, ?, ?)", symbol.data, @"Test Card", symbol.typeName, nil];

}

This is a very small d/b with minimal data. I ran Inspector and nothing was out of the ordinary. Any suggestions would be greatly appreciated.

superandrew · Accepted Answer · 2011-05-05 13:27:15Z

20

I think you should just call[_db open] in your code, that should fix it. It seems that the "out of memory error" in FMDB means also error caused by missing table(s) or connection not open.

answered May 5, 2011 at 13:27

superandrew

1,78120 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

SpokaneDude Over a year ago

Thank you... I think that did it... (it was a missing table).

Craig Grummitt Over a year ago

I made a similar oversight, bad error message though.

Victor Choy Over a year ago

You really help me a lot. A fool message

Collectives™ on Stack Overflow

SQLite: DB error, "out of memory"

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related