如何修复：将结果集映射到返回类型时引发错误

Question

  @SqlUpdate(
      "UPDATE task_sync SET "
          + " is_active = false, "
          + " version = version+1 "
          + " WHERE task_id IN (<taskIdList>) "
          + " AND barcode IN (<barcodeList>) "
          + " AND is_active = true ")
  @GetGeneratedKeys("id")
  List<Long> deactivateTaskSyncByTaskIdInAndBarcodeList(
      @BindList("taskIdList") List<Long> taskIdList,
      @BindList("barcodeList") Set<String> barcodeList,
      @Bind("lastUpdatedById") Long lastUpdatedById);

UPDATE task_sync SET  is_active = false,  version = version+1  WHERE task_id IN (26)  AND barcode IN ('8606850380_0', '8696930120_0', '6907922280_0', '4605723180_0', '2354050010_0', '5259987660_0', '6392185330_0'
)  AND is_active = true 
RETURNING "id"

Answer 1

你在正确的轨道上。

要使其正常工作，您需要告诉Postgres您希望返回所有受影响行的id列。您可以通过将returning id；添加到查询的末尾来完成此操作。代码如下所示：

@SqlUpdate(
      "UPDATE task_sync SET "
          + " is_active = false, "
          + " version = version+1 "
          + " WHERE task_id IN (<taskIdList>) "
          + " AND barcode IN (<barcodeList>) "
          + " AND is_active = true RETURNING id;")
  @GetGeneratedKeys("id")
  List<Long> deactivateTaskSyncByTaskIdInAndBarcodeList(
      @BindList("taskIdList") List<Long> taskIdList,
      @BindList("barcodeList") Set<String> barcodeList,
      @Bind("lastUpdatedById") Long lastUpdatedById);

请注意，您还可以返回多列（例如:返回id、version；)或事件整行（例如:返回*；)。