JPA Query 注意事项一

最新推荐文章于 2021-03-19 11:03:47 发布

zhanyingle_1981

最新推荐文章于 2021-03-19 11:03:47 发布

阅读量249

点赞数

分类专栏： Java 文章标签： JPA SQL Hibernate

Java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

1. 错误： org.hibernate.QueryParameterException: could not locate named parameter[incidentTime]

错误的语句：

String sql = "UPDATE SLIIncident o SET o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";
   Query query = em.createQuery(sql);

  query.setParameter("incidentTime", incident.getIncidentTime());
  query.setParameter("insertTime", incident.getInsertTime());
  query.setParameter("preEventTime", incident.getPreEventTime());
  query.setParameter("causeCode", incident.getCauseCode());
  query.setParameter("isDeleted", incident.getIsDeleted());
  query.setParameter("rawEventId", incident.getRawEventId());
  query.setParameter("sliId", incident.getSliId());

  query.executeUpdate();

原因：

query.setParameter set了不需要的字段，不知道往哪插了。

正确代码：

错误：

org.hibernate.hql.ast.ErrorCounter reportError- line 1:94: unexpected token: AND

java.lang.IllegalArgumentException: node to traverse cannot be null!

错误的语句：

//String sql = "UPDATE SLIIncident o SET o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";
  String sql = "UPDATE SLIIncident o SET o.incidentTime = :incidentTime AND o.insertTime = :insertTime AND o.preEventTime = :preEventTime AND o.causeCode = :causeCode AND o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";

  //String sql = "UPDATE SLIIncident o SET o.incidentTime = :incidentTime,o.insertTime = :insertTime, o.preEventTime = :preEventTime, o.causeCode = :causeCode, o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";

  Query query = em.createQuery(sql);

  query.setParameter("incidentTime", incident.getIncidentTime());
  query.setParameter("insertTime", incident.getInsertTime());
  query.setParameter("preEventTime", incident.getPreEventTime());
  query.setParameter("causeCode", incident.getCauseCode());
  query.setParameter("isDeleted", incident.getIsDeleted());
  query.setParameter("rawEventId", incident.getRawEventId());
  query.setParameter("sliId", incident.getSliId());

  query.executeUpdate();

原因：

同时更新多个字段时不需要AND，而应该是逗号，

正确代码：

    //String sql = "UPDATE SLIIncident o SET o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";
  //String sql = "UPDATE SLIIncident o SET o.incidentTime = :incidentTime AND o.insertTime = :insertTime AND o.preEventTime = :preEventTime AND o.causeCode = :causeCode AND o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";

  String sql = "UPDATE SLIIncident o SET o.incidentTime = :incidentTime,o.insertTime = :insertTime, o.preEventTime = :preEventTime, o.causeCode = :causeCode, o.isDeleted = :isDeleted WHERE o.rawEventId = :rawEventId AND o.sliId = :sliId";

  Query query = em.createQuery(sql);

  query.setParameter("incidentTime", incident.getIncidentTime());
  query.setParameter("insertTime", incident.getInsertTime());
  query.setParameter("preEventTime", incident.getPreEventTime());
  query.setParameter("causeCode", incident.getCauseCode());
  query.setParameter("isDeleted", incident.getIsDeleted());
  query.setParameter("rawEventId", incident.getRawEventId());
  query.setParameter("sliId", incident.getSliId());

  query.executeUpdate();