要加入CriteriaQuery吗? [英] JOIN with CriteriaQuery?

问题描述

我正在尝试使用CriteriaQuery进行联接以获得我的数据库的信息，但是返回有关无法解析属性的异常，并且不起作用.我正在寻找解决方案，但仍未找到. 我的代码在下面.

I'm trying do a JOIN using CriteriaQuery to get informations of my database but returns an exception about unable to resolve attribute and doesn't work. I'm looking for solution but still havent found. My code is bellow.

@Entity
@Table(name="cargo")
public class Cargo implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id @GeneratedValue
    private Integer idCargo;    

    @NotNull @NotEmpty @Column(unique=true) 
    private String cargo;
}


@Entity
@Table(name="curriculum")
public class Curriculum implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    private Long idCurriculum;

    @Transient @OneToOne @JoinColumn(name="idCurriculum")
    private Curriculum curriculum;

    @Temporal(TemporalType.DATE)
    private Date dataCad;



    @Size(min=5, max=50)
    @NotNull
    @NotEmpty   
    private String nome;

    @NotEmpty
    private String sexo;

    @Email
    @NotEmpty
    @NotNull
    @Size(max=250)
    @Column(unique=true)
    private String email;

    @NotNull
    @NotEmpty
    @Size(min=14, max=14)
    @Column(unique=true)
    private String cpf;

    @NotEmpty
    @NotNull
    @Size(min=8, max=8)
    private String senha;

    @OneToOne//(cascade = CascadeType.ALL)
    @NotNull
    @JoinColumn(name="idCargo")
    private Cargo cargo;

    private String ativado = "N";
}


@Entity
@Table(name="curriculum2")
public class Curriculum2 implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    private Long idC2; //NOT NULL AUTO_INCREMENT,

    @NotNull @OneToOne(cascade=CascadeType.ALL,orphanRemoval=true) 
    @JoinColumn(name="idCurriculum")    
    private Curriculum curriculum; //NOT NULL,

    @NotNull @Temporal(TemporalType.DATE)
    private Date dataNasceu; //NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String cidade; //` varchar(50) NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String endereco; //` varchar(50) NOT NULL,

    @NotNull 
    private int numero; //` int(11) NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String bairro; //` varchar(50) NOT NULL,


    private String complemento;

    //14.790-000
    private String cep;

    private String estado;


    private String fone; //varchar(15)


    private String celular;


    private String pai;

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String mae;//NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String nacionalidade; // NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String naturalidade; //NOT NULL,

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String estcivil; //NOT NULL,


    private String rg;

    @NotNull @NotEmpty @Size(min=5, max=20)
    private String cartprof; //NOT NULL,

    @NotNull @NotEmpty @Size(min=2, max=20)
    private String serie; //NOT NULL,


    private String reservista; 
    private String titeleitor;
    private String zona;
    private String carthabilita;
    private String categoria;
    private BigDecimal ultimosalario;

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String salariopretendido; //not null

    private String observacoes;    
}


@Entity
@Table(name="escolaridade")
public class Escolaridade implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    private Integer idEscola;

    @NotNull @NotEmpty @Size(min=5,max=50)
    private String escola;

    @NotNull @NotEmpty @Size(min=5,max=50)
    private String cidade;

    @NotNull
    private String estado;

    @NotNull @Temporal(TemporalType.DATE)
    private Date inicio;

    @Temporal(TemporalType.DATE)
    private Date conclusao;

    @NotNull 
    private String ensino;

    @NotNull @OneToOne @JoinColumn(name="idCurriculum")
    private Curriculum curriculum;
}


@Entity
@Table(name="experiencia")
public class Experiencia implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    private Integer idExperiencia;  
    @NotNull @NotEmpty @Size(min=5,max=50)
    private String empresa; 
    @NotNull @NotEmpty @Size(min=5,max=50)
    private String endereco;    
    @NotNull @NotEmpty @Size(min=5,max=50)
    private String cidade;  
    @NotNull @NotEmpty @Size(min=5,max=50)
    private String bairro;  
    @NotNull @NotEmpty
    private String estado;      
    @NotNull @Temporal(TemporalType.DATE) 
    private Date entrada;   
    @Temporal(TemporalType.DATE)
    private Date saida; 
    @NotNull @NotEmpty @Size(min=5,max=50)
    private String cargo;   
    private String funcoesDesemp;   
    private String fone;
    private String nomeEncarregado; 
    @NotNull @OneToOne @JoinColumn(name="idCurriculum")
    private Curriculum curriculum;
}

