Spring JPA，@SqlResultSetMapping映射到JPA存储库

Question

应用：Spring防尘套

我试图用SqlResultSetMapping和NamedNativeQuery将非实体类映射到JPA存储库。

运行应用程序时出现以下错误：

通过字段'cityAddressRepository'表示不满足的依赖关系；嵌套异常是org.springframework.beans.factory.BeanCreationException：创建名称为'cityAddressRepository'的bean时出错：调用init方法失败；嵌套异常是java.lang.IllegalArgumentException：不是托管类型：类com.city.strom.core.domain.CityAddressEntity atorg.springframework.beans.factory.annotation.AutowiredAnNotationBeanPost处理器$AutowiredFieldElement.inject（AutowiredAnNotationBeanPostProcessor.java:573）~[sping-bean-5.0.0.0. RC1.jar：5.0.0. RC1]

任何帮助都将被指定，我的实施中有什么问题吗

城市地址。Java语言

public class CityAddress { 

    private static final long serialVersionUID = -4860426805452667396L;

    private Integer objectid;
    private String streetname;
    private String streetnumber;


    public Integer getObjectid() {
        return objectid;
    }
    public void setObjectid(Integer objectid) {
        this.objectid = objectid;
    }
    public String getStreetname() {
        return streetname;
    }
    public void setStreetname(String streetname) {
        this.streetname = streetname;
    }
    public String getStreetnumber() {
        return streetnumber;
    }
    public void setStreetnumber(String streetnumber) {
        this.streetnumber = streetnumber;
    }

}

城市地址本质。Java语言

@Entity
@SqlResultSetMapping(
    name="cityaddressmap",
    entities={
        @EntityResult(
           entityClass=CityAddress.class,
              fields={
                  @FieldResult(name="objectid", column="ID"),
                  @FieldResult(name="streetnumber", column="STREETNUMBER"),
                  @FieldResult(name="streetname", column="STREETNAME")
              }         
        )
    }
) 
@NamedNativeQuery(
    name="CityAddressEntity.AllCityAddresses", 
    query="select OBJECTID, ADD_NUM STREETNUMBER, trim(ADD_STREET || ' ' || ADD_STREET_TYPE) STREETNAME from SWPF_PARCEL_V;", 
    resultSetMapping="cityaddressmap")
public class CityAddressEntity implements Serializable{ 

    private static final long serialVersionUID = -4860426805452667396L;

    public CityAddressEntity()
    {

    }
}

城市地址epository.java

public interface CityAddressRepository extends JpaRepository<CityAddressEntity, Long>{

    @Query(name="CityAddressEntity.AllCityAddresses")
    public List<CityAddress> AllCityAddresses();

}

Answer 1

CityAddress不是实体，请使用targetClass而不是entityClass。试试这样：

@SqlResultSetMapping(
    name="cityaddressmap",
    classes={
        @ConstructorResult(
           targetClass=CityAddress.class,
              columns={
                  @FieldResult(name="ID", type=Integer.class),
                  @FieldResult(name="STREETNUMBER", type=String.class),
                  @FieldResult(name="STREETNAME", type=String.class)
              }         
        )
    }
) 

并将构造函数添加到CityAddress

    public class CityAddress { 

        private Integer objectid;
        private String streetname;
        private String streetnumber;

        public CityAddress(Integer objectid, String streetname, String streetnumber) {
           this.objectid = objectid;
           this.streetname = streetname;
           this.streetnumber = streetnumber;
        }