I still see this error when using a ListView even though I have it set
to close and clean up the connection when leaving the view, can't do
it right away or the ListView won't work.

Any way around this?

On Jul 21, 7:29 pm, Zsolt Vasvari <[email protected]> wrote:
> I never keep an actualy SQLiteDatabase object around ever.  In all my
> activities, I create a helper object and obtain the SQLDatabase object
> which I keep around throwing away the helper object.  And I make sure
> that I close the database in my activities' onDestroy method.
>
> On Jul 22, 4:07 am, ecforu <[email protected]> wrote:
>
> > Do I need an instance of my SQLiteOpenHelper class for each Activity I have?
> >  I have 1 currently that all activities access, but started getting an
> > exception
>
> > "illegal state exception SQLiteDatabase created and never closed "
>
> > on simple a simple query and I can't seem to figure out why this is
> > happening.  I read online about this, and wanted to try to understand why
> > the SQLiteOpenHelper was dependent on an Activity.
>
> > Is there a way to just have open SQLiteDatabase object without the Helper
> > and have it just exist within all activities?
>
> > Thanks

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to