detached entity passed to persist
kaviarasu Sep 12, 2007 9:38 AMhi im using two tables where Table1 refers Table2 by manytoOne annotation
here im using the following code to insert in primary and secondry table
when the register() is called it insert in the database
when the String edit() method is called it edit the particular review and update the review
then for second time register() is called
detached entity passed to persist entity.beans.TblReviewserror comes ......
how to over come this
even i used
em.flush(); em.refresh(tr);
still the error comes how to reoslve this
@Stateful @Name("search") public class SearchAction implements Search, Serializable { static final long serialVersionUID = -6536629890251170098L; @PersistenceContext EntityManager em; @RequestParameter BigDecimal id; @RequestParameter BigDecimal revid; @Out(required=false) TblProducts pro; @DataModel private List rev; @Out(required=false) Long rid4comm1; @In (required=false) Identity identity; TblReviews tr=new TblReviews(); @In(required=false) @Out(required=false) TblUserReviews tblu; @Out(required=false) List<TblUserReviews> editreview; @Begin(join=true) public void selectFromRequest() { if (id != null) { pro = em.find(TblProducts.class, id); details = em.createQuery("select s from SearchBean s where s.storeProductId in (select st2.storeProductId from TblProductStore st2 where st2.productId="+id+")").getResultList(); rev= em.createQuery("select p from TblReviews p where productId="+id+"").getResultList(); } } @Begin(join=true) public String register() { tr.setProductId(pro); tr.setUserId(identity.getUsername()); Set<TblUserReviews> tblUserReviewsCollection= new TreeSet<TblUserReviews>(); tblu.setReviewEntryId(tr); tblUserReviewsCollection.add(tblu); tr.setTblUserReviewsCollection(tblUserReviewsCollection); em.persist(tr); em.flush(); em.refresh(tr); return "/prodis.xhtml"; } @Begin(join=true) public String edit() { em.merge(tblu); return "/prodis.xhtml"; } @Begin(join=true) public void editReview(){ editreview= (List<TblUserReviews>) em.createQuery("select p from TblUserReviews p where userReviewId="+revid+"").getResultList(); tblu = (TblUserReviews) editreview.get(0); } @End public void reset() {} @Destroy @Remove public void destroy() {} }
thank u regards
kavi