Hi Fay,
I think it would be difficult to recreate this bug in a standalone test case
like you have created.
As mentioned previously, this bug only surfaces on the second find.
Perhaps if you modify your test case by reusing the em for the create and
the find, it could reproduce the bug?
Regards,
Enrico
Fay Wang wrote:
>
> Sorry, I spoke too soon. My test case actually runs fine. The following
> listings are my TblAmdCtl.java, TblAmdDes.java and TestQuerySQLCache.
> Could you attach your test case to reproduce this problem in the JIRA?
> Thanks!
>
> (1) TblAmdCtl.java
>
> @Entity
> public class TblAmdctl {
> @OneToMany(mappedBy="tblAmdctl",fetch = FetchType.EAGER,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE})
> private Collection<TblAmddes> tblAmddess = new ArrayList<TblAmddes>();
>
> @Id
> @Column(name="AMDCTL_ID")
> private int AMDCTL_ID;
>
> public void setId(int id) {
> this.AMDCTL_ID = id;
> }
>
> public int getId() {
> return AMDCTL_ID;
> }
>
> public Collection getTblAmddes() {
> return tblAmddess;
> }
>
> public void addTblAmddes(TblAmddes t) {
> tblAmddess.add(t);
> }
> }
>
> (2) TblAmddes.java
> @Entity
> public class TblAmddes {
> @ManyToOne(fetch = FetchType.LAZY,cascade = {
> CascadeType.PERSIST,CascadeType.MERGE })
> @JoinColumns([EMAIL PROTECTED](name =
> "AMDCTL_ID",referencedColumnName="AMDCTL_ID")})
> @ForeignKey
> private TblAmdctl tblAmdctl;
>
> @Id
> private int id;
>
> public void setId(int id) {
> this.id = id;
> }
>
> public int getId() {
> return id;
> }
>
> public TblAmdctl getTblAmdctl() {
> return tblAmdctl;
> }
>
> public void setTblAmdctl(TblAmdctl t) {
> tblAmdctl = t;
> }
>
> }
>
> (3) test case:
> public class TestQuerySQLCache {
>
> public static void main (String[] args) {
> createObj();
> findObj();
> }
>
> public static void createObj() {
> EntityManager em = Persistence.createEntityManagerFactory("JpaDemo2").
> createEntityManager();
> EntityTransaction tran = em.getTransaction();
>
> TblAmdctl ctl1 = new TblAmdctl();
> ctl1.setId(1);
>
> TblAmddes des1 = new TblAmddes();
> des1.setId(1);
> des1.setTblAmdctl(ctl1);
>
> TblAmddes des2 = new TblAmddes();
> des2.setId(2);
> des2.setTblAmdctl(ctl1);
> ctl1.addTblAmddes(des1);
> ctl1.addTblAmddes(des2);
>
> TblAmdctl ctl2 = new TblAmdctl();
> ctl2.setId(2);
>
> TblAmddes des3 = new TblAmddes();
> des3.setId(3);
> des3.setTblAmdctl(ctl2);
>
> TblAmddes des4 = new TblAmddes();
> des4.setId(4);
> des4.setTblAmdctl(ctl2);
> ctl2.addTblAmddes(des3);
> ctl2.addTblAmddes(des4);
>
> tran.begin();
> em.persist(ctl1);
> em.persist(ctl2);
> em.persist(des1);
> em.persist(des2);
> em.persist(des3);
> em.persist(des4);
>
> em.flush();
> tran.commit();
> }
>
> public static void findObj() {
> EntityManager em = Persistence.createEntityManagerFactory("JpaDemo2").
> createEntityManager();
> EntityTransaction tran = em.getTransaction();
> TblAmdctl ctl1 = em.find(TblAmdctl.class, 1);
> Collection<TblAmddes> dess1 = ctl1.getTblAmddes();
> for (TblAmddes des : dess1)
> System.out.println("des id = " + des.getId());
>
> TblAmdctl ctl2 = em.find(TblAmdctl.class, 2);
> Collection<TblAmddes> dess2 = ctl2.getTblAmddes();
> for (TblAmddes des : dess2)
> System.out.println("des id = " + des.getId());
>
> }
> }
>
--
View this message in context:
http://n2.nabble.com/OpenJPA-1.2.0-Bug-on-FetchType.EAGER-tp1100274p1106516.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
