Android手机通过fota升级后，apn数据库不会重新load的问题解决

Android手机通过fota升级后，apn数据库不会重新load的问题解决

问题描述

android手机通过fota升级，从A版本升级到B版本。在此过程中，修改了客户提供的apn参数，/system/etc/apns-conf.xml文件。但是手机通过fota升级后，发现手机apns数据库并没有重新load。必需要将fota升级后的手机恢复出厂设置才可以。

解决方案

为了避免恢复出厂设置的过程。可以修改apns数据库的版本号，通过
onUpgrade 来重新load数据库

public class TelephonyProvider extends ContentProvider@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {if (DBG) {log("dbh.onUpgrade:+ db=" + db + " oldV=" + oldVersion + " newV=" + newVersion);}TelephonyManager telePhonyManager = TelephonyManager.from(mContext);int numPhones = telePhonyManager.getPhoneCount();/*SUN:jicong.wang remove for apns update start {@for (int i = 0; i < numPhones; i++) {if(i ==0){db.execSQL("ALTER TABLE " + CARRIERS_TABLE + i +" RENAME TO " + CARRIERS_TABLE + ";");}else{db.execSQL("DROP TABLE " + CARRIERS_TABLE + i + ";");}}SUN:jicong.wang remove for apns update end @}*/if (oldVersion < (5 << 16 | 6)) {// 5 << 16 is the Database version and 6 in the xml version.// This change adds a new authtype column to the database.// The auth type column can have 4 values: 0 (None), 1 (PAP), 2 (CHAP)// 3 (PAP or CHAP). To avoid breaking compatibility, with already working// APNs, the unset value (-1) will be used. If the value is -1.// the authentication will default to 0 (if no user / password) is specified// or to 3. Currently, there have been no reported problems with// pre-configured APNs and hence it is set to -1 for them. Similarly,// if the user, has added a new APN, we set the authentication type// to -1.db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN authtype INTEGER DEFAULT -1;");oldVersion = 5 << 16 | 6;}if (oldVersion < (6 << 16 | 6)) {// Add protcol fields to the APN. The XML file does not change.db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN protocol TEXT DEFAULT IP;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN roaming_protocol TEXT DEFAULT IP;");oldVersion = 6 << 16 | 6;}if (oldVersion < (7 << 16 | 6)) {// Add carrier_enabled, bearer fields to the APN. The XML file does not change.db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN carrier_enabled BOOLEAN DEFAULT 1;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN bearer INTEGER DEFAULT 0;");oldVersion = 7 << 16 | 6;}if (oldVersion < (8 << 16 | 6)) {// Add mvno_type, mvno_match_data fields to the APN.// The XML file does not change.db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN mvno_type TEXT DEFAULT '';");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN mvno_match_data TEXT DEFAULT '';");oldVersion = 8 << 16 | 6;}if (oldVersion < (9 << 16 | 6)) {db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN sub_id INTEGER DEFAULT " +SubscriptionManager.INVALID_SUBSCRIPTION_ID + ";");oldVersion = 9 << 16 | 6;}if (oldVersion < (10 << 16 | 6)) {db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN profile_id INTEGER DEFAULT 0;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN modem_cognitive BOOLEAN DEFAULT 0;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN max_conns INTEGER DEFAULT 0;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN wait_time INTEGER DEFAULT 0;");db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN max_conns_time INTEGER DEFAULT 0;");oldVersion = 10 << 16 | 6;}if (oldVersion < (11 << 16 | 6)) {db.execSQL("ALTER TABLE " + CARRIERS_TABLE +" ADD COLUMN mtu INTEGER DEFAULT 0;");oldVersion = 11 << 16 | 6;}if (oldVersion < (12 << 16 | 6)) {try {// Try to update the siminfo table. It might not be there.db.execSQL("ALTER TABLE " + SIMINFO_TABLE +" ADD COLUMN " + SubscriptionManager.MCC + " INTEGER DEFAULT 0;");db.execSQL("ALTER TABLE " + SIMINFO_TABLE +" ADD COLUMN " + SubscriptionManager.MNC + " INTEGER DEFAULT 0;");} catch (SQLiteException e) {if (DBG) {log("onUpgrade skipping " + SIMINFO_TABLE + " upgrade. " +" The table will get created in onOpen.");}}oldVersion = 12 << 16 | 6;}if (oldVersion < (13 << 16 | 6)) {try {// Try to update the siminfo table. It might not be there.db.execSQL("ALTER TABLE " + SIMINFO_TABLE +" ADD COLUMN " + SubscriptionManager.CARRIER_NAME + " TEXT DEFAULT '';");} catch (SQLiteException e) {if (DBG) {log("onUpgrade skipping " + SIMINFO_TABLE + " upgrade. " +" The table will get created in onOpen.");}}oldVersion = 13 << 16 | 6;}if (DBG) {log("dbh.onUpgrade:- db=" + db + " oldV=" + oldVersion + " newV=" + newVersion);}db.delete(carriers_table, null, null);//modifyinitdatabase(db);//modify}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！