此问题是收集别人遇到的:
原文见: http://bbs.csdn.net/topics/390286454?page=1#post-392965984
23 14:24:18.853 E/SQLiteDatabase(14233): Failed to open database '/data/data/com.example.androidproject51rc/databases/dictionary.db'.
10-23 14:24:18.853 E/SQLiteDatabase(14233): android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5): , while compiling: PRAGMA journal_mode
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.executeForString(SQLiteConnection.java:627)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.setJournalMode(SQLiteConnection.java:313)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.setWalModeFromConfiguration(SQLiteConnection.java:287)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:215)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:709)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.example.androidproject51rc.base.DBManager.openDatabase(DBManager.java:49)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.example.androidproject51rc.base.DBManager.GetSearchHistory(DBManager.java:88)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.example.androidproject51rc.JobSearchActivity.LoadDefaultInfo(JobSearchActivity.java:89)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.example.androidproject51rc.JobSearchActivity.onCreate(JobSearchActivity.java:65)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.Activity.performCreate(Activity.java:5008)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.ActivityThread.access$600(ActivityThread.java:130)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.os.Handler.dispatchMessage(Handler.java:99)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.os.Looper.loop(Looper.java:137)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at android.app.ActivityThread.main(ActivityThread.java:4745)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at java.lang.reflect.Method.invokeNative(Native Method)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at java.lang.reflect.Method.invoke(Method.java:511)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
10-23 14:24:18.853 E/SQLiteDatabase(14233): at dalvik.system.NativeStart.main(Native Method)
10-23 14:24:18.853 E/Exception(14233): android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5): , while compiling: PRAGMA journal_mode
10-23 14:24:18.853 D/AndroidRuntime(14233): Shutting down VM
10-23 14:24:18.853 W/dalvikvm(14233): threadid=1: thread exiting with uncaught exception (group=0x40d53300)
10-23 14:24:18.853 E/AndroidRuntime(14233): FATAL EXCEPTION: main
10-23 14:24:18.853 E/AndroidRuntime(14233): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.androidproject51rc/com.example.androidproject51rc.JobSearchActivity}: java.lang.NullPointerException
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2059)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread.access$600(ActivityThread.java:130)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.os.Handler.dispatchMessage(Handler.java:99)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.os.Looper.loop(Looper.java:137)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread.main(ActivityThread.java:4745)
10-23 14:24:18.853 E/AndroidRuntime(14233): at java.lang.reflect.Method.invokeNative(Native Method)
10-23 14:24:18.853 E/AndroidRuntime(14233): at java.lang.reflect.Method.invoke(Method.java:511)
10-23 14:24:18.853 E/AndroidRuntime(14233): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
10-23 14:24:18.853 E/AndroidRuntime(14233): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
10-23 14:24:18.853 E/AndroidRuntime(14233): at dalvik.system.NativeStart.main(Native Method)
10-23 14:24:18.853 E/AndroidRuntime(14233): Caused by: java.lang.NullPointerException
10-23 14:24:18.853 E/AndroidRuntime(14233): at com.example.androidproject51rc.base.DBManager.GetSearchHistory(DBManager.java:89)
10-23 14:24:18.853 E/AndroidRuntime(14233): at com.example.androidproject51rc.JobSearchActivity.LoadDefaultInfo(JobSearchActivity.java:89)
10-23 14:24:18.853 E/AndroidRuntime(14233): at com.example.androidproject51rc.JobSearchActivity.onCreate(JobSearchActivity.java:65)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.Activity.performCreate(Activity.java:5008)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
10-23 14:24:18.853 E/AndroidRuntime(14233): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
10-23 14:24:18.853 E/AndroidRuntime(14233): ... 11 more
解决方法:
问题已经解决了,直接贴源码把,原先的:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
//获取行业列表 public ArrayList<Industry> GetIndustryList(){
ArrayList<Industry> IndustryList= new ArrayList<Industry>();
SQLiteDatabase db=openDatabase();
db.beginTransaction();
Cursor cursor = db.rawQuery(
"select * from dcIndustry" ,
null );
while (cursor.moveToNext()){
IndustryList.add( new Industry(cursor.getString( 0 ),cursor.getString( 1 )));
}
db.close();
return IndustryList;
}
|
改正其实很简单,在db.close()前加db.endTransaction();就可以了
修正后:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
//获取行业列表 public ArrayList<Industry> GetIndustryList(){
ArrayList<Industry> IndustryList= new ArrayList<Industry>();
SQLiteDatabase db=openDatabase();
db.beginTransaction();
Cursor cursor = db.rawQuery(
"select * from dcIndustry" ,
null );
while (cursor.moveToNext()){
IndustryList.add( new Industry(cursor.getString( 0 ),cursor.getString( 1 )));
}
db.endTransaction();
db.close();
return IndustryList;
}
|
解决方法是在国外的某论坛找到的 原因是4.0以前的版本db.close();会结束事务,而Jelly Bean 以后的版本因为安全性的问题,必须结束即endTransactiony以后才能再次访问本地数据库。哎。。苦逼的百度啊。。另外,吐槽一下不向下兼容的Android
详细见:http://bbs.csdn.net/topics/390286454?page=1#post-392965984
相关推荐
解决sqlite死锁示例异常database is locked示例
Sqlite解决database locked问题
stm32 flash解锁,我的是开发板,在按键中断中解锁flash,具体的见源代码,使用ram.icf,把程序烧录在ram中,环境是IAR6.10,库版本是3.0,成功解决Core is locked-up问题。~
解决sqlite3 databaselocked 问题的代码实例,比较有参考价值。
如果多线程同时读写(这里的指不同的线程用使用的是不同的Helper实例),后面的就会遇到android.database.sqlite.SQLiteException: database is locked这样的异常。对于这样的问题,解决的办法就是keep single ...
:locked: 中等的 313 中等的 312 中等的 311 :locked: 中等的 310 中等的 309 中等的 308 :locked: 难的 307 中等的 306 中等的 305 :locked: 难的 304 中等的 303 简单的 302 :locked: 中等的 301 中等的 300 中等...
safe-android::locked_with_key:用于管理Gnosis Safe并与之互动的应用程序
Oracle; the account is locked
如果多线程同时读写(这里的指不同的线程用使用的是不同的Helper实例),后面的就会遇到android.database.sqlite.SQLiteException: database is locked这样的异常。对于这样的问题,解决的办法就是keep single ...
:locked: 简单的 ———— 2 :locked: 中等的 ———— 3 :locked: 中等的 ———— 4 :locked: 难的 ———— 5 :locked: 中等的 ———— 6 :locked: 中等的 ———— 7 :locked: 简单的 ———— 8 :locked: 中等...
:locked: 中等的 1235 难的 1234 中等的 1233 中等的 1232 简单的 1231 :locked: 难的 1230 :locked: 中等的 1229 :locked: 中等的 1228 :locked: 简单的 1227 中等的 1226 中等的 1225 :locked: 难的 1224 难的 ...
leetcode 2 和 c 编码挑战 编码实践和挑战的解决方案。 力码 (笔记: :locked: ...解决方案 ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked: ...:locked:
在开发android的应用中,有时候需要限制横竖屏切换。只需要在AndroidManifest.xml文件中加入android:screenOrientation属性限制。ndroid:screenOrientation=”landscape”是限制此页面横屏显示, ndroid:...
LeetCode Problems的解决方案[∙主题] # 标题解困难1740 :locked:简单1739硬1738中1737中1736简单1735硬1734中1733中1732简单1731 :locked: 简单1730 :locked:中1729 :locked: 简单1728硬1727中1726中1725简单1724 ...
hidden-secrets-gradle-plugin::locked:在Android上深度隐藏秘密
锁定::locked:只做一件事的MacOS应用程序->锁定Mac
Gradle插件可深度隐藏Android上的秘密键Gradle插件可深度隐藏Android上的秘密此插件允许任何Android开发人员深度隐藏其项目中的秘密。 它与DexGuard可以提供的OSS等效,可以防止凭据收集。 它使用混淆技术的组合来...
语言:English (United States) ...:key::locked::key::locked::key::locked::key::locked::key::locked::key::locked::key::locked::key::locked:。只有在您的付款才能将插件显示给您的安全消息否则相应的端口是假的
pr_comment_interceptor::locked:
生物识别 最简单的方法是在下使用新版本的 。 您可以轻松知道该设备是否允许您使用生物特征识别以及使用哪种类型(面部,... BiometricType = biometricHelper.getBiometricType()// Check if biometric is availabl