How to handle the database in device?

Iamd eveloping one application.In that I used the sqlite datase.When iam running in simulator the data is saved in database.And there is no problem when iam retrieving th开发者_JAVA技巧at data.But when iam running in the device the process was killed at the time of retrieve the data.SO please tell me what i can do to solve this problem.

---

You should add sqlite file (blank or pre existing) in application bundle, and let the application know about its existance and copy it in Documents Directory:

 BOOL success;

NSArray*dirPath;
NSString*docDir;

dirPath=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
docDir=[dirPath objectAtIndex:0];
databasePath=[docDir stringByAppendingPathComponent:@"yourDB.sqlite"];


NSFileManager*filemgr=[NSFileManager defaultManager];

success=[filemgr fileExistsAtPath:databasePath];

if(success)
{
    NSLog(@"Already Present");
}

NSString* bundlePath=[[NSBundle mainBundle]pathForResource:@"yourDB" ofType:@"sqlite"];
NSError*error;
success=[filemgr copyItemAtPath:bundlePath toPath:databasePath error:&error];

if(success)
{
    NSLog(@"Created Successfully");
}