JPQL
2016-02-19 16:25 yfye 阅读(1545) 评论(0) 编辑 收藏 举报关于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;