Eclipse Community Forums: EclipseLink » How can I get count of distinct left join subquery?

Help

Home

Home » Eclipse Projects » EclipseLink » How can I get count of distinct left join subquery?

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

How can I get count of distinct left join subquery? [message #682634]

Sat, 11 June 2011 13:56

Viacheslav Petriaiev is currently offline

Viacheslav Petriaiev
Messages: 2
Registered: June 2011

Junior Member

How can I get count records of subquery with distinct and joins?

Is it possible using Criteria API to get SQL-query like that?
select count(g.*) from (select distinct from TABLE0 t0 LEFT OUTER JOIN TABLE1 t1 ON (t1.TABLE0_ID = t0.ID)) g;

[Updated on: Sat, 11 June 2011 14:04]

Report message to a moderator

Re: How can I get count of distinct left join subquery? [message #683428 is a reply to message #682634]

Mon, 13 June 2011 13:52

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

What is the object model?

In general JPQL and Criteria do not support subselects in the from clause.

For a specific SQL query you can use a native query.

James : Wiki : Book : Blog

Report message to a moderator

(no subject) [message #683442 is a reply to message #682634]

Mon, 13 June 2011 13:52

James
Messages: 272
Registered: July 2009

Senior Member

What is the object model?

In general JPQL and Criteria do not support subselects in the from clause.

For a specific SQL query you can use a native query.

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

Report message to a moderator

Previous Topic:	Update manytomany results in duplicate key exception
Next Topic:	Catching Internal Exceptions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 01:51:54 EDT 2013