|
|
Re: Retrieving data from a resultset with two or more same column names. [message #1007961 is a reply to message #1007952] |
Fri, 08 February 2013 13:57 |
cerh Mising name Messages: 6 Registered: November 2011 |
Junior Member |
|
|
I'm sorry that did not wrote a complete example.
This example gives an incorrect result if I uncomment //cq.multiselect(select);
Eclipselink 2.3.0 and 2.4.1
@Entity
public class T1{
@Id
@Column(name = "id")
public String id;
@Column(name = "NAME")
public String name;
@JoinColumn(name = "PARENT_id")
@OneToOne(fetch = FetchType.EAGER)
public T1 parentT1;
}
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<?> cq = cb.createQuery(T1.class);
Root<?> root = cq.from(T1.class);
Selection<?>[] select = new Selection[]{root.get("id"),root.get("name"),root.get("parentT1").get("id"),root.get("parentT1").get("name")};
//cq.multiselect(select); <----- ok if comment
Query query = em.createQuery(cq);
((org.eclipse.persistence.jpa.JpaQuery<?>)query).getDatabaseQuery().dontMaintainCache();
List<T1> listT1=query.getResultList();
for (T1 t12 : listT1) {
System.out.println(t12.id+" "+t12.name+" "+t12.parentT1.id+" "+t12.parentT1.name);
}
[Updated on: Fri, 08 February 2013 13:59] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.01629 seconds