Spring Data JPA本机查询结果绑定

Question

@Entity
@SqlResultSetMapping(
    name="hourMapping",
    classes=@ConstructorResult(
            targetClass=Representation.class,
            columns={
                    @ColumnResult(name="hour", type=BigDecimal.class),
                    @ColumnResult(name="transactions", type=BigDecimal.class)
            }
            )
    )

@NamedNativeQuery(name="MyEntity.reportByHour", query="SELECT hour,SUM(tran_per_hour) AS transactions FROM MY_ENTITY GROUP BY hour ORDER BY hour"
    ,resultSetMapping="hourMapping")

@Table(name="MY_ENTITY")
public class MyEntity implements Serializable {

@Data //Lombok
@JsonAutoDetect(fieldVisibility = Visibility.ANY)
public class Representation {

public Representation(BigDecimal hour, BigDecimal transactions) {
    this.hour = hour;
    this.transactions = transactions;
}

private BigDecimal hour;
private BigDecimal transactions;

存储库接口：

public interface MyEntityRepository extends JpaRepository<MyEntity, MyEntityPK> {
    List<Representation> reportByHour();
}

当我运行调用本机查询的endpoint时,我得到异常：

无法将值“{0,198}”从类型[java.lang.Object[]]转换为类型[com.representation.representation]；嵌套异常为org.springframework.core.convert.converterNotFoundException：未找到能够从类型[java.math.BigDecimal]转换为类型[com.representation.representation]的转换器

感谢任何帮助。

Answer 1

好吧，虚惊一场。我的hibernate依赖项都被弄乱了，导致了冲突，因此导致了上面的异常。

修复这些依赖问题后，工作很好！！

长话短说：让spring-boot-*处理大多数hibernate依赖项，而不是重写或管理您自己的依赖项。