Connection pool has been unable to grant a connection to thread

android sqlite greendao
Basic Coder picture Basic Coder · Jul 31, 2012 · Viewed 22.2k times · Source

I'm using GreenDAO for database handling in Android. When performing many database changes (> 15.000) I get this error Message:

The connection pool for database '/data/data/...' has been unable to grant a connection to thread 312 (Thread-312) with flags 0x1 for 30.000002 seconds.

Everything gets stuck. Why does this error happen?

Answer

hkutluay picture hkutluay · Dec 26, 2012

I got this message when I want to select a query on a table which is used on a transaction without ended transaction before. Problem solved after executing endTransaction() on finally block of transaction.

Related questions

ORM performance: is greenDAO faster than ORMLite?

I've been using ORMLite in my application and I was considering whether to move to greenDAO. Performance is a huge part of that decision, and greenDAO's Features page says: For the same given entity, greenDAO inserts and updates entities over 2 …

Read More
How to clean/delete greenDao database

Currently I'm doing it like this: DaoMaster.dropAllTables(getDb(), true); DaoMaster.createAllTables(getDb(), true); but then, when I'm trying to add entity to the database, I'm getting crash log saying that this table isn't exist Edit1: I know that it …

Read More
SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More