Member Avatar for mmxbass
mmxbass 2 Light Poster

I am having problems persisting a ManyToMany relationship using Toplink and entity objects created automaticaly by Netbeans. I have attached the relevant entity objects as Data.zip. My problem is this:

Chapter and Strand have a ManyToMany relationship as you can see in the entity objects. A strand contains multiple chapters but the same chapter may appear in more than one strand. When I change the chapter object, i call setBody(), setName() etc and when I commit() the transaction, everything is persisted to those fields, that part works fine. The problem crops up when I call setStrandCollection() on my chapter and pass it a vector of strands. When I commit the transaction. The application behaves as though the data is persisted (when I go to another chapter and come back, the reloaded chapter has the changes) but it doesn't actually write the change to the tables. When I look in phpMyAdmin, the changes to the relationship table were never made although all other changes (from the same transaction) were made correctly.

I'm concerned that perhaps the classes generated by netbeans need some cleanup but I'm not sure where or how.

Any thoughts/suggestions?

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package novelizer.data;

import java.io.Serializable;
import java.util.Collection;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;

/**
 *
 * @author mmxbass
 */
@Entity
@Table(name = "book")
@NamedQueries({@NamedQuery(name = "Book.findById", query = "SELECT b FROM Book b WHERE b.id = :id"), @NamedQuery(name = "Book.findByName", query = "SELECT b FROM Book b WHERE b.name = :name")})
public class Book implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "name", nullable = false)
    private String name;
    @Lob
    @Column(name = "description", nullable = false)
    private String description;
    @ManyToMany(mappedBy = "bookCollection")
    private Collection<Location> locationCollection;
    @ManyToMany(mappedBy = "bookCollection")
    private Collection<Person> personCollection;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "book")
    private Collection<Chapter> chapterCollection;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "book")
    private Collection<Strand> strandCollection;

    public Book() {
    }

    public Book(Integer id) {
        this.id = id;
    }

    public Book(Integer id, String name, String description) {
        this.id = id;
        this.name = name;
        this.description = description;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Collection<Location> getLocationCollection() {
        return locationCollection;
    }

    public void setLocationCollection(Collection<Location> locationCollection) {
        this.locationCollection = locationCollection;
    }

    public Collection<Person> getPersonCollection() {
        return personCollection;
    }

    public void setPersonCollection(Collection<Person> personCollection) {
        this.personCollection = personCollection;
    }

    public Collection<Chapter> getChapterCollection() {
        return chapterCollection;
    }

    public void setChapterCollection(Collection<Chapter> chapterCollection) {
        this.chapterCollection = chapterCollection;
    }

    public Collection<Strand> getStrandCollection() {
        return strandCollection;
    }

    public void setStrandCollection(Collection<Strand> strandCollection) {
        this.strandCollection = strandCollection;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Book)) {
            return false;
        }
        Book other = (Book) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "novelizer.data.Book[id=" + id + "]";
    }

}
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package novelizer.data;

import java.io.Serializable;
import java.util.Collection;
import java.util.Date;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author mmxbass
 */
@Entity
@Table(name = "chapter")
@NamedQueries({@NamedQuery(name = "Chapter.findById", query = "SELECT c FROM Chapter c WHERE c.id = :id"), @NamedQuery(name = "Chapter.findByName", query = "SELECT c FROM Chapter c WHERE c.name = :name"), @NamedQuery(name = "Chapter.findByBorder", query = "SELECT c FROM Chapter c WHERE c.border = :border"), @NamedQuery(name = "Chapter.findByTstamp", query = "SELECT c FROM Chapter c WHERE c.tstamp = :tstamp")})
public class Chapter implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "name", nullable = false)
    private String name;
    @Lob
    @Column(name = "description", nullable = false)
    private String description;
    @Lob
    @Column(name = "body", nullable = false)
    private String body;
    @Column(name = "border", nullable = false)
    private int border;
    @Column(name = "tstamp", nullable = false)
    @Temporal(TemporalType.TIMESTAMP)
    private Date tstamp;
@ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.MERGE}, mappedBy = "chapterCollection", targetEntity = Strand.class)
    private Collection<Strand> strandCollection;
    @ManyToMany(mappedBy = "chapterCollection")
    private Collection<Person> personCollection;
    @ManyToMany(mappedBy = "chapterCollection")
    private Collection<Location> locationCollection;
    @JoinColumn(name = "book", referencedColumnName = "id")
    @ManyToOne
    private Book book;

    public Chapter() {
    }

    public Chapter(Integer id) {
        this.id = id;
    }

    public Chapter(Integer id, String name, String description, String body, int border, Date tstamp) {
        this.id = id;
        this.name = name;
        this.description = description;
        this.body = body;
        this.border = border;
        this.tstamp = tstamp;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getBody() {
        return body;
    }

    public void setBody(String body) {
        this.body = body;
    }

    public int getBorder() {
        return border;
    }

    public void setBorder(int border) {
        this.border = border;
    }

    public Date getTstamp() {
        return tstamp;
    }

    public void setTstamp(Date tstamp) {
        this.tstamp = tstamp;
    }

    public Collection<Strand> getStrandCollection() {
        return strandCollection;
    }

    public void setStrandCollection(Collection<Strand> strandCollection) {
        this.strandCollection = strandCollection;
    }

    public Collection<Person> getPersonCollection() {
        return personCollection;
    }

    public void setPersonCollection(Collection<Person> personCollection) {
        this.personCollection = personCollection;
    }

    public Collection<Location> getLocationCollection() {
        return locationCollection;
    }

    public void setLocationCollection(Collection<Location> locationCollection) {
        this.locationCollection = locationCollection;
    }

    public Book getBook() {
        return book;
    }

    public void setBook(Book book) {
        this.book = book;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Chapter)) {
            return false;
        }
        Chapter other = (Chapter) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "novelizer.data.Chapter[id=" + id + "]";
    }

}
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package novelizer.data;

import java.io.Serializable;
import java.util.Collection;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 *
 * @author mmxbass
 */
@Entity
@Table(name = "location")
@NamedQueries({@NamedQuery(name = "Location.findById", query = "SELECT l FROM Location l WHERE l.id = :id"), @NamedQuery(name = "Location.findByName", query = "SELECT l FROM Location l WHERE l.name = :name")})
public class Location implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "name", nullable = false)
    private String name;
    @Lob
    @Column(name = "description", nullable = false)
    private String description;
    @JoinTable(name = "location_in_book", joinColumns = {@JoinColumn(name = "location", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "book", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Book> bookCollection;
    @ManyToMany(mappedBy = "locationCollection")
    private Collection<Strand> strandCollection;
    @JoinTable(name = "location_in_chapter", joinColumns = {@JoinColumn(name = "location", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "chapter", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Chapter> chapterCollection;

    public Location() {
    }

    public Location(Integer id) {
        this.id = id;
    }

    public Location(Integer id, String name, String description) {
        this.id = id;
        this.name = name;
        this.description = description;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Collection<Book> getBookCollection() {
        return bookCollection;
    }

    public void setBookCollection(Collection<Book> bookCollection) {
        this.bookCollection = bookCollection;
    }

    public Collection<Strand> getStrandCollection() {
        return strandCollection;
    }

    public void setStrandCollection(Collection<Strand> strandCollection) {
        this.strandCollection = strandCollection;
    }

    public Collection<Chapter> getChapterCollection() {
        return chapterCollection;
    }

    public void setChapterCollection(Collection<Chapter> chapterCollection) {
        this.chapterCollection = chapterCollection;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Location)) {
            return false;
        }
        Location other = (Location) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "novelizer.data.Location[id=" + id + "]";
    }

}
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package novelizer.data;

import java.io.Serializable;
import java.util.Collection;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 *
 * @author mmxbass
 */
@Entity
@Table(name = "person")
@NamedQueries({@NamedQuery(name = "Person.findById", query = "SELECT p FROM Person p WHERE p.id = :id"), @NamedQuery(name = "Person.findByName", query = "SELECT p FROM Person p WHERE p.name = :name")})
public class Person implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "name", nullable = false)
    private String name;
    @Lob
    @Column(name = "description", nullable = false)
    private String description;
    @JoinTable(name = "person_in_book", joinColumns = {@JoinColumn(name = "person", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "book", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Book> bookCollection;
    @JoinTable(name = "person_in_chapter", joinColumns = {@JoinColumn(name = "person", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "chapter", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Chapter> chapterCollection;
    @ManyToMany(mappedBy = "personCollection")
    private Collection<Strand> strandCollection;

    public Person() {
    }

    public Person(Integer id) {
        this.id = id;
    }

    public Person(Integer id, String name, String description) {
        this.id = id;
        this.name = name;
        this.description = description;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Collection<Book> getBookCollection() {
        return bookCollection;
    }

    public void setBookCollection(Collection<Book> bookCollection) {
        this.bookCollection = bookCollection;
    }

    public Collection<Chapter> getChapterCollection() {
        return chapterCollection;
    }

    public void setChapterCollection(Collection<Chapter> chapterCollection) {
        this.chapterCollection = chapterCollection;
    }

    public Collection<Strand> getStrandCollection() {
        return strandCollection;
    }

    public void setStrandCollection(Collection<Strand> strandCollection) {
        this.strandCollection = strandCollection;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Person)) {
            return false;
        }
        Person other = (Person) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "novelizer.data.Person[id=" + id + "]";
    }

}
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package novelizer.data;

import java.io.Serializable;
import java.util.Collection;
import javax.persistence.CascadeType;
import javax.persistence.FetchType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 *
 * @author mmxbass
 */
@Entity
@Table(name = "strand")
@NamedQueries({@NamedQuery(name = "Strand.findById", query = "SELECT s FROM Strand s WHERE s.id = :id"), @NamedQuery(name = "Strand.findByName", query = "SELECT s FROM Strand s WHERE s.name = :name")})
public class Strand implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id", nullable = false)
    private Integer id;
    @Column(name = "name", nullable = false)
    private String name;
    @Lob
    @Column(name = "description", nullable = false)
    private String description;
@ManyToMany(fetch = FetchType.EAGER, targetEntity = Chapter.class, cascade = {CascadeType.REMOVE, CascadeType.MERGE, CascadeType.REFRESH})
    @JoinTable(name = "chapter_in_strand", joinColumns = {@JoinColumn(name = "strand", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "chapter", referencedColumnName = "id")})
    private Collection<Chapter> chapterCollection;
    @JoinTable(name = "location_in_strand", joinColumns = {@JoinColumn(name = "strand", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "location", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Location> locationCollection;
    @JoinTable(name = "person_in_strand", joinColumns = {@JoinColumn(name = "strand", referencedColumnName = "id")}, inverseJoinColumns = {@JoinColumn(name = "person", referencedColumnName = "id")})
    @ManyToMany
    private Collection<Person> personCollection;
    @JoinColumn(name = "book", referencedColumnName = "id")
    @ManyToOne
    private Book book;

    public Strand() {
    }

    public Strand(Integer id) {
        this.id = id;
    }

    public Strand(Integer id, String name, String description) {
        this.id = id;
        this.name = name;
        this.description = description;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Collection<Chapter> getChapterCollection() {
        return chapterCollection;
    }

    public void setChapterCollection(Collection<Chapter> chapterCollection) {
        this.chapterCollection = chapterCollection;
    }

    public Collection<Location> getLocationCollection() {
        return locationCollection;
    }

    public void setLocationCollection(Collection<Location> locationCollection) {
        this.locationCollection = locationCollection;
    }

    public Collection<Person> getPersonCollection() {
        return personCollection;
    }

    public void setPersonCollection(Collection<Person> personCollection) {
        this.personCollection = personCollection;
    }

    public Book getBook() {
        return book;
    }

    public void setBook(Book book) {
        this.book = book;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Strand)) {
            return false;
        }
        Strand other = (Strand) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "novelizer.data.Strand[id=" + id + "]";
    }

}
  • 1 Contributor
  • 0 Replies
  • 78 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.