Hibernate Community • View topic - How do you do a criteria API projection on a superclass?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How do you do a criteria API projection on a superclass?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dusura

Post subject: How do you do a criteria API projection on a superclass?

Posted: Fri Apr 08, 2011 4:00 am

Newbie

Joined: Mon Aug 15, 2005 9:19 pm
Posts: 8

Hi,

I have three classes A, B and C that inherit from a common superclass D. The classes are mapped one table for each class A, B and C.

Problem is that when I do a count projection I get three rows returned. A count for each "table". I want one row.

Code:

session.createCriteria(D.class).setProjection(Projections.rowCount())

Is is possible with the criteria API or do I have to use native SQL?

Any assistance much appreciated.

Cheers,
David

Top

dusura

Post subject: Re: How do you do a criteria API projection on a superclass?

Posted: Sun Apr 10, 2011 8:11 pm