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
