org.springframework.data.jpa.repository.query.abstractjpaquery $ tuple

Question

我不知道为什么我会遇到这个错误。所有错误

There was an unexpected error (type=Internal Server Error, status=500).
No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [com.example.entities.dtos.PaymentFormulaDto]
org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap] to type [com.example.entities.dtos.PaymentFormulaDto]```


my query is below

@query（value =“ select a.external_id as externalId_从员工a左JOIN paymentformula b on a.external_id = b.user_id”，nativequery = true） 列出get employeeandpayment（）;

公共类Paymayforuladto {

private String externalId;

private String employeeName;

private String employeeLastName;

private String pasword;

private String employeeEmail;

private String employeeExternalId;

private String employeeId;

}

Answer 1

使用接口投影或添加sqlresultset映射。
请参阅本文： https://thorben-janssen.com/spring -data-jpa-dto-native-queries/