Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-dev] Fix for bug# 295556 - Do not add Distinct to Queries that including a Lob field - in DB2

How about:
  raQuery.addJoinedAttribute(query.getExpressionBuilder().anyOf("entACollection"));
On 9/8/2014 12:17 PM, J Grassel wrote:
Unfortunately, it still passes…

        Session session = ((org.eclipse.persistence.internal.jpa.EntityManagerImpl) em).getSession();

       

        ReadAllQuery raQuery = new ReadAllQuery(ECL295EntB.class);
        raQuery.addBatchReadAttribute("entACollection);


[EL Info]: 2014-09-08 11:16:07.266--ServerSession(2039599313)--EclipseLink, version: Eclipse Persistence Services - 2.5.0.v20130507-3faac2b
[EL Info]: connection: 2014-09-08 11:16:09.428--ServerSession(2039599313)--testpu login successful
[EL Fine]: sql: 2014-09-08 11:16:09.445--ServerSession(2039599313)--Connection(1635481008)--SELECT ID FROM ECL295ENTA WHERE ID <> ID
[EL Fine]: sql: 2014-09-08 11:16:09.74--ServerSession(2039599313)--Connection(1635481008)--SELECT ID FROM ECL295ENTB WHERE ID <> ID
[EL Fine]: sql: 2014-09-08 11:16:09.815--ServerSession(2039599313)--Connection(1635481008)--SELECT entACollection_ID FROM ECLENTA_ENTB WHERE entACollection_ID <> entACollection_ID
[EL Fine]: sql: 2014-09-08 11:16:09.915--ServerSession(2039599313)--Connection(1635481008)--SELECT ID, STRDATA FROM ECL295ENTB
[EL Fine]: sql: 2014-09-08 11:16:10.041--ServerSession(2039599313)--Connection(1635481008)--SELECT t1.ID, t1.STRDATA, t1.STRINGVALUE, t0.ECL295EntB_ID FROM ECLENTA_ENTB t0, ECL295ENTB t2, ECL295ENTA t1 WHERE ((t0.ECL295EntB_ID = t2.ID) AND (t1.ID = t0.entACollection_ID))


On Sep 8, 2014, at 9:47 AM, andrei ilitchev <andrei.ilitchev@xxxxxxxxxx> wrote:

raQuery.addBatchReadAttribute("entACollection");



_______________________________________________
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


Back to the top