Sqlite3 - working on simulator but not on device

[Skyman]

Hey Everyone,

I'm completely stuck, my app works just fine on the iphone simulator but when i try to run it on my ipod touch the database doesn't work.

I've confirmed that the file name is spell correctly. in fact I added AlertViews to see what exact path i wass using on both simulator and on the device. I know that simulator isn't case sensitive and the device is... but I can't see any spelling mistakes.

simulator :

Users/*********/Library/Application Support/iPhone Simulator/4.0/Aplications/*****-*****-****-****/Documents/data.sqlite3

device :

/var/mobile/Applications/********-****-****-****-********/Documents/data.sqlite3

I have no clue where to look.

[lukeca]

How are you getting that database to the documents folder in the first place?

[Skyman]

EDIT: I thought xcode would put the database there when I compile it? doesn't it?

The code to retreive the path is like this:

-(NSString *)dataFilePath
{
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDire ctory, NSUserDomainMask, YES);
NSString *documentsDirectory = [paths objectAtIndex:0];
return [documentsDirectory stringByAppendingPathComponent:kFileName];
}

Where kFileName is:

#define kFileName @"data.sqlite3"



It might be worth mentioning that I first noticed the problem after upgrading to sdk 4.0. I dunno

[lukeca]

Well because of the sandboxing that is present on the actual device you have to copy the database out of the app bundle and into the documents directory the first time you run the app.

Take a read through this tutorial, it explains what you need to do pretty well:
iPhone Programming Tutorial – Creating a ToDo List Using SQLite Part 1 | iCodeBlog

[Skyman]

Thanks for the quick reply. I'm going to try this out and message about the results tommorow. Though right now my code looks very similar to the example.

[chaseacton]

Originally Posted by Skyman

Thanks for the quick reply. I'm going to try this out and message about the results tommorow. Though right now my code looks very similar to the example.

Do a Build --> Clean All and see if maybe its a caching problem on the device.

[Skyman]

I'm embarrassed to say the solution was very very simple. I did not have the database properly imported into my project. So it was positioned correctly to compile for simulator but not when I compile it for my ipod touch device.

Thanks for all the help, and for the link to the guide.