public interface TimeContentRepository extends JpaRepository<TimeContent,String> {
@Query(value = "select id,user_id as userId,create_time as createTime " +
"from time_content where create_time = ?1 and user_id = ?2")
List<TimeContent> findOnDay(String create_time,String userId);
}
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: time_content is not mapped
-
注解中写的是HQL,所以查询的是对象,而不是表名
-
改为
public interface TimeContentRepository extends JpaRepository<TimeContent,String> {
@Query(value = "select id,user_id as userId,create_time as createTime " +
"from TimeContent where create_time = ?1 and user_id = ?2")
List<TimeContent> findOnDay(String create_time,String userId);
}
Caused by: org.hibernate.QueryException: No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode
+-[IDENT] IdentNode: 'user_id' {originalText=user_id}
- 同样的问题,查询的字段也是对象的成员,不是表的字段