JPA注解查询视图错误

@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，非此即错。