Actually, with a bit more reading, I have discovered that I need to use the SQLiteDatabase.NO_LOCALIZED_COLLATORS flag when calling SQLiteDatabase.openDatabase() - this no longer causes the problem.
Regards -- Brad. On 11/12/2008, Bradley Kite <[EMAIL PROTECTED]> wrote: > Hi fellow developers, > > I have created an SQLite database on another (non-android) system and > have transferred it to my SDCard so that my application can use its > data, however I have a problem where Android is expecting some custom > tables to exist, as when I call SQLiteDatabase.openDatabase() I get > the following exception: > > 12-11 16:49:49.107: ERROR/Database(241): SELECT locale FROM > android_metadata failed > 12-11 16:49:49.214: ERROR/Database(241): Failed to setLocale() when > constructing, closing the database > 12-11 16:49:49.214: ERROR/Database(241): > android.database.sqlite.SQLiteException: no such table: > android_metadata > 12-11 16:49:49.214: ERROR/Database(241): at > android.database.sqlite.SQLiteDatabase.native_setLocale(Native Method) > 12-11 16:49:49.214: ERROR/Database(241): at > android.database.sqlite.SQLiteDatabase.setLocale(SQLiteDatabase.java:1470) > 12-11 16:49:49.214: ERROR/Database(241): at > android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1424) > 12-11 16:49:49.214: ERROR/Database(241): at > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:537) > > I obviously need to create the android_metadata table within the > database before I can copy it to my android device, but does any one > know the schema of this table? > > Are there any other tables that I will need to create in order for > Android to be able to work with externally-created sqlite databases? > > Any help is much appreciated. > > Regards > > -- > Brad. > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---