Error: Trying to requery an already closed cursor

Question

I'm running into an error but I can't seem to find a solution. My application is working on ICS 4.0.3 but it returns the error on Android 3.2. Here is the code in my `MainActivity.java` file: ``` SQLiteDatabase db = databaseHelper.getReadableDatabase(); Cursor cursor = db.query(DatabaseHelper.TABLE_NAME, new String[]{"_id","isim","icerik"}, null, null, null, null, null); startManagingCursor(cursor); tts=0; while(cursor.moveToNext()){ if(tts==0) { array_spinner=new String[cursor.getCount()+1]; array_spinner[tts]= "FAVORİ"; } array_spinner2[tts+1]= cursor.getString((cursor.getColumnIndex("isim"))); array_spinner3[tts+1]= cursor.getString((cursor.getColumnIndex("icerik"))); tts++; } ss2 = (Spinner) findViewById(R.id.spinner2); ArrayAdapter

Accepted Answer

Somewhere, you are closing the `Cursor` you are passing to `startManagingCursor()`. Call `stopManagingCursor()` before closing the `Cursor`. Note that `startManagingCursor()` is deprecated. Instead of using that, when your data changes, run another query in the background (e.g., `AsyncTask`, `CursorLoader`). Also, you might consider using a `CursorAdapter`, like `SimpleCursorAdapter`, rather than manually converting all of the data into objects and using an `ArrayAdapter`. Also, if you are going to use `ArrayAdapter`, please declare it with a more concrete class (e.g., `ArrayAdapter`, not `ArrayAdapter

Error: Trying to requery an already closed cursor

Solution

Problem