@Query(value = " SELECT NEW com.luok.domain.sumArticle(count(1) as articles,sum(cmd) as cmds ,sum(hits) as hits) FROM article WHERE classid=?1", nativeQuery = false)
sumArticle getSumArticle(Integer classid);
以下是调试过程中遇到的错误
1.把 nativeQuery = true 会报错:could not extract ResultSet
2.如果sum函数下的值为空,会报错:could not instantiate class [com.luok.domain.sumArticle] from tuple. 如果sum外层再包裹ifnull函数还是报错: Validation failed for query for method public abstract com.luok…getSumArticle(Integer classid)!
3.count和sum支持视图类sumArticle的参数数据类型为long,非此即错。