iPhone模拟器中无法解释的EXC_BAD_ACCESS-InexplicableEXC_BAD_ACCESSintheiPhonesimulator

1  

Have you checked the contents of the databasePath variable before the open call is made? Add an NSLog statement, or use the debugger, to find its value – it could be either NULL, which may not be handled by the sqlite3_open function, or it could even be that the crash is because the path is valid, and the database it points to is corrupt.

在打开调用之前，您是否检查了databasePath变量的内容？添加一个NSLog语句，或者使用调试器来查找它的值 - 它可能是NULL，可能是sqlite3_open函数无法处理的，或者甚至可能是因为路径有效而崩溃，而数据库是指向腐败。

1  

My guess is that the database variable is not declared properly. It doesn't seem to have anything to do with the path to the database.

我的猜测是数据库变量未正确声明。它似乎与数据库的路径没有任何关系。

Did you declare database like this?:

你这样声明了数据库吗？：

sqlite3 *database;

1  

I suspect you are chasing the wrong problem. You haven't shown a crash dump but claim that opening "APPLES!" is 'fine' which sounds odd - surely you don't have a database with that name?

我怀疑你正在追逐错误的问题。您没有显示崩溃转储但声称打开“APPLES！”是'很好'听起来很奇怪 - 当然你没有这个名字的数据库？

Are you sure you don't have a bad database file lying around - ie, the database file you are trying to open is corrupted in some way?

您确定没有错误的数据库文件 - 即，您尝试打开的数据库文件是否以某种方式损坏？

1  

I think you have to post the crash log, your crash makes no sense. The code you posted should work.

我认为你必须发布崩溃日志，你的崩溃毫无意义。您发布的代码应该有效。

0  

Try a copy instead of a retain on the variable - it'll make an immutable copy of the string so it shouldn't go changing or disappearing.

尝试复制而不是保留变量 - 它将生成字符串的不可变副本，因此它不应该改变或消失。

EDIT::

编辑：：

What happens when you simply type

只需键入即会发生什么

if (sqlite3_open[@"myDatabase.sqlite" UTF8String], &database) == SQLITE_OK) {

Also are you sure that the

你还确定吗？

NSArray * documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
databasePath = [[[documentPaths objectAtIndex:0]
stringByAppendingPathComponent:@"Database.sql"] retain];

is actually returning where the database is?

实际上是返回数据库所在的位置？

The code I use to grab the database from the app directory where kFilename is the database file is:

我用来从app目录中获取数据库的代码是kFilename是数据库文件：

- (NSString *)dataFilePath{

    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];

    return [documentsDirectory stringByAppendingPathComponent:kFilename];
}

and then to use it I do:

然后使用它我做：

if(sqlite3_open([[self dataFilePath] UTF8String], &database) != SQLITE_OK){

This works on both my iPod touch and the iPhone simulator.

这适用于我的iPod touch和iPhone模拟器。

EDIT2::

EDIT2 ::

I've just used your above method and it seems to work here - I know it sounds stupid but have you tried rebooting? Its possible something strange is happening with the simulator

我刚刚使用了你的上述方法，它似乎在这里工作 - 我知道它听起来很愚蠢，但你尝试重启吗？它可能在模拟器中发生了奇怪的事情