Databases
StackOverflow2013
Postsdbo
POHibernate - TypedQuery.getResultList() returns a list of the same object
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHibernate - TypedQuery.getResultList() returns a list of the same object
    primarykey
    data
    text
    <p>Here is a more and maybe better description of the problem:</p> <p>I do a simple select query. The returning list contains the exact number of records/objects as if I do the same query in the DB, but the problem is that all the objects are the same/identical.</p> <p>For ex, this is the result in the DB (I removed the null values):<br> 26801 01-JAN-00 7 31-DEC-99 7 Obere Kirchstr. 26 CH 8304 Walliselln<br> 26801 01-JAN-00 2 31-DEC-99 2 Obere Kirchstr. 26 CH 8304 Walliselln</p> <p>And this is the content of the variable addresses as I can see it in Eclipse during the debugging after the query has been executed:</p> <p>addresses ArrayList (id=81)<br> elementData Object[10] (id=86)<br> [0] DLDBAddress (id=82)<br> [1] DLDBAddress (id=82)<br> [2] null<br> ...<br> modCount 1<br> size 2 </p> <p>DLDBAddress [persid=26801, valPeriodStart=1900-01-01, valPeriodEnd=9999-12-31, addressNr=7, addressType=7, addressRow1=null, addressRow2=Obere Kirchstr. 26, addressRow3=null, country=CH , postalCode=8304, city=Walliselln, phoneNr=null, faxNr=null, sekretaryPhoneNr=null, alternatPhoneNr=null, pagerNr=null]</p> <p>DLDBAddress [persid=26801, valPeriodStart=1900-01-01, valPeriodEnd=9999-12-31, addressNr=7, addressType=7, addressRow1=null, addressRow2=Obere Kirchstr. 26, addressRow3=null, country=CH , postalCode=8304, city=Walliselln, phoneNr=null, faxNr=null, sekretaryPhoneNr=null, alternatPhoneNr=null, pagerNr=null]]</p> <p>As you can see, the two objects are identical. They shoul instead differ from the addressNr and addressType...</p> <p>This is the piece of code where I build up the query:</p> <pre><code>public static &lt;T&gt; List&lt;T&gt; findBy(EntityManager eM, Class&lt;T&gt; boClass, String whereClause, String whereValue) { EntityManager entityManager = eM; Query query = entityManager.createQuery("from " + boClass.getName() + " s where s." + whereClause + " = " + whereValue); ... return (List&lt;T&gt;) query.getResultList(); } </code></pre> <p>and this is the (quite simple) resulting query:</p> <p>from ch.ethz.id.wai.pdb.bo.DLDBAddress s where s.persid = 26801</p> <p>This is the generated query:</p> <pre><code>Hibernate: select dldbaddres0_.PERSID as PERSID0_, dldbaddres0_.ADRNUM as ADRNUM0_, dldbaddres0_.ADRZEIL1 as ADRZEIL3_0_, dldbaddres0_.ADRZEIL2 as ADRZEIL4_0_, dldbaddres0_.ADRZEIL3 as ADRZEIL5_0_, dldbaddres0_.ADRTYP as ADRTYP0_, dldbaddres0_.ADRAUSWTEL as ADRAUSWTEL0_, dldbaddres0_.ADRORT as ADRORT0_, dldbaddres0_.ADRLAND as ADRLAND0_, dldbaddres0_.ADRFAX as ADRFAX0_, dldbaddres0_.ADRPSA as ADRPSA0_, dldbaddres0_.ADRTEL as ADRTEL0_, dldbaddres0_.ADRPLZ as ADRPLZ0_, dldbaddres0_.ADRSEKTEL as ADRSEKTEL0_, dldbaddres0_.BISDAT as BISDAT0_, dldbaddres0_.VONDAT as VONDAT0_ from NETHZ.V_DLDB_ADRESSE dldbaddres0_ where dldbaddres0_.PERSID=26801 </code></pre> <p>And here the entity:</p> <pre><code>@Entity @Table(name = "V_DLDB_ADRESSE", schema="NETHZ") public class DLDBAddress { @Id @Column(name = "PERSID", insertable = false, updatable = false) private Integer persid; @Temporal(TemporalType.DATE) @Column(name = "VONDAT", insertable = false, updatable = false) private Date valPeriodStart; @Temporal(TemporalType.DATE) @Column(name = "BISDAT", insertable = false, updatable = false) private Date valPeriodEnd; @Column(name = "ADRNUM", insertable = false, updatable = false) private Integer addressNr; @Column(name = "ADRTYP", insertable = false, updatable = false) private Integer addressType; @Column(name = "ADRZEIL1", insertable = false, updatable = false) private String addressRow1; @Column(name = "ADRZEIL2", insertable = false, updatable = false) private String addressRow2; @Column(name = "ADRZEIL3", insertable = false, updatable = false) private String addressRow3; @Column(name = "ADRLAND", insertable = false, updatable = false) private String country; @Column(name = "ADRPLZ", insertable = false, updatable = false) private String postalCode; @Column(name = "ADRORT", insertable = false, updatable = false) private String city; @Column(name = "ADRTEL", insertable = false, updatable = false) private String phoneNr; @Column(name = "ADRFAX", insertable = false, updatable = false) private String faxNr; @Column(name = "ADRSEKTEL", insertable = false, updatable = false) private String secretaryPhoneNr; @Column(name = "ADRAUSWTEL", insertable = false, updatable = false) private String alternatPhoneNr; @Column(name = "ADRPSA", insertable = false, updatable = false) private String pagerNr; ... </code></pre> <p>Am I missing something?</p> <p>Ah, I'm connecting to an Oracle DB.</p> <p>Thanks in advance Francesco</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USFrancesco
    1. USFrancesco
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. USJesus Ramos
      1. VTFavorite
    2. VO
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO1. I'd be more likely to use hql than CriteriaBuilder as the queries are easier to read. 2. Without seeing the where clause passed to the method, it'd be hard to tell you what's wrong.
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. USSpeck
    2. COIn my experience, using JPA & Hibernate EntityManager, this happens when the id is not really unique, which is mandatory in JPA. Hibernate EntityManager fully implements JPA 2 so that should apply here as well. Would you post your entities as well?
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. USErik
    3. COWhat is the actual SQL being generated by Hibernate? Change your Hibernate configuration to show that information. That might provide a better explanation as to what is going wrong.
      singulars
      1. POHibernate - TypedQuery.getResultList() returns a list of the same object
      1. USBrent Worden
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload