@对DTO的查询结果导致spring数据jpa中的构造函数错误

Question

在我的JpaRepository中，我有一个如下的问题

@Query("select new com.x.airlinesystem.dto.ticket.TicketPriceDTO((select count(t) from Ticket t where t.flight=:flightId and t.ticketStatus=:ticketStatus),f.capacity,f.price) from Flight f where f.id = :flightId")
TicketPriceDTO findPriceInfo(@Param("flightId") Long flightId,
        @Param("ticketStatus") TicketStatus ticketStatus);

我的dto就像下面一样；

@Data
@AllArgsConstructor
@NoArgsConstructor
public class TicketPriceDTO implements Serializable {

    private Integer sold;
    private Integer capacity;
    private BigDecimal price;
}

最后，我的TicketStatus枚举是；

public enum TicketStatus {
    SOLD, RETURNED
}

当我编译项目时，我得到如下错误；

Answer 1

// Hi you can try to change Integer with Long

private Integer sold;
private Integer capacity;
private BigDecimal price;

//to replace with 

private Long sold;
private Integer capacity;
private BigDecimal price;

//I can see Expected arguments are: long, int, java.math.BigDecimal is looking for long type

Answer 2

只是直觉，但确实如此

回来多久？

也许改变私有整数就足够了 至私人长期出售 ？