@Entity
@Table(name="aperfeicoamento")
public class Aperfeicoamento implements Serializable{
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue
    private Integer idAperfeicoamento;

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String aperfeicoamento;

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String entidadeensino;

    @NotNull @NotEmpty @Size(min=5, max=50)
    private String cidade;

    @NotNull 
    private String estado;

    @NotNull @Temporal(TemporalType.DATE)
    private Date inicio;

    @Temporal(TemporalType.DATE)
    private Date conclusao;

    @OneToOne 
    @JoinColumn(name="idCurriculum")    
    private Curriculum curriculum;
}


//return List<Curriculum>
public List<Curriculum> getCurriculumReport(Long id){
        List<Curriculum> lista = new ArrayList<Curriculum>();

        EntityManager em = datasource.getEntityProvider().getEntityManager();       
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Curriculum> c = cb.createQuery(Curriculum.class);        
        Root<Curriculum> root = c.from(Curriculum.class);
        Join<Curriculum, Cargo> joinCCargo = root.join("curriculum");
        Join<Curriculum, Curriculum2> joinCC2 = root.join("curriculum");
        Join<Curriculum, Escolaridade> joinCE = root.join("curriculum");
        Join<Curriculum, Aperfeicoamento> joinCA = root.join("curriculum");
        Join<Curriculum, Experiencia> joinCExp = root.join("curriculum");

        c.where(cb.equal(joinCCargo.get("idCurriculum"), cb.parameter(Long.class, "id")));
        TypedQuery q = em.createQuery(c);
        q.setParameter("id", id);

        lista = q.getResultList();

        return lista;
    }


//Exception returns
Caused by: java.lang.IllegalArgumentException: Unable to resolve attribute [curriculum] against path
    at org.hibernate.ejb.criteria.path.AbstractPathImpl.unknownAttribute(AbstractPathImpl.java:120)
    at org.hibernate.ejb.criteria.path.AbstractPathImpl.locateAttribute(AbstractPathImpl.java:229)
    at org.hibernate.ejb.criteria.path.AbstractFromImpl.join(AbstractFromImpl.java:411)
    at org.hibernate.ejb.criteria.path.AbstractFromImpl.join(AbstractFromImpl.java:397)
    at br.ind.ibg.dao.RelatorioDAO.getCurriculumReport(RelatorioDAO.java:33)
    at br.ind.ibg.reports.Report.<init>(Report.java:23)
    at br.ind.ibg.views.ViewCurriculum.buttonClick(ViewCurriculum.java:413)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:508)
    ... 37 more

任何想法??

推荐答案

根据您的实体类，这没有意义.

This does not make sense based on your entity classes.

    Join<Curriculum, Cargo> joinCCargo = root.join("curriculum");

root的类型是Curriculum，它确实具有curriculum属性，但是该属性的类型不是Cargo，而是Curriculum.

The type of root is Curriculum, which does indeed have a curriculum property, but the type of that property is not Cargo, it is Curriculum.

这看起来像您想要的.

    Join<Curriculum, Cargo> joinCCargo = root.join("cargo");

-编辑- 对于其他协会，依此类推.如果您需要加入未映射的实体，那么最好的解决方案是映射该实体.使用属性名称'experienciaList'将Experiencia对象的集合映射到您的Curriculum类，然后通过

-- EDIT -- And so on for the other associations. If you need to join an entity that isn't mapped then your best solution is to map the entity. Map a collection of Experiencia objects to your Curriculum class with a property name of 'experienciaList' and then join it in your query by doing

   root.join("experienciaList");

Hibernate将知道如何联接表，因为您的映射将对其进行定义.

Hibernate will know how to join the table because your mapping will define it.

此外，实际上，仅当您想使用它们来对查询内容创建限制时，才需要创建这些命名的Join对象.如果您只想告诉Hibernate提取关联，请执行此操作.

Also, you really only need to create these named Join objects when you want to use them to create restrictions on your query something. If you just want to tell Hibernate to fetch the associations just do this.

   root.join("cargo").join("foo").join("bar");

这篇关于要加入CriteriaQuery吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！