Re: [eclipselink-dev] Fix for bug# 295556 - Do not add Distinct to Queri

[J Grassel <fyrewyld@xxxxxxxxx>]

Hey there, I’m having a bit of trouble reproducing this issue.  I wrote the following unit test and ran it against ECL 2.5.0 but unfortunately the test refuses to fail.  Is there something important from the problem reproduction description that I am overlooking?

Here’s my attempt at reproducing the problem:

@Entity

public class ECL295EntA {

    @Id

    private int id;

    

    @Basic

    private String strData;

    @Lob String stringValue;

…

}

@Entity

public class ECL295EntB {

    @Id

    private int id;

    

    @Basic

    private String strData;

    

    @ManyToMany(cascade = {CascadeType.PERSIST, CascadeType.REMOVE})

    @JoinTable(name="ECLENTA_ENTB")

    @MapKey(name="strData")

    private Map<String, ECL295EntA> entACollection;

…

}

public class TestD295556 {

...

    @Test

    public void test002() {

        EntityManagerFactory emf = null;

        EntityManager em = null;

        

        emf = javax.persistence.Persistence.createEntityManagerFactory("testpu");

        em = emf.createEntityManager();

        

        em.getTransaction().begin();

        em.createNativeQuery("DELETE FROM ECLENTA_ENTB").executeUpdate();

        em.createNativeQuery("DELETE FROM ECL295EntA").executeUpdate();

        em.createNativeQuery("DELETE FROM ECL295EntB").executeUpdate();

        

        em.getTransaction().commit();

        em.close();

        

        em = emf.createEntityManager();

        em.getTransaction().begin();

        

        final int entBCount = 10;

        ECL295EntB[] entBArr = new ECL295EntB[entBCount];

        

        for (int i = 0; i < entBCount; i++) {

            ECL295EntB entB = new ECL295EntB();

            entB.setId(i+1);

            entB.setStrData("Entity B-" + i);

            em.persist(entB);

            

            entBArr[i] = entB;

        }

        

        SecureRandom sr = new SecureRandom();

        

        for (int i = 0; i < 10; i++) {

            ECL295EntA entA = new ECL295EntA();

            entA.setId(i+1);

            entA.setStrData("EntA-" + i);

            

            StringBuffer sb = new StringBuffer();

            for (int j = 0; j < 200; j++) {

                sb.append(sr.nextLong());sb.append(' ');

            }

            entA.setStringValue(sb.toString());

            

                       

            for (int j = 0; j < entBCount; j++) {

                entBArr[j].getEntACollection().put(entA.getStrData(), entA);

            }

            

            em.persist(entA);

        }

        

        em.getTransaction().commit();

        em.close();

        emf.close();

        

        emf = javax.persistence.Persistence.createEntityManagerFactory("testpu");

        em = emf.createEntityManager();

       

        Query q = em.createQuery("SELECT b from ECL295EntB b");

        q.setHint(QueryHints.BATCH , "b.entACollection");

        

        List<ECL295EntB> resultSet = q.getResultList();

        assertNotNull(resultSet);

        

        ECL295EntB entB_find = resultSet.get(0); //  em.find(ECL295EntB.class, 1);

        assertNotNull(entB_find);

       

        boolean containsTarget = entB_find.getEntACollection().containsKey("EntA-1");

        assertTrue(containsTarget);

        

        assertEquals(10, entB_find.getEntACollection().size());      

    }

...

On Aug 26, 2014, at 4:53 AM, Tomas Kraus <tomas.kraus@xxxxxxxxxx> wrote:

Hi all,

I would like to ask guys from IBM to have a look at https://bugs.eclipse.org/bugs/show_bug.cgi?id=295556 and port this fix into DB2 code too. I wanted to do it myself but we currently do not have DB2 available here. Please let me know if someone has time available to fix it in next 2-3 weeks. We have to finalize 2.6 soon and this issue is one of those we would like to fix in 2.6.

Tomas

_______________________________________________
eclipselink-dev mailing list
eclipselink-dev@xxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.eclipse.org/mailman/listinfo/eclipselink-dev