CODEWITHSUNDEEP
iossqldatabasesqlitecore-data
Sagar S. Kadookkunnan
Sagar S. Kadookkunnan

Reputation: 673

Unable to open sql store file used in iOS application

I am using a sql based database in one of my application with Core Data framework. I have not enabled any file protection for persistent store (using NSFileProtectionKey). But I am unable to open my database file store in a directory under 'Caches' folder in Library.

Have you ever come across such an issue. Below is the image I am getting when I try to open the sql file. However, a difference from iOS 6 I could see in that folder is there are two additional files (-shm and -wal) present with the same name of the sql store file.

enter image description here

Could anyone please help me to find a solution to open the file.

Upvotes: 0

Views: 381

Answers (1)

Hal Mueller
Hal Mueller

Reputation: 7655

The -shm and -wal are journal files created using write-ahead logging. You need all 3 files for a complete database. I haven't seen an encryption error falsely triggered by not obeying this rule, but it doesn't seem out of the question.

See https://developer.apple.com/library/mac/qa/qa1809/_index.html and http://asciiwwdc.com/2013/sessions/207.

Upvotes: 1

Related Questions