今天使用@Query自定义查询语句,出现了一个错误:

 java.lang.IllegalArgumentException: Parameter with that position [1] did not exist
at org.hibernate.jpa.spi.BaseQueryImpl.findParameterRegistration(BaseQueryImpl.java:502)
at org.hibernate.jpa.spi.BaseQueryImpl.setParameter(BaseQueryImpl.java:692)
at org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:181)
at org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:32)

原因是我再使用“?”占位符的时候,出现了错误,错误代码如下:

 @Query("SELECT id " +
"FROM AbcClass " +
"WHERE p2 like '%?1%'")
List<Integer> findP1ByP2(String p2);

“?”占位符应该是独立使用的,不能放在字符串中间的,上面的改正后就正常了:

 @Query("SELECT id " +
"FROM AbcClass " +
"WHERE p2 like ?1")
List<Integer> findP1ByP2(String p2);

备注:

查询条件对应的数据类型
=,<>,>,<,like等Integer,String
IN
Collection<?>
04-26 16:49
查看更多