报错
@Query(nativeQuery = true, value = "select * from a, b where a.id=b.id and a.name=:name;") // 结尾不要加分号
List<IUserDetail> testParam(@Param("name") String name);
Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [name]
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:379)
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:72)
at com.extremelatitudesoftware.content.ArticleCommentFacade.getCommentByArticleCommentId(ArticleCommentFacade.java:293)
原因
原生 sql 语句后面加了分号导致的,把分号去掉即可,因为 SQL/HQL不需要以分号结束