Use a ContentProvider, together with an SQLiteOpenHelper wrapper around your database. Your activities will then never need to worry about opening or closing the database at all.
On Jul 22, 4:18 pm, ecforu <ecforus...@gmail.com> wrote: > But what's the reason for not keeping it open? Or actually a better > question is why do is my database dependent on an activity at all? These > are two totally different pieces to the puzzle (i.e. as in an MVC pattern or > similar design). > > On Wed, Jul 21, 2010 at 8: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<android-developers%2bunsubscr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en -- 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