sqlite iphone connectivity check

Question

Hi All,

Is there any method available for checking the sqlite DB connectivity without calling

sqlite3_open([writableDBPath UTF8String], &database) == SQLITE_OK

everytime. We end up in database connection error after 120 continuous clicks.

Please help.

Answer 1

First, every sqlite3_open must be matched with a sqlite3_close before open is called with a pointer to that handle again. Otherwise you will have resource leaks, which I think you're experiencing.

Second, why are you repeatedly opening it to begin with?

Answer 2

You should call sqlite3_open just once. Then, if open operation was successful, store the database handle somewhere globally (i.e., in a class variable) and then just use that handle everytime you need to make a call to the database.