android.database.sqlite.SQLiteException:华为设备上无此类表错误

0vvn1miw  于 2023-02-10  发布在  Android
关注(0)|答案(1)|浏览(418)

请帮助我解决下面的错误,我只在华为设备上得到。我假设这些设备将数据库存储在其他地方...或者...?
错误信息:android.database.sqlite.SQLiteException:无此类表格:位置(Sqlite代码1 SQLITE_ERROR):,编译时:SELECT pl_web_id FROM放置ORDER BY pl_web_id描述限制1,(操作系统错误-2:没有此类文件或目录)
下面是我的DatabaseHelper类:

public class DataBaseHandler extends SQLiteOpenHelper {

// The Android's default system path of your application database.
private static String DB_PATH;

private static String DB_NAME = "GuessThePlace";
private static final int DATABASE_VERSION = 1;

private SQLiteDatabase myDataBase;

private final Context myContext;

public DataBaseHandler(Context context) {

    super(context, DB_NAME, null, 1);
    this.myContext = context;
    DB_PATH = context.getDatabasePath(DB_NAME).toString();
    // Log.e("path", DB_PATH);
}

// ==============================================================================

public void createDataBase() throws IOException {

    boolean dbExist = checkDataBase();

    if (dbExist) {
        // do nothing - database already exist
    } else {

        this.getReadableDatabase();

        try {

            copyDataBase();

        } catch (IOException e) {

            throw new Error("Error copying database");

        }
    }

}

// ==============================================================================

/**
 * Check if the database already exist to avoid re-copying the file each
 * time you open the application.
 * 
 * @return true if it exists, false if it doesn't
 */
private boolean checkDataBase() {

    SQLiteDatabase checkDB = null;

    try {
        String myPath = DB_PATH;
        checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);

    } catch (SQLiteException e) {

        // database does't exist yet.

    }

    if (checkDB != null) {

        checkDB.close();

    }

    return checkDB != null ? true : false;
}

// ==============================================================================

private void copyDataBase() throws IOException {

    // Open your local db as the input stream
    InputStream myInput = myContext.getAssets().open("database/" + DB_NAME);

    // Path to the just created empty db
    String outFileName = DB_PATH;

    // Open the empty db as the output stream
    OutputStream myOutput = new FileOutputStream(outFileName);

    // transfer bytes from the inputfile to the outputfile
    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer)) > 0) {
        myOutput.write(buffer, 0, length);
    }

    // Close the streams
    myOutput.flush();
    myOutput.close();
    myInput.close();

}

// ==============================================================================

public void openDataBase() throws SQLException {

    // Open the database
    String myPath = DB_PATH;
    myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);

}

// ==============================================================================

@Override
public synchronized void close() {

    if (myDataBase != null)
        myDataBase.close();

    super.close();

}

// ==============================================================================

@Override
public void onCreate(SQLiteDatabase db) {

}

// ==============================================================================

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

eufgjt7s

eufgjt7s1#

我也遇到了同样的问题。只在运行Android 9(API 28)的华为Y6 2019设备上报告过。我的解决方案是在复制数据库之前不调用"getReadableDatabase()"。

private boolean isReadableDatabaseNeeded() {
    final ArrayList<String> models = new ArrayList<>();

    if (Build.MANUFACTURER.equals("HUAWEI") && Build.VERSION.SDK_INT == Build.VERSION_CODES.P) {
        // These models are for HUAWEI Y6 2019 (marketing name)
        // Marketing name list: https://storage.googleapis.com/play_public/supported_devices.html
        models.add("MRD-LX1");
        models.add("MRD-LX1F");
        models.add("MRD-LX1N");
        models.add("MRD-LX3");

        if (models.contains(Build.MODEL)) {
            return false;
        }
    }

    return true;
}

public void createDataBase() throws IOException {
    boolean dbExist = checkDataBase();

    if (dbExist) {
        // do nothing - database already exist
    } else {
        if (isReadableDatabaseNeeded()) { 
            this.getReadableDatabase();
            this.close() // I had this too, and still not working
        }

        try {
            copyDataBase();
        } catch (IOException e) {
            throw new Error("Error copying database");
        }
    }
}

希望这个有用。

相关问题