Memory Leaks in pickerView using sqlite

Posted by Danamo on Stack Overflow See other posts from Stack Overflow or by Danamo
Published on 2011-01-14T16:39:02Z Indexed on 2011/01/14 16:53 UTC
Read the original article Hit count: 158

I'm adding self.notes array to a pickerView. This is how I'm setting the array:

 NSMutableArray *notesArray = [[NSMutableArray alloc] init];
 [notesArray addObject:@"-"];
 [notesArray addObjectsFromArray:[dbManager getTableValues:@"Notes"]];
 self.notes = notesArray;
 [notesArray release];

The info for the pickerView is taken from the database in this method:

-(NSMutableArray *)getTableValues:(NSString *)table
{
  NSMutableArray *valuesArray = [[NSMutableArray alloc] init];
  if (sqlite3_open([self.databasePath UTF8String], &database) != SQLITE_OK)
  {
      sqlite3_close(database);
      NSAssert(0, @"Failed to open database");
  }
  else 
  {
   NSString *query = [[NSString alloc] initWithFormat:@"SELECT value FROM %@", table];
   sqlite3_stmt *statement;

   if (sqlite3_prepare_v2(database, [query UTF8String], -1, &statement, nil) == SQLITE_OK)
   {
     while (sqlite3_step(statement) == SQLITE_ROW) {
     NSString *value =[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)];
     [valuesArray addObject:value];
     [value release]; 
   }
   sqlite3_reset(statement);
  }
  [query release]; 
  sqlite3_finalize(statement);
  sqlite3_close(database);
 }
 return valuesArray;
}

But I keep getting memory leaks in Instruments for these lines:

NSMutableArray *valuesArray = [[NSMutableArray alloc] init];

and

[valuesArray addObject:value];

What am I doing wrong here?

Thanks for your help!

© Stack Overflow or respective owner

Related posts about objective-c

Related posts about sqlite