Eclipse Community Forums: EclipseLink » using UNION with ORDER BY clause

Help

Home

Home » Eclipse Projects » EclipseLink » using UNION with ORDER BY clause

Show: Today's Messages :: Show Polls :: Message Navigator

using UNION with ORDER BY clause [message #1220005]

Mon, 09 December 2013 06:29

ivan fomin

Messages: 1
Registered: December 2013

Junior Member

Im using eclipselink 2.5.1 when i try to execute query like this: "SELECT t FROM Table t WHERE t.id = :id1 UNION SELECT t FROM Table t WHERE t.id = :id2 ORDER BY t.name ASC" i get exception "Syntax error parsing". Query only with UNION or ORDER BY works fine. Is it possible to sort result of union query?

Report message to a moderator

Previous Topic:	Run time error for DALI generated entity with compound keys
Next Topic:	MappedSuperclass methods not getting weaved

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 20 13:08:07 GMT 2018

.:: Contact :: Home ::.