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 <zvasv...@gmail.com> 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 <ecforus...@gmail.com> 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 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

Reply via email to