Databases
StackOverflow2013
Postsdbo
POHibernate fails to update collection of elements in database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHibernate fails to update collection of elements in database
    primarykey
    data
    text
    <p><b>Embedded Class</b></p> <pre><code>@Embeddable public class TeachingExperience { private String courseName; private String instructor; private String description; } </code></pre> <p><br/> <b>Entity 1</b></p> <pre><code>@Entity public class CV { @ElementCollection(fetch= FetchType.EAGER) @Fetch(value = FetchMode.SELECT) private List&lt;TeachingExperience&gt; teachingExperiences; } </code></pre> <p><br/> <b>Entity 2</b></p> <pre><code>@Entity public class Student { @OneToOne(cascade= CascadeType.ALL, orphanRemoval=true) private CV cv; } </code></pre> <p><br/> The CV class stores a list of teaching experiences a person has. There are other fields that should be fetched eagerly, hence the @Fetch annotation.</p> <p>I use this method to add new teaching experiences to cv of a given student:</p> <pre><code>public static void add (String course, String prof, String desc) { TeachingExperience TE = new TeachingExperience(course, prof, desc); student.getCv().getTeachingExperiences().add(TE); Session session = HibernateUtil.getSessionFactory().openSession(); session.beginTransaction(); session.merge(student); session.getTransaction().commit(); session.close(); } </code></pre> <p>with this configuration each time i try to add a new Teaching Experience, data stored in DB table, get duplicated first, then new entry get inserted. My database table after two consecutive method call looks like this:</p> <p><i> add('DS', 'Feili', 'TA'); </i></p> <pre><code>- DS Feili TA </code></pre> <p><br/> <i> add('AP', 'Ramtin', 'TA'); </i></p> <pre><code>- DS Feili TA - DS Feili TA - AP Ramtin TA </code></pre> <p><br/></p> <p>I have the same problem when trying to remove an object form the list of teaching experiences and I am not sure which part of my code is the root of this odd behavior. </p> <p>Your help will be highly appreciated.</p> <p><br/> <b> EDIT 1: </b></p> <pre><code>@Entity public class TeachingExperience { @Id @GeneratedValue private Integer id; private String courseName; private String instructor; private String description; } @Entity public class CV { @OneToMany(fetch= FetchType.EAGER, cascade=CascadeType.ALL, orphanRemoval=true) @Fetch(value = FetchMode.SELECT) @JoinColumn(name="cv") private List&lt;TeachingExperience&gt; teachingExperiences; } </code></pre> <p><br/></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmdoust
    1. USmdoust
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHibernate fails to update collection of elements in database
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think you should set the `TeachingExperience` as a `Entity` and also try `update()` instead of `merge()`. Please let me know what happens after these changes!
      singulars
      1. POHibernate fails to update collection of elements in database
      1. USboomz
    2. CO@boomz, thanks for your response. I have already changed the TeachingExperience to an Entity (EDIT 1). Interestingly after changing merge() to update(), my original problem was resolved but another problem surfaced; removing an item from the list of teaching experience does not propagate to database table.
      singulars
      1. POHibernate fails to update collection of elements in database
      1. USmdoust
 

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