org.hibernate.query.sqm.ParsingException：无法解释dot-ident：brandId

Question

我正在学习Hibernate，但当我尝试使用Brandid进行筛选时，我不断得到以下错误：

这是我在mysql中的2个表

@Entity(name = "products")
@Table(name = "products")
public class ProductEntity {

@Id
@Column(name = "productId")
private int productId;

@ManyToOne(targetEntity = BrandEntity.class)
@JoinColumn()
private BrandEntity brandEntity;

@Column(name = "productname")
private String productName;

@Column(name = "category")
private String category;

@Column(name = "cost")
private double cost;

public ProductEntity() {
}

@Entity(name = "brands")
@Table(name = "brands")
public class BrandEntity {
    @Id
@Column(name = "brandId")
private Integer brandId;

@Column(name = "brandName")
private String brandName;

public BrandEntity() {
}

public class ProductDAO {

SessionFactory factory = new Configuration().configure("hibernate.cfg.xml").addAnnotatedClass(ProductEntity.class)
        .addAnnotatedClass(BrandEntity.class).buildSessionFactory();

public List<ProductEntity> getProductsByBrand(int brandId) {
    Session session = factory.getCurrentSession();
    session.beginTransaction();
    String stmt = "from products where brandId = " + brandId;
    List<ProductEntity> productList = session.createQuery(stmt).getResultList();
    return productList;
}

}

有人能告诉我我做错了什么吗

Answer 1

好了，我发现了问题所在，我使用了Hibernate-Core6 Alpha版本。我切换到5.4.12.final，所有的一切都在执行，没有任何问题