[android-developers] Re: SQLite Database Issues

Hi, still randomly see that the DB does not recognize one of my
tables. The table is shipped along with the database and unlike others
is not modified at any time. I can also see through my own tests that
the way I open the database has a great impact on this.

What is the recommended way to open the DB, considering that I will
write on it?

SQLiteDatabase.openDatabase(myPath, null,
SQLiteDatabase.OPEN_READWRITE);
SQLiteDatabase.openDatabase(myPath, null,
SQLiteDatabase.NO_LOCALIZED_COLLATORS);
this.getWritableDatabase();

the latest is working more reliable for me so far...

Thanks in advance.

On Oct 15, 3:45 pm, Albert <albert8...@googlemail.com> wrote:
> > I have an app that does something similar and the way I ensure that
> > the copy is finished is that I have a special end-of-load (EOL) record
> > that goes into the table as the last item. My app does a select for
> > that EOL record each time it's launched. If the table isn't created
> > yet or the EOL is missing then the app puts up a screen asking the
> > user to wait a moment.
>
> That's a very good idea. Thanks for the tip.
>
> I have setup Acra (Error reporting) and I send myself reports when I
> catch this exception, I see it happening with some users but I know
> the table is there because next time the user tries the table with the
> records are all good. I managed to get an user to send me the log and
> I verified this.

--
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+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en