Hi,
I have a class that has different tabs, each that I want to access the same database. Each tab executes as a new intent, i.e. new Intent(MYCLASS.class). My question is where do I instantiate the database, and how can I get a cursor to it in the different tabs?

Thanks!

hm... i am using a singleton to handle my database connection... what about this pattern?

What Pattern?

the singleton pattern?

Oh woops I was confused by the wording. So create a static reference to the class in the parent class of the tabs. I thought about doing this, but thought it may run into problems because I would be changing the database between different tabs. I guess I could synchronize it....

I have a singleton for every table of my database. Each class has a static class variable which represent itself (this). Implementation like http://en.wikipedia.org/wiki/Singleton_pattern