Thanks Mark, you have always been a charm! Thanks Larry, that was new info.
So, what I take from your answers is that I can open a (Helper) connection at start of the application and close it at the application close, using the same connection for getting Readable and Writable db instances? And maintain different instance of Helper (each) for every service (cos they keep running, irrespective of the visible app, DUH!)? Please correct me if I am wrong. Thanks again! Regards, Saurav Mukherjee. Twitter <https://twitter.com/#!/fasuke> Facebook <https://www.facebook.com/fuusuke> On Thu, Mar 7, 2013 at 8:52 PM, Larry Meadors <larry.mead...@gmail.com>wrote: > Just be careful closing the database - if you have multiple threads > sharing an instance of a single SQLiteOpenHelper, the SQLiteDatabase > mDatabase isn't like a jdbc connection pool. > > If you close it fron one thread, it's closed for real. > > ...and of course, if you don't close it, it whines. > > Larry > > > On Thu, Mar 7, 2013 at 8:07 AM, Mark Murphy <mmur...@commonsware.com> > wrote: > > On Thu, Mar 7, 2013 at 9:54 AM, Saurav <to.saurav.mukher...@gmail.com> > wrote: > >> How many SQLiteOpenHelper instances should be created? Should there be > just > >> one and should it be reused? > > > > Ideally, yes, particularly if you are planning on accessing the > > database from multiple threads. One SQLiteOpenHelper instance means > > one SQLiteDatabase instance, and SQLiteDatabase is designed to manage > > operations from multiple threads. > > > > -- > > Mark Murphy (a Commons Guy) > > http://commonsware.com | http://github.com/commonsguy > > http://commonsware.com/blog | http://twitter.com/commonsguy > > > > _The Busy Coder's Guide to Android Development_ Version 4.6 Available! > > > > -- > > -- > > 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 > > --- > > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to android-developers+unsubscr...@googlegroups.com. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > -- > 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 > --- > You received this message because you are subscribed to the Google Groups > "Android Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to android-developers+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- 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 --- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
