Thanks, I had already seen this article, but I am not really sure how I can call Activity methods in my DbAdapter, and I don't really want to return a cursor to my Activity - I just thought you may have some more magic code that would fix my problems ;o)
I will let you know how I get on... On 18 Jun 2010, at 14:43, Justin Anderson wrote: > Perhaps this will help: > http://stackoverflow.com/questions/2398209/how-to-handle-in-code-illegalstateexception-on-cursor > > BTW, I fond this by googling "Android IllegalStateException daemon" > > ---------------------------------------------------------------------- > There are only 10 types of people in the world... > Those who know binary and those who don't. > ---------------------------------------------------------------------- > > > On Fri, Jun 18, 2010 at 7:15 AM, Mikey <frak....@gmail.com> wrote: > The error is an IllegalStateException and as it is happening in this daemon > thread I have no idea where it is occurring. It is very weird as my > application has gone well past the point where it is using this query, and I > have a breakpoint on the catch block that is not reached. > > Very confusing. > > > On 18 Jun 2010, at 14:11, Justin Anderson wrote: > >> So what is the error and where is it occurring? >> >> ---------------------------------------------------------------------- >> There are only 10 types of people in the world... >> Those who know binary and those who don't. >> ---------------------------------------------------------------------- >> >> >> On Fri, Jun 18, 2010 at 5:02 AM, Mikey <frak....@gmail.com> wrote: >> Well, thanks - that seems to have done the trick, but now I am getting >> another error with another method - maybe you can tell me if you do things >> differently here as well? >> >> public boolean isPermanent(String screen_name) { >> boolean output = false; >> try { >> Cursor c = mDb.query(USERS, new String[] {CONSTANT}, >> SCREEN_NAME + "='" + screen_name + "'", null, null, null, null); >> if (c != null && c.getCount() > 0) { >> c.moveToFirst(); >> output = c.getString(0).contentEquals("C"); >> c.close(); >> } >> } >> catch (Exception e) { >> Log.e("DBERR", e.getMessage()); >> } >> return output; >> } >> >> What is really annoying is that the exception is not caught in my handler, >> but in the System Daemon thread :o/ >> >> regards, >> >> Mikey >> >> On 16 Jun 2010, at 21:38, Justin Anderson wrote: >> >>> Also, I use different methods in my while loop: >>> >>> Cursor dbCursor; >>> ... >>> dbCursor.moveToFirst(); >>> while (!dbCursor.isAfterLast()) >>> { >>> //do stuff >>> dbCursor.moveToNext(); >>> } >>> >>> >>> ---------------------------------------------------------------------- >>> There are only 10 types of people in the world... >>> Those who know binary and those who don't. >>> ---------------------------------------------------------------------- >>> >>> >>> On Wed, Jun 16, 2010 at 2:07 PM, Mikey <frak....@gmail.com> wrote: >>> Mostly desperation - I will give your idea a try though - thanks! >>> >>> Mikey >>> >>> On 16 Jun 2010, at 21:04, Justin Anderson wrote: >>> >>>> I'm not entirely sure, but I noticed my code is a little different than >>>> yours... >>>> >>>> Before I loop over the rows in the cursor I call moveToFirst(). So, with >>>> your code that would be c.moveToFirst() right before the while loop. I >>>> seem to remember having some weird issues with the Cursor class but >>>> haven't had any since I've made this change. >>>> >>>> Also, why are you setting c to null? There really is no point in doing >>>> that as the garbage collector will get called on you move out of c's >>>> scope... which happens as soon as you leave the try block. >>>> >>>> Thanks, >>>> Justin >>>> >>>> ---------------------------------------------------------------------- >>>> There are only 10 types of people in the world... >>>> Those who know binary and those who don't. >>>> ---------------------------------------------------------------------- >>>> >>>> >>>> On Wed, Jun 16, 2010 at 12:13 PM, Mikey <frak....@gmail.com> wrote: >>>> Hi, >>>> >>>> I am using a a Sqlite database in my application, but I am having a >>>> problem with it crashing (seemingly) randomly with the exception in >>>> Cursor. (I have been unable to recreate the error to give you the exact >>>> exception but it is something like the cursor being in an invalid state. >>>> >>>> I am using the cursor as follows: >>>> >>>> public ArrayList<String> fetchPermanent() { >>>> ArrayList<String> rows = new ArrayList<String>(); >>>> try { >>>> Cursor c = mDb.query(USERS, new String[] {SCREEN_NAME}, >>>> CONSTANT + "='C'", null, null, null, null); >>>> if (c != null && c.getCount() > 0) { >>>> while (!c.isLast()) { >>>> c.moveToNext(); >>>> rows.add(c.getString(0)); >>>> } >>>> c.close(); >>>> c = null; >>>> } >>>> } >>>> catch (Exception e) { >>>> Log.e("DBERR", e.getMessage()); >>>> } >>>> return rows; >>>> } >>>> >>>> Does anyone here have any idea what it is I am doing wrong? >>>> >>>> Mikey >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Android Beginners" group. >>>> >>>> NEW! Try asking and tagging your question on Stack Overflow at >>>> http://stackoverflow.com/questions/tagged/android >>>> >>>> To unsubscribe from this group, send email to >>>> android-beginners+unsubscr...@googlegroups.com >>>> For more options, visit this group at >>>> http://groups.google.com/group/android-beginners?hl=en >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Android Beginners" group. >>>> >>>> NEW! Try asking and tagging your question on Stack Overflow at >>>> http://stackoverflow.com/questions/tagged/android >>>> >>>> To unsubscribe from this group, send email to >>>> android-beginners+unsubscr...@googlegroups.com >>>> For more options, visit this group at >>>> http://groups.google.com/group/android-beginners?hl=en >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Android Beginners" group. >>> >>> NEW! Try asking and tagging your question on Stack Overflow at >>> http://stackoverflow.com/questions/tagged/android >>> >>> To unsubscribe from this group, send email to >>> android-beginners+unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/android-beginners?hl=en >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Android Beginners" group. >>> >>> NEW! Try asking and tagging your question on Stack Overflow at >>> http://stackoverflow.com/questions/tagged/android >>> >>> To unsubscribe from this group, send email to >>> android-beginners+unsubscr...@googlegroups.com >>> For more options, visit this group at >>> http://groups.google.com/group/android-beginners?hl=en >> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Android Beginners" group. >> >> NEW! Try asking and tagging your question on Stack Overflow at >> http://stackoverflow.com/questions/tagged/android >> >> To unsubscribe from this group, send email to >> android-beginners+unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/android-beginners?hl=en >> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Android Beginners" group. >> >> NEW! Try asking and tagging your question on Stack Overflow at >> http://stackoverflow.com/questions/tagged/android >> >> To unsubscribe from this group, send email to >> android-beginners+unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/android-beginners?hl=en > > > -- > You received this message because you are subscribed to the Google > Groups "Android Beginners" group. > > NEW! Try asking and tagging your question on Stack Overflow at > http://stackoverflow.com/questions/tagged/android > > To unsubscribe from this group, send email to > android-beginners+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/android-beginners?hl=en > > > -- > You received this message because you are subscribed to the Google > Groups "Android Beginners" group. > > NEW! Try asking and tagging your question on Stack Overflow at > http://stackoverflow.com/questions/tagged/android > > To unsubscribe from this group, send email to > android-beginners+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/android-beginners?hl=en -- You received this message because you are subscribed to the Google Groups "Android Beginners" group. NEW! Try asking and tagging your question on Stack Overflow at http://stackoverflow.com/questions/tagged/android To unsubscribe from this group, send email to android-beginners+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en
