Android Database 并行访问 SQLiteDatabaseLockedException: database is locked 解决方案
来源:互联网 发布:淘宝小蜜在哪里 编辑:程序博客网 时间:2024/05/12 16:08
Android Database 并行访问
分类: android技术 2014-03-26 17:30 73人阅读 评论(1)收藏举报
1、假设你已经有了自己的SQLiteOpenHelper实例
- public class DatabaseHelper extends SQLiteOpenHelper { ... }
public class DatabaseHelper extends SQLiteOpenHelper { ... }
2、现在你需要在不同的线程中写数据库
- // Thread 1
- Context context = getApplicationContext();
- DatabaseHelper helper = new DatabaseHelper(context);
- SQLiteDatabase database = helper.getWritableDatabase();
- database.insert(…);
- database.close();
- // Thread 2
- Context context = getApplicationContext();
- DatabaseHelper helper = new DatabaseHelper(context);
- SQLiteDatabase database = helper.getWritableDatabase();
- database.insert(…);
- database.close();
// Thread 1 Context context = getApplicationContext(); DatabaseHelper helper = new DatabaseHelper(context); SQLiteDatabase database = helper.getWritableDatabase(); database.insert(…); database.close(); // Thread 2 Context context = getApplicationContext(); DatabaseHelper helper = new DatabaseHelper(context); SQLiteDatabase database = helper.getWritableDatabase(); database.insert(…); database.close();
执行后,得到错误
- android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5)
android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5)
错误的原因:每次new SQLiteOpenHelper的时候,实质上是创建一个Database Connection。如果在不同的Connection同时写数据库,其中一个就会Failed。
如果在多个线程中使用数据库,需要确保使用同一个Database Connection。
3、为了解决第二个问题,我们去创建一个DatabaseManager类,通过单例去获取SQLiteOpenHelper的对象。
- public class DatabaseManager {
- private static DatabaseManager instance;
- private static SQLiteOpenHelper mDatabaseHelper;
- public static synchronized void initialize(Context context, SQLiteOpenHelper helper) {
- if (instance == null) {
- instance = new DatabaseManager();
- mDatabaseHelper = helper;
- }
- }
- public static synchronized DatabaseManager getInstance() {
- if (instance == null) {
- throw new IllegalStateException(DatabaseManager.class.getSimpleName() +
- " is not initialized, call initialize(..) method first.");
- }
- return instance;
- }
- public synchronized SQLiteDatabase getDatabase() {
- return new mDatabaseHelper.getWritableDatabase();
- }
- }
public class DatabaseManager { private static DatabaseManager instance; private static SQLiteOpenHelper mDatabaseHelper; public static synchronized void initialize(Context context, SQLiteOpenHelper helper) { if (instance == null) { instance = new DatabaseManager(); mDatabaseHelper = helper; } } public static synchronized DatabaseManager getInstance() { if (instance == null) { throw new IllegalStateException(DatabaseManager.class.getSimpleName() + " is not initialized, call initialize(..) method first."); } return instance; } public synchronized SQLiteDatabase getDatabase() { return new mDatabaseHelper.getWritableDatabase(); }}4、那么现在第二步中的功能,应该这样去实现
- // In your application class
- DatabaseManager.initializeInstance(getApplicationContext());
- // Thread 1
- DatabaseManager manager = DatabaseManager.getInstance();
- SQLiteDatabase database = manager.getDatabase()
- database.insert(…);
- database.close();
- // Thread 2
- DatabaseManager manager = DatabaseManager.getInstance();
- SQLiteDatabase database = manager.getDatabase()
- database.insert(…);
- database.close();
// In your application class DatabaseManager.initializeInstance(getApplicationContext()); // Thread 1 DatabaseManager manager = DatabaseManager.getInstance(); SQLiteDatabase database = manager.getDatabase() database.insert(…); database.close(); // Thread 2 DatabaseManager manager = DatabaseManager.getInstance(); SQLiteDatabase database = manager.getDatabase() database.insert(…); database.close();执行后,得到错误
- java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase
java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase
因为我们使用同一个Database Connection,所以Thread1和Thread2使用的是同一个实例。现在Thread1关闭了Connection,但是Thread2却仍然在用。
所以,我们在关闭Connection之前需要确保没有线程在使用这个Connection。一个解决方案是永远的不去关闭Connection,但是在Logcat里面会出现如下的消息:
- Leak found
- Caused by: java.lang.IllegalStateException: SQLiteDatabase created and never closed
Leak foundCaused by: java.lang.IllegalStateException: SQLiteDatabase created and never closed
5、我们可以使用AtomicInteger处理这种并发操作
- public class DatabaseManager {
- private AtomicInteger mOpenCounter = new AtomicInteger();
- private static DatabaseManager instance;
- private static SQLiteOpenHelper mDatabaseHelper;
- private SQLiteDatabase mDatabase;
- public static synchronized void initializeInstance(SQLiteOpenHelper helper) {
- if (instance == null) {
- instance = new DatabaseManager();
- mDatabaseHelper = helper;
- }
- }
- public static synchronized DatabaseManager getInstance() {
- if (instance == null) {
- throw new IllegalStateException(DatabaseManager.class.getSimpleName() +
- " is not initialized, call initializeInstance(..) method first.");
- }
- return instance;
- }
- public synchronized SQLiteDatabase openDatabase() {
- if(mOpenCounter.incrementAndGet() == 1) {
- // Opening new database
- mDatabase = mDatabaseHelper.getWritableDatabase();
- }
- return mDatabase;
- }
- public synchronized void closeDatabase() {
- if(mOpenCounter.decrementAndGet() == 0) {
- // Closing database
- mDatabase.close();
- }
- }
- }
public class DatabaseManager { private AtomicInteger mOpenCounter = new AtomicInteger(); private static DatabaseManager instance; private static SQLiteOpenHelper mDatabaseHelper; private SQLiteDatabase mDatabase; public static synchronized void initializeInstance(SQLiteOpenHelper helper) { if (instance == null) { instance = new DatabaseManager(); mDatabaseHelper = helper; } } public static synchronized DatabaseManager getInstance() { if (instance == null) { throw new IllegalStateException(DatabaseManager.class.getSimpleName() + " is not initialized, call initializeInstance(..) method first."); } return instance; } public synchronized SQLiteDatabase openDatabase() { if(mOpenCounter.incrementAndGet() == 1) { // Opening new database mDatabase = mDatabaseHelper.getWritableDatabase(); } return mDatabase; } public synchronized void closeDatabase() { if(mOpenCounter.decrementAndGet() == 0) { // Closing database mDatabase.close(); } }}最后,我们这样使用就可以实现安全的数据库并发操作
- SQLiteDatabase database = DatabaseManager.getInstance().openDatabase();
- database.insert(...);
- // database.close(); Don't close it directly!
- DatabaseManager.getInstance().closeDatabase(); // correct way
SQLiteDatabase database = DatabaseManager.getInstance().openDatabase();database.insert(...);// database.close(); Don't close it directly!DatabaseManager.getInstance().closeDatabase(); // correct way
http://blog.csdn.net/droid_zhlu/article/details/22194437
0 0
- Android Database 并行访问 SQLiteDatabaseLockedException: database is locked 解决方案
- Android SQLiteDatabaseLockedException: database is locked
- Android SQLiteDatabaseLockedException: database is locked
- 解决android: SQLiteDatabaseLockedException: database is locked
- SQLiteDatabaseLockedException: database is locked 解决方法
- android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5)
- android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5)问题解决
- android.database.sqlite.SQLiteDatabaseLockedException: database is locked (code 5): , while compilin
- android.database.sqlite.SQLiteException: database is locked
- Android Database 并行访问
- Android Database 并行访问
- Android Database 并行访问
- sqlite database is locked
- svn database is locked
- SVN database is locked
- sqlite database is locked
- database is locked
- SQLite并发访问出现The database file is locked , database is locked
- QStringLiteral
- secureCRT中让vim高亮显示
- linux内核基本数据类型总结
- hdu 4500 小Q系列故事——屌丝的逆袭
- 使用WNMP在windows下搭建Nginx+MariaDB+PHP
- Android Database 并行访问 SQLiteDatabaseLockedException: database is locked 解决方案
- R语言检测数据正态分布
- Java实现定时任务的三种方法
- 你必须知道的#if DEBUG
- android 自定义控件 使用declare-styleable进行配置属性(源码角度)
- xheditor编辑器
- iOS 7系列译文:认识 TextKit
- spring mvc url映射
- 杭电 2084 数塔