[jboss-user] [EJB3] - Re: Cycle in relation one-to-many

logandtr do-not-reply at jboss.com
Wed Aug 7 13:30:19 EDT 2013


logandtr [https://community.jboss.org/people/logandtr] created the discussion

"Re: Cycle in relation one-to-many"

To view the discussion, visit: https://community.jboss.org/message/831819#831819

--------------------------------------------------------------
Hi, the code is this:

DB:

Persons(id, name)
Phonenumbers(number, id_persons) FK id_person references Persons(id)

Java code:



package com.app.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.jboss.resteasy.annotations.providers.jaxb.JAXBConfig;

@Entity
@Table(name = "phonenumbers", catalog = "test")
public class Phonenumbers implements java.io.Serializable {

    private static final long serialVersionUID = -8122359598003938895L;
    private String number;
    private Persons persons;

    public Phonenumbers() {
    }

    public Phonenumbers(String number) {
        this.number = number;
    }

    public Phonenumbers(String number, Persons persons) {
        this.number = number;
        this.persons = persons;
    }

    @Id
    @Column(name = "number", unique = true, nullable = false, length = 20)
    public String getNumber() {
        return this.number;
    }

    public void setNumber(String number) {
        this.number = number;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "id_person")
    public Persons getPersons() {
        return this.persons;
    }

    public void setPersons(Persons persons) {
        this.persons = persons;
    }

}




package com.app.model;

import java.util.HashSet;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name = "persons", catalog = "test")
public class Persons implements java.io.Serializable {

    private static final long serialVersionUID = -3247756369663156186L;
    private Integer id;
    private String name;
    private Set<Phonenumbers> phonenumberses = new HashSet<Phonenumbers>(0);

    public Persons() {
    }

    public Persons(String name) {
        this.name = name;
    }

    public Persons(String name, Set<Phonenumbers> phonenumberses) {
        this.name = name;
        this.phonenumberses = phonenumberses;
    }

    @Id
    @GeneratedValue(strategy = IDENTITY)
    @Column(name = "id", unique = true, nullable = false)
    public Integer getId() {
        return this.id;
    }

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

    @Column(name = "name", nullable = false, length = 50)
    public String getName() {
        return this.name;
    }

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

    @OneToMany(fetch = FetchType.LAZY, mappedBy = "persons")
    public Set<Phonenumbers> getPhonenumberses() {
        return this.phonenumberses;
    }

    public void setPhonenumberses(Set<Phonenumbers> phonenumberses) {
        this.phonenumberses = phonenumberses;
    }

}



package com.app.dao;


import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.PersistenceContextType;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.app.model.Phonenumbers;

@Stateless
public class PhonenumbersHome {

    private static final Log log = LogFactory.getLog(PhonenumbersHome.class);

    @PersistenceContext(unitName="PhoneBook", type=PersistenceContextType.EXTENDED)
    private EntityManager entityManager;

    public void persist(Phonenumbers transientInstance) {
        log.debug("persisting Phonenumbers instance");
        try {
            entityManager.persist(transientInstance);
            log.debug("persist successful");
        } catch (RuntimeException re) {
            log.error("persist failed", re);
            throw re;
        }
    }

    public void remove(Phonenumbers persistentInstance) {
        log.debug("removing Phonenumbers instance");
        try {
            entityManager.remove(persistentInstance);
            log.debug("remove successful");
        } catch (RuntimeException re) {
            log.error("remove failed", re);
            throw re;
        }
    }

    public Phonenumbers merge(Phonenumbers detachedInstance) {
        log.debug("merging Phonenumbers instance");
        try {
            Phonenumbers result = entityManager.merge(detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

    public Phonenumbers findById(String id) {
        log.debug("getting Phonenumbers instance with id: " + id);
        try {
            Phonenumbers instance = entityManager.find(Phonenumbers.class, id);
            log.debug("get successful");
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }
}






package com.app.dao;


import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.PersistenceContextType;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.app.model.Persons;

@Stateless
public class PersonsHome {

    private static final Log log = LogFactory.getLog(PersonsHome.class);

    @PersistenceContext(unitName="PhoneBook", type=PersistenceContextType.EXTENDED)
    private EntityManager entityManager;

    public void persist(Persons transientInstance) {
        log.debug("persisting Persons instance");
        try {
            entityManager.persist(transientInstance);
            log.debug("persist successful");
        } catch (RuntimeException re) {
            log.error("persist failed", re);
            throw re;
        }
    }

    public void remove(Persons persistentInstance) {
        log.debug("removing Persons instance");
        try {
            entityManager.remove(persistentInstance);
            log.debug("remove successful");
        } catch (RuntimeException re) {
            log.error("remove failed", re);
            throw re;
        }
    }

    public Persons merge(Persons detachedInstance) {
        log.debug("merging Persons instance");
        try {
            Persons result = entityManager.merge(detachedInstance);
            log.debug("merge successful");
            return result;
        } catch (RuntimeException re) {
            log.error("merge failed", re);
            throw re;
        }
    }

    public Persons findById(Integer id) {
        log.debug("getting Persons instance with id: " + id);
        try {
            Persons instance = entityManager.find(Persons.class, id);
            log.debug("get successful");
            return instance;
        } catch (RuntimeException re) {
            log.error("get failed", re);
            throw re;
        }
    }
}



package com.app.ws;

import javax.ejb.EJB;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.ws.rs.PathParam;
import javax.ws.rs.Produces;
import javax.ws.rs.GET;
import javax.ws.rs.Path;

import com.app.dao.PersonsHome;
import com.app.model.Persons;

@Path("/persons")
public class PersonsResources {

    @EJB
    private PersonsHome ph;

    @GET()
    @Produces("application/json")
    @Path("/{id}")
    public Persons getPerson(@PathParam("id") int id) {
        try{
            Context cx = new InitialContext();
            ph = (PersonsHome)cx.lookup("java:module/PersonsHome");
        }catch(Exception e){
            e.printStackTrace();
        }
        return ph.findById(id);
    }
}{/code}


and this is the persistence.xml





on link: 

 http://localhost:8080/PhoneBook/persons/1 http://localhost:8080/PhoneBook/persons/1

I aspect ad output like this:


> {"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932"......


but I've a cycle like this:

> {"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":{"id":1,"name":"Roberto","phonenumberses":[{"number":"+01932932","persons":


Anyone can halp me?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/831819#831819]

Start a new discussion in EJB3 at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130807/fd97360e/attachment-0001.html 


More information about the jboss-user mailing list