Short answer; Your database object (db) is in the wrong scope.
Longer answer; By declaring db in the method you're saying to the JVM
that when the method finishes your database connection (db) is no
longer useful. What you should do is declare db at the class level
instead of the method level, create it in onCreate, and close it in
onDestroy.
Al.
On Jul 2, 3:06 am, Christopher Perry <mr.christopher.pe...@gmail.com>
wrote:
> I have a ListActivity that uses a CursorAdapter to fill the rows in
> the view. I wrote a database helper class that gives me back results
> for common queries I make for my app, and it uses an SQLiteOpenHelper
> implementation I wrote to open the database. I use the open helper to
> open the database and get a cursor to pass to my CursorAdapter. Here's
> a code snippet:
>
> public static Cursor getCursor(DbOpenHelper openHelper) {
> SQLiteDatabase db = openHelper.getWritableDatabase();
> db.beginTransaction();
> Cursor c = null;
> try {
> String sql = "select * from " + TABLE_NAME;
> c = db.rawQuery(sql, null);
> db.setTransactionSuccessful();
> } catch (SQLException e) {
> Log.e("Exception on query", e.toString());
> } finally {
> db.endTransaction();
> }
>
> return c;
> }
>
> The problem I'm having, that I didn't have before I implemented the
> open helper (before I just opened the database directly without a
> helper), is when I click on an item, which takes me to another
> activity, and then go back to this activity. When it initializes
> everything is fine, and my list is populated fine, but when I go back
> from the activity that follows, the list is empty and in the LogCat I
> see "Invalid statement in fillWindow()".
>
> It appears from a few post I've seen that the reason is, when I
> requery the cursor, the database is closed. But I'm not closing it!
> I'm scratching my head on this one.
--
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
