On Tue, Oct 11, 2011 at 6:13 AM, Zsolt Vasvari <zvasv...@gmail.com> wrote: > The only problem is that the datrabase is never closed. But this is > more of a pedentic observation as there seems to be no real side > effects.
Yeah, content providers suffer from the same issue. I fought and fought against singleton databases and content providers, trying to find a way to close the database, and eventually surrendered. If you're really paranoid about it, you might rig up some sort of inactivity timer that closes the database, and organize your singleton to lazy-open the database if needed. This isn't a guarantee that it'll get closed, though, as Android could terminate the process first. Having multiple SQLiteDatabase objects is fine if (and only if) you're only using them from one thread at a time via your own synchronization. Or if you're accessing the databases on the main application thread, like some balding guy I know has in one of his books that's scheduled for an overhaul in 2012... :-) > I do wish there were a onDestory() on the Application object > so I could close the databases before Android terminates my app, but > alas, there isn't. Well, there is onTerminate(), but it's never used. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Training...At Your Office: http://commonsware.com/training -- 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