通过非原生sql启动项目报错:
@Query(value = "SELECT new cn.piesat.dataview.api.server.vo.ProductCountVO(t.productId , count(t.productId)) from ScheculeSinkDataRecord t where t.productId in ?1 GROUP BY t.productId")
List<ProductCountVO> countProductIds(String[] productIds);
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'productDataShowController': Unsatisfied dependency expressed through field 'scheduleSinkDataIndexService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'scheduleSinkDataRecordIndexServiceImpl': Unsatisfied dependency expressed through field 'dataSinkRecordDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSinkRecordDao': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List cn.piesat.dataview.api.server.dao.DataSinkRecordDao.countProductIds(java.util.List)!
之后改成原生sql报错:
@Query(value = "SELECT product_id as productId, count(product_id) as productCount from schedule_sink_data_record where product_id in (?1) GROUP BY product_id", nativeQuery = true)
List<ProductCountVO> countProductIds(String[] productIds);
org.springframework.orm.jpa.JpaSystemException: Unknown entity: javax.persistence.Tuple; nested exception is org.hibernate.MappingException: Unknown entity: javax.persistence.Tuple
最后把方法的泛型去掉就好了
@Query(value = "SELECT product_id as productId, count(product_id) as productCount from schedule_sink_data_record where product_id in (?1) GROUP BY product_id", nativeQuery = true)
List countProductIds(String[] productIds);