JPQL

关于JPQL中执行IN函数的问题:

 public List<ClaimPartyEntity> getPartyListForClaimantByCaseId(Long caseId){
  String sql="FROM ClaimPartyEntity WHERE caseId =:caseId and partyRole in(:partyRole)";
  TypedQuery<ClaimPartyEntity>  query=getEntityManager().createQuery(sql,
    ClaimPartyEntity.class);
  
  query.setParameter("caseId",Long.valueOf(caseId) );
  query.setParameter("partyRole", new String[]{ClaimCst.CLAIM_PARTY_ROLE_CLAIMANT,ClaimCst.CLAIM_PARTY_ROLE_POLICY_HOLDER,
    ClaimCst.CLAIM_PARTY_ROLE_BENEFICARY,ClaimCst.CLAIM_PARTY_ROLE_INSURED});
  
  List<ClaimPartyEntity> list=query.getResultList();
  return list;
 }

 query.setParameter用数组会报错如下：

Exception: Encountered array-valued parameter binding, but was expecting [java.lang.String]
java.lang.IllegalArgumentException: Encountered array-valued parameter binding, but was expecting [java.lang.Long]
at org.hibernate.ejb.AbstractQueryImpl.validateArrayValuedParameterBinding(AbstractQueryImpl.java:403)
at org.hibernate.ejb.AbstractQueryImpl.validateParameterBinding(AbstractQueryImpl.java:371)
at org.hibernate.ejb.AbstractQueryImpl.registerParameterBinding(AbstractQueryImpl.java:348)
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:446)
at org.hibernate.ejb.QueryImpl.setParameter(QueryImpl.java:72)
at org.yinxin.cms.dao.common.DefultBaseDao.executeJpql(DefultBaseDao.java:175)
at org.yinxin.cms.service.common.DefultBaseService.executeJpql(DefultBaseService.java:34)

 

需要换成集合类如下即可：

  String sql="FROM ClaimPartyEntity WHERE caseId =:caseId and partyRole in(:partyRole)";
  TypedQuery<ClaimPartyEntity>  query=getEntityManager().createQuery(sql,
    ClaimPartyEntity.class);
  
  List<String> partyRoleList = new ArrayList<>();
  partyRoleList.add(ClaimCst.CLAIM_PARTY_ROLE_CLAIMANT);
  partyRoleList.add(ClaimCst.CLAIM_PARTY_ROLE_POLICY_HOLDER);
  partyRoleList.add(ClaimCst.CLAIM_PARTY_ROLE_BENEFICARY);
  partyRoleList.add(ClaimCst.CLAIM_PARTY_ROLE_INSURED);
  
  query.setParameter("caseId",Long.valueOf(caseId) );
  query.setParameter("partyRole", partyRoleList);
  
  List<ClaimPartyEntity> list=query.getResultList();
  return list;

转载于:https://www.cnblogs.com/fengyingye/p/5201416.html