我的 Spring-boot 有問題，我的請求存盤庫是這樣寫的：
package com.ftm.webappli.repository.population;
import java.util.List;
import com.ftm.webappli.model.population.All;
import com.ftm.webappli.model.population.MenWomen;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
@Repository
public interface AllRepository extends JpaRepository<All, Long> {
@Query(
value = "SELECT SUM(p15_pop) AS total_population, SUM(p15_poph) AS total_hommes, SUM(p15_popf) AS total_femmes FROM public.iris_pop_2015 WHERE com = :code",
nativeQuery = true)
List<MenWomen> sumPopulationHommeFemme(String code);
}
她在 PostgreSQL 上回傳 3 BigInt。
在我寫的方法中：
package com.ftm.webappli.model.population;
import java.io.Serializable;
import java.math.BigInteger;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import lombok.AccessLevel;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.experimental.FieldDefaults;
@Entity
@FieldDefaults(level = AccessLevel.PRIVATE)
@Getter
@NoArgsConstructor
@Setter
@Table(schema = "public", name = "iris_pop_2015")
public class MenWomen implements Serializable {
@Id
@Column(name = "total_population")
private BigInteger nbTotal;
@Column(name = "total_hommes")
private BigInteger nbMen;
@Column(name = "total_femmes")
private BigInteger nbWomen;
}
但我有一個錯誤：
無法從型別 [java.lang.Object[]] 轉換為型別 [com.ftm.webappli.model.population.MenWomen] 的值“{5766, 2767, 2999}”；嵌套例外是 org.springframework.core.convert.ConverterNotFoundException：找不到能夠從型別轉換的轉換器
我試圖糾正我的要求：
"SELECT SUM(p15_pop)::integer AS total_population, SUM(p15_poph)::integer AS total_hommes, SUM(p15_popf)::integer AS total_femmes FROM public.iris_pop_2015 WHERE com = :code"
和模型到整數，例如：
@Column(name = "total_hommes")
private Integer nbMen;
但不起作用......該請求在 PostgreSQL 上有效，但在 Spring 上無效，帶有 '::integer'
我也嘗試更正我的 java.lang：
@Repository
public interface AllRepository extends JpaRepository<All, Integer>
或者
@Repository
public interface AllRepository extends JpaRepository<All, Long>
或者
@Repository
public interface AllRepository extends JpaRepository<All, BigInteger>
但不起作用......你有什么想法嗎？
uj5u.com熱心網友回復：
請替換All為物體名稱，即，MenWomen如下所示，
@Repository
public interface AllRepository extends JpaRepository<MenWomen, Integer>
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/381710.html