{"id":942,"date":"2011-02-16T02:00:00","date_gmt":"2011-02-15T17:00:00","guid":{"rendered":"https:\/\/ecoop.net\/memo\/2011-02-16-2.html"},"modified":"2011-08-22T18:22:47","modified_gmt":"2011-08-22T09:22:47","slug":"2011-02-16-2","status":"publish","type":"post","link":"https:\/\/www.ecoop.net\/memo\/archives\/2011-02-16-2.html","title":{"rendered":"SQLiteException &#8211; file is encrypted or is not a database"},"content":{"rendered":"<p>\nSQLiteOpenHelper \u3067\u8868\u984c\u306e\u4f8b\u5916\u304c\u51fa\u3066\u3057\u307e\u3063\u305f\u306e\u3067\u5bfe\u7b56\u30e1\u30e2\u3002<br \/>\n&nbsp;LogCat:\n<\/p>\n<blockquote><p>02-22 17:26:58.351: ERROR\/Database(23305): Failed to setLocale() when constructing, closing the database<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305): android.database.sqlite.SQLiteException: file is encrypted or is not a database<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.native_setLocale(Native Method)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.setLocale(SQLiteDatabase.java:1751)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.&lt;init>(SQLiteDatabase.java:1701)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:739)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:761)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:754)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:497)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:193)<br \/>\n02-22 17:26:58.351: ERROR\/Database(23305):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:98)<br \/>\n\/\/ \u4ee5\u4e0b\u30a2\u30d7\u30ea\u5185\u306e getWritableDatabase() \u53c2\u7167\u7b87\u6240\u306b\u7d9a\u304f\n<\/p><\/blockquote>\n<p>\u539f\u56e0\u3092\u8abf\u3079\u305f\u3068\u3053\u308d\u3001\u3069\u3046\u3082SQLite\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u304c\u7834\u640d\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u63a5\u7d9a\u6642\u306b\u30a8\u30e9\u30fc\u306e\u6642\u306f\u30d5\u30a1\u30a4\u30eb\u3092\u30af\u30ea\u30a2\u3057\u3066\u518d\u63a5\u7d9a\u3059\u308b\u3088\u3046\u306b\u30aa\u30fc\u30d0\u30fc\u30e9\u30a4\u30c9\u5b9f\u88c5\u3057\u3066\u5bfe\u5fdc\u3057\u307e\u3057\u305f\u3002\n<\/p>\n<blockquote><p>@Override<br \/>\npublic synchronized SQLiteDatabase getWritableDatabase() {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return super.getWritableDatabase();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (SQLiteException e) {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;final File file = mContext.getDatabasePath(DATABASE_NAME);<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file.delete();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return super.getWritableDatabase();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br \/>\n}<br \/>\n&nbsp;<br \/>\n@Override<br \/>\npublic synchronized SQLiteDatabase getReadableDatabase() {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return super.getReadableDatabase();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} catch (SQLiteException e) {<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;final File file = mContext.getDatabasePath(DATABASE_NAME);<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file.delete();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return super.getReadableDatabase();<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br \/>\n}\n<\/p><\/blockquote>\n<p>\u53c2\u8003:<br \/>\n<a href=\"http:\/\/d.hatena.ne.jp\/esmasui\/20091103\/1257276598\">http:\/\/d.hatena.ne.jp\/esmasui\/20091103\/1257276598<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLiteOpenHelper \u3067\u8868\u984c\u306e\u4f8b\u5916\u304c\u51fa\u3066\u3057\u307e\u3063\u305f\u306e\u3067\u5bfe\u7b56\u30e1\u30e2\u3002 &nbsp;LogCat: 02-22 17:26:58.351: ERROR\/Database(23305): Failed to setLo &hellip; <a href=\"https:\/\/www.ecoop.net\/memo\/archives\/2011-02-16-2.html\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">SQLiteException &#8211; file is encrypted or is not a database<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[65,41],"class_list":["post-942","post","type-post","status-publish","format-standard","hentry","category-android-dev","tag-android","tag-sqlite"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/comments?post=942"}],"version-history":[{"count":0,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/942\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/media?parent=942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/categories?post=942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/tags?post=942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}