Android Java中Room Dao无法解析表名符号问题求助

问题现象 #

在Android Java项目中使用Room框架编写查询所有数据的Dao方法时，Dao类无法解析表名items_table；更奇怪的是，两天前正常运行的另一Room项目也出现了相同问题。

相关代码及配置 #

实体类 #

package com.example.adapterapp.Entites;

import androidx.room.Entity;
import androidx.room.Index;
import androidx.room.PrimaryKey;

@Entity(tableName = "items_table")
public class RoomItem {

    @PrimaryKey(autoGenerate = true)
    private int itemId;

    private final String itemTitle;

    private final String itemSubtitle;

    private final String imageUri;

    public RoomItem(String itemTitle, String itemSubtitle, String imageUri) {
        this.itemTitle = itemTitle;
        this.itemSubtitle = itemSubtitle;
        this.imageUri = imageUri;
    }

    public int getItemId() {
        return itemId;
    }

    public String getItemTitle() {
        return itemTitle;
    }

    public String getItemSubtitle() {
        return itemSubtitle;
    }

    public String getImageUri() {
        return imageUri;
    }

}

Dao接口 #

package com.example.adapterapp.RoomDatabase;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
import androidx.room.Delete;
import androidx.room.Insert;
import androidx.room.Query;
import androidx.room.Update;

import com.example.adapterapp.Entites.RoomItem;

import java.util.List;

@Dao
public interface ItemDao {

    @Insert
    void insertItem(RoomItem roomItem);

    @Update
    void updateItem(RoomItem roomItem);

    @Delete
    void deleteItem(RoomItem roomItem);

    @Query("SELECT * FROM items_table")
    LiveData<List<RoomItem>> getAllItems();

}

数据库类 #

package com.example.adapterapp.RoomDatabase;

import android.content.Context;

import androidx.annotation.NonNull;
import androidx.room.Database;
import androidx.room.Room;
import androidx.room.RoomDatabase;
import androidx.sqlite.db.SupportSQLiteDatabase;

import com.example.adapterapp.Entites.RoomItem;

import java.util.concurrent.Executor;
import java.util.concurrent.Executors;

@Database(entities = RoomItem.class, version = 1)
public abstract class ItemDatabase extends RoomDatabase {

    private static ItemDatabase instance;

    public abstract ItemDao noteDao();

    public static synchronized ItemDatabase getInstance(Context context) {
        if (instance == null) {
            instance = Room.databaseBuilder(context.getApplicationContext(),
                    ItemDatabase.class, "items_database")
                    .fallbackToDestructiveMigration()
                    .addCallback(roomCallback)
                    .build();
        }
        return instance;
    }

    private static final RoomDatabase.Callback roomCallback = new RoomDatabase.Callback() {
        @Override
        public void onCreate(@NonNull SupportSQLiteDatabase db) {
            super.onCreate(db);
            new PopulateTaskRunner().executeAsync(new PopulateDatabaseTask(instance));
        }
    };

    private static class PopulateTaskRunner {
        private final Executor executor = Executors.newSingleThreadExecutor(); // change according to your requirements

        private void executeAsync(PopulateDatabaseTask populateDatabaseTask) {
            executor.execute(() -> {
                try {
                    populateDatabaseTask.itemDao.insertItem(new RoomItem("title: 1", "subtitle: 1", null));
                    populateDatabaseTask.itemDao.insertItem(new RoomItem("title: 2", "subtitle: 2", null));
                    populateDatabaseTask.itemDao.insertItem(new RoomItem("title: 3", "subtitle: 3", null));
                } catch (Exception e) {
                    e.printStackTrace();
                }
            });
        }
    }

    private static class PopulateDatabaseTask {

        private final ItemDao itemDao;

        private PopulateDatabaseTask(ItemDatabase itemDatabase) {
            this.itemDao = itemDatabase.noteDao();
        }
    }

}

依赖配置 #

dependencies {

    implementation 'androidx.appcompat:appcompat:1.4.2'
    implementation 'com.google.android.material:material:1.6.1'
    implementation 'androidx.constraintlayout:constraintlayout:2.1.4'
    testImplementation 'junit:junit:4.13.2'
    androidTestImplementation 'androidx.test.ext:junit:1.1.3'
    androidTestImplementation 'androidx.test.espresso:espresso-core:3.4.0'

    //lifecycle
    def lifecycle_version = "2.6.0-alpha01"
    implementation "androidx.lifecycle:lifecycle-viewmodel:2.5.0"
    implementation "androidx.lifecycle:lifecycle-livedata:2.5.0"
    implementation "androidx.lifecycle:lifecycle-common-java8:$lifecycle_version"

    //room database
    def room_version = "2.4.2"
    implementation "androidx.room:room-runtime:$room_version"
    annotationProcessor "androidx.room:room-compiler:2.4.2"

    //firebase
    // Import the BoM for the Firebase platform
    // When using the BoM, you don't specify versions in Firebase library dependencies
    implementation platform('com.google.firebase:firebase-bom:30.2.0')
    //implementation 'com.google.firebase:firebase-analytics'
    implementation 'com.google.firebase:firebase-firestore'
    implementation 'com.google.firebase:firebase-storage'
    implementation 'com.google.firebase:firebase-messaging'
    implementation 'com.google.firebase:firebase-auth'
}

问题截图 #

解决方案 #

1. 清理重建项目：执行Build -> Clean Project，再执行Build -> Rebuild Project。Room依赖注解处理器生成代码，缓存异常会导致表名无法被识别。
2. 重置IDE缓存：打开File -> Invalidate Caches...，选择Invalidate and Restart，解决IDE缓存引发的识别问题。
3. 统一依赖版本：当前lifecycle依赖混用了2.5.0和2.6.0-alpha01，建议统一为稳定版本（如2.5.0），避免版本冲突影响Room注解处理器工作：

   def lifecycle_version = "2.5.0"
   implementation "androidx.lifecycle:lifecycle-viewmodel:$lifecycle_version"
   implementation "androidx.lifecycle:lifecycle-livedata:$lifecycle_version"
   implementation "androidx.lifecycle:lifecycle-common-java8:$lifecycle_version"
   

4. 验证注解配置：确认Room的annotationProcessor依赖已正确添加，且版本与room-runtime完全一致（当前配置是正确的，但若之前有修改需再次核对）。
5. 检查实体关联：确认数据库类的@Database(entities = RoomItem.class, ...)已正确包含目标实体类，无拼写或路径错误。

内容的提问来源于stack exchange，提问作者A.Z