Hello guys again, I have two model Entitiy class.their name is A and B.
@Entity public class A implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.AUTO) private Long id; @Column(name = "NameA") private String nameA;
public B getBid() { return b; }
public void setBid(B bid) { this.b = bid; }
public String getNameA() { return nameA; }
public void setNameA(String nameA) { this.nameA = nameA; } @JoinColumn(name = "BID", referencedColumnName = "ID") @ManyToOne(fetch= FetchType.LAZY) private B b;
public Long getId() { return id; }
public void setId(Long id) { this.id = id; } }
-------------------------------------------------------------
@Entity public class B implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.AUTO) private Long id; @Column(name = "NameB") private String nameB; public String getNameB() { return nameB; }
public void setNameB(String nameB) { this.nameB = nameB; } public Long getId() { return id; }
public void setId(Long id) { this.id = id; } }
-------------------------------------------------------------
And Here is my problem
My Criteria Query
Criteria criteria =session.createCriteria(A.class); criteria.createCriteria("b"); criteria.setProjection(Projections.property("b")); List lst =criteria.list();
---------> Sql Query Result select this_.BID as y0_ from A this_ inner join B b1_ on this_.BID=b1_.id
Yeah,When we are this point,I want to full field of B class in SQL Query result but ı have to use Criteria API
The Query Result is Like this
select b1_.id as id1_, b1_.NameB as NameB1_ A a0_ inner join B b1_ on a0_.BID=b1_.id
|