自定义查询参数值[2]与预期类型不匹配

Question

我试图更新一个实体与OneToOne关系使用restful Web服务。

我使用自定义查询，但它不工作

@Modifying
@Query("UPDATE Activity a SET a.type = :type WHERE a.id = :uuid")
int setType(@Param("uuid") UUID uuid, @Param("type") long type);

错误：

java.lang.的参数值[2]不匹配预期的类型[com.mezoo.tdc.model.ActivityType（n/a）]

活动豆

@Entity
@Table(name= "Activity")
public class Activity implements Serializable{

   @Id
   @GeneratedValue(generator = "uuid")
   @GenericGenerator(name="uuid", strategy = "uuid2")
   @Column(name = "uuid", nullable = false, unique = true, columnDefinition = "BINARY(16)")
   private UUID uuid;

   @OneToOne(fetch = FetchType.EAGER, cascade={CascadeType.MERGE})
   @JoinColumn(name="type", nullable = false)
   private ActivityType type;

豆子

@Entity
@Table(name= "ActivityType")
public class ActivityType implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;

    @Column(nullable = false, unique = true)
    private String code;

    @Column(nullable = false)
    private String label;

它是可能的更新没有自定义查询？我想使用下面的POST请求：

{"uuid":"9d9fa946-ee6e-408e-9e8a-7a9786a1d362","label":"ACTIVITY", "type":{"id":2}}

使现代化

活动存储库：

@Transactional
public interface ActivityDao extends CrudRepository<Activity, UUID> {

@Modifying
@Query("UPDATE Activity a SET a.type = :type WHERE a.uuid = :uuid")
int updateType(@Param("uuid") UUID uuid, @Param("type") ActivityType type);
}

活动服务：

@Service
public class ActivityService implements EntityService<Activity,UUID> {
private static final Logger LOGGER = LoggerFactory.getLogger(ActivityService.class);
    @Override
    public Activity update(Activity activity) {
    LOGGER.info("Update ",activity);
    Activity updated = activityDao.findOne(activity.getUuid());
    if(updated==null) throw new ResourceNotFoundException();

    if (activity.getType().getId()!= updated.getType().getId()) {
        LOGGER.info("Update ActivityType for Activity "+activity.getUuid(),activity);

        activityDao.updateType(updated.getUuid(),activity.getType());
    }
    updated.setLabel(activity.getLabel());
    updated.setDetails(activity.getDetails());

    return activityDao.save(updated);
}

谢谢

Answer 1

您的参数@Param（“type”）long type错误！它应该是@Param（“type”）ActivityType类型。