2011/4/7 Evgeny Nacu <evgeny.n...@gmail.com> > Kostya, how many users do use your app? >
It's still in development, so about 30-50. > Cause my version works ok for me and for most my users. But some of > them keep getting such error. > Can you find out what those devices are? It might give you some further ideas. > > I think, this problem is related to some devices, not every. > Or, may be some very specific cases. > > Also, do your background threads use ContentProvider to insert/update > data? > They used to, not anymore. > Or just interface? > The UI is the only thing using the ContentProvider, but it does direct DB access as well. The worker threads are all direct DB access. Until recently, everything was CP based, and I was not getting that exception either. -- Kostya > > DanH, I don't get this exception every time (as Kostya said too), > so it's ok keeping Cursor open > > And, I'll try to do this with ContentProviders ) > > On 7 апр, 15:41, Kostya Vasilyev <kmans...@gmail.com> wrote: > > That's not what I'm seeing with my current project. > > > > My UI code uses a LiveView with a CursorAdapter, and has background > > threads that access and write to the database, sometimes using > > transactions, sometimes not. > > > > I've never seen a "database locked" exception, even when triggering a > > background thread to do its thing while I have a cursor-based ListView > > on the screen. > > > > One possible difference is that my ListView gets its cursor through a > > ContentProvider. > > > > Another possible difference is that my UI code and worker threads are > > all within the same process, and they all use the same SQLiteDatabase > > object, so the DB is only open once. > > > > -- Kostya > > > > 07.04.2011 15:17, DanH пишет: > > > > > > > > > > > > > > > > > > > > > The problem is that when you "hold the cursor open" the database is > > > locked. That feature is not really applicable to a multi-threaded SQL > > > environment. > > > > > On Apr 7, 1:01 am, Evgeny Nacu<evgeny.n...@gmail.com> wrote: > > >> > Hi again! > > > > >> > DanH, I use thread synchronization. It works well. > > >> > But, as I told in my first post, there are some problems: > > > > >> > The biggest problem: I can't use Cursor for my ListAdapter and > > >> > ExpandableListAdapter > > >> > I've got to use something like ArrayAdapter, read all data from > cursor > > >> > to java objects at one time. > > > > >> > But, as I understand, CursorAdapter works better cause it can hold > > >> > cursor open and scroll through cursor and read data when needed > > >> > It works faster for me. > > > > >> > So, also, here is new exception I've got today. > > >> > I retried to implement UI handling with Cursor. And I've got > > >> > SQLiteException: database is locked: BEGIN EXCLUSIVE; > > > > >> > Who knows how to handle it? > > > > -- > > Kostya Vasilyev --http://kmansoft.wordpress.com > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android-developers@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
