Read data from existing sqlite.db is working on simulator but not actual device (Objective C)

Question

I don't know how to fix this error, I go to "Build Phases" and add sqlit.db file to Bundle resources but it still error. Have anyone solve the problem this thing?.

Click Here to see code

-(void) initDatabase{
    dbName  = @"MBox_karaoke.db";
    BOOL success;
    NSFileManager *fileManager  = [NSFileManager defaultManager];
    NSError *error;
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *writeableDBPath = [documentsDirectory stringByAppendingPathComponent:dbName];
    success = [fileManager fileExistsAtPath:writeableDBPath];

    if(success){
        return;
    }

    NSString *defaultDBPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:dbName];

    success = [fileManager copyItemAtPath:defaultDBPath toPath:writeableDBPath error:&error];
    if (!success) {
        // NSAssert1(0, @"Failed to create writable database file with message '%@'.", [error localizedDescription]);
        NSLog(@"Database created failed, %@",[error localizedDescription]);
    }
    else {
        NSLog(@"Database created successfully");
    }
}

yes, i already do but still error : [NSFileManager copyItemAtPath:toPath:error:]: source path is nil' — pch
– pch, Commented Jul 4, 2016 at 8:47

MD. · Accepted Answer · 2016-07-04 08:55:19Z

1

As an error states resource file not found.

Make sure you copied the database file in bundle. When you drag database to project navigator, make sure that you have checked "Copy item if needed".

Following solution working for me.

-(void)initializeDatabase {

    NSError *error;
    NSFileManager *fm = [NSFileManager defaultManager];
    NSArray *docPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *docDir = [docPaths objectAtIndex:0];
    NSString *docPath = [docDir stringByAppendingPathComponent:@"Test.sqlite"];

    NSString *template_path = [[NSBundle mainBundle] pathForResource:@"Test" ofType:@"sqlite"];

    if (![fm fileExistsAtPath:docPath])
        [fm copyItemAtPath:template_path toPath:docPath error:&error];


    //-====
}

edited Jul 4, 2016 at 8:55

answered Jul 4, 2016 at 8:43

MD.

1,16711 silver badges18 bronze badges

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

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Your code is correct but some time database file doesn't select target membership that your database doesn't copy your path that it's this type error occur.

First Remove/Uninstall your install app.

Please, Select your database file in xcode and see your target membership is check or uncheck. Uncheck that select check. (See below image)

Run the project simulator and check your database available in your path. Database available that see your database browse contain is correct.

NSLog("Path: %@",defaultDBPath);

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 4, 2016 at 9:11

Bhadresh Kathiriya

3,2442 gold badges24 silver badges41 bronze badges

Comments

user3182143 · Accepted Answer · 2016-07-04 11:20:48Z

My answer

 + (NSString *)databasePath
 {
    NSArray *paths=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *sql_Path=[paths objectAtIndex:0];

    NSString *dbPath=[sql_Path stringByAppendingPathComponent:@"MBox_karaoke.sqlite"];

    NSFileManager *fileMgr=[NSFileManager defaultManager];
    BOOL success;
    NSError *error;
    success=[fileMgr fileExistsAtPath:dbPath];
    if (!success) 
    {
       NSString *path=[[[NSBundle mainBundle]resourcePath]stringByAppendingPathComponent:@"MBox_karaoke.sqlite"];
      success=[fileMgr copyItemAtPath:path toPath:dbPath error:&error];
    }
    return dbPath;
}

Create Table and here My Table Name is Account

+ (void) createTableForAccount
{
   char *error;
   NSString *filePath =[self databasePath];
   if (sqlite3_open([filePath UTF8String], &database) == SQLITE_OK)
   {
      NSString *strQuery=[NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS Account(id TEXT,name TEXT);"];
      sqlite3_exec(database, [strQuery UTF8String], NULL, NULL, &error);
   }
   else
   {
      NSAssert(0, @"Table failed to create");
      NSLog(@"Account Table Not Created");
   }
   sqlite3_close(database);
 }

Insert Data

 + (void)insertAccountDetails:(NSString *)id:(NSString *)name
 {
     NSString *dbPath=[self databasePath];
     if(sqlite3_open([dbPath UTF8String],&database)==SQLITE_OK)
     {
       NSString *strQuery = [NSString stringWithFormat:@"INSERT into Account(id,name) values(?,?);"];
       if(sqlite3_prepare_v2(database,[strQuery UTF8String] , -1, &stment, NULL)==SQLITE_OK)
      {
            sqlite3_bind_text(stment, 1, [[self checkEmpty:id] UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(stment, 2, [[self checkEmpty:name] UTF8String] , -1, SQLITE_TRANSIENT);
            sqlite3_step(stment);
            sqlite3_reset(stment);
      }
      sqlite3_finalize(stment);
   }
   sqlite3_close(database);
}

Fetch or Get Data from Table

+ (void)getAccountDetails
{
  NSString *dbPath = [self databasePath];
  if (sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK)
  {
     NSString *query = [NSString stringWithFormat:@"SELECT id,name from Account"];
     if (sqlite3_prepare_v2(database, [query UTF8String], -1, &stment, nil) == SQLITE_OK)
     {
        while (sqlite3_step(stment) == SQLITE_ROW)
        {
            NSString *idString = [[self charToString: (char *)sqlite3_column_text(stment, 0)]base64DecodedString];
            NSString *nameString = [[self charToString: (char *)sqlite3_column_text(stment, 1)]base64DecodedString];
            NSMutableArray *arrayId = [[NSMutableArray alloc]init];
            NSMutableArray *arrayName = [[NSMutableArray alloc]init];
            [arrayId addObject:idString];
            [arrayName addObject:nameString];
          }
          sqlite3_reset(stment);
        }
        sqlite3_finalize(stment);
     }
     sqlite3_close(database);
}

Other Methods which called inside the db insert and fetch

insert

+ (NSString *)checkEmpty:(NSString *)check
{
  if([check isEqual:[NSNull null]])
    check = @" ";
  return check;
}

Fetch method

+ (NSString*)charToString:(const char*)chart
{
  NSString *string = @" ";
  if(string)
  {
    chart = [self checkEmptyChar:chart];
    string=[NSString stringWithUTF8String:chart];
  }
  return string;
}


 + (const char *)checkEmptyChar:(const char *)check
 {
   NSString *string = @" ";
   if (check == NULL)
     check = [string UTF8String];
   return check;
 }

thanks,your code is slove error : sqlite file not found.but when i use "dbPath" to read data from database it's really work on simulator but not thing happen on my iphone.
Now what happened?Did your data insert into db successfully?
i just select data,it work on simulator but not work on device

Collectives™ on Stack Overflow

Read data from existing sqlite.db is working on simulator but not actual device (Objective C)

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related