No. Actually i am accessing another table from my databases at the same time from another thread while onUpgrade is being called.So i think thats where the problem lies.But i need to figure out a way so that i access the SQL tables after the on Upgrade function completes.
On Fri, Oct 22, 2010 at 5:58 PM, Kostya Vasilyev <kmans...@gmail.com> wrote: > AFAIK, there is nothing special, except: > > - onUpgrade may take some time to run > - the tables are not updated until after onUpgrade is done > > Are you accessing the database in any way bypassing your SQL open helper? > > Is this what you mean by " > > At the start of the application , > i initialize all the databases and access columns from the required > tables > > " > ? > > If you're relying on SQL open helper and its onUpgrade, then that should be > the only way you're accessing the database. > > -- Kostya > > 22.10.2010 15:14, Alok Kulkarni пишет: >> >> Hi, >> I have multiple databases in my app.At the start of the application , >> i initialize all the databases and access columns from the required >> tables.What i did is , for one of the databases i incremented the >> version of the DB. So now i have started getting error of " No Such >> table say ABCD while compiling " query.This table is in another DB >> than the updated DB. I dont have any code in the onUpgrade right now.. >> Is there any thing thats striking anyone why this behavior is >> happening? Is there anything that happens in the onUpgrade method that >> causes all the DBs to be inaccessable temporarily. I am saying this >> because if i place a breakpoint in onUpgrade and debug , then i wait >> for a few seconds on the 1st stmt in onUpgrade and then everything >> works fine... >> > > > -- > Kostya Vasilyev -- WiFi Manager + pretty widget -- > http://kmansoft.wordpress.com > > -- > 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 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