I am following this
http://efreedom.com/Question/1-3505900/SQLiteOpenHelper-OnUpgrade-Confusion-Android
What do u mean by saying "SQL open helper for all code paths"
I am using the standard code for
public void open() throws SQLException {
db = DBHelper.getWritableDatabase();
}
The open method is called for each database seperately.
On Fri, Oct 22, 2010 at 6:26 PM, Alok Kulkarni <[email protected]> wrote:
> Yeah ill do my best.. My code is too complicated right now... :P
> One more thing i need to confirm.. After upgrade , all the old
> databases are deleted right.. So i need to backup all the tables in
> the onUpgrade and recreate new ones .. Right ?
>
> On Fri, Oct 22, 2010 at 6:20 PM, Kostya Vasilyev <[email protected]> wrote:
>> Sounds like this could be it.
>>
>> Can't you just go through SQL open helper for all code paths?
>>
>> -- Kostya
>>
>> 22.10.2010 16:37, Alok Kulkarni пишет:
>>>
>>> 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<[email protected]>
>>> 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 [email protected]
>>>> To unsubscribe from this group, send email to
>>>> [email protected]
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/android-developers?hl=en
>>
>>
>> --
>> 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 [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]
>> 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en