how to find count on distinct object

asunilreddy · **Joined:** Thu Oct 16, 2003 7:55 pm **Posts:** 4

Hi,

I have a named query like this.

SELECT
distinct new com.radian.axiom.billing.cuw.bo.dto.BillingProfileSummaryDTO( summaryDTO.billingProfileID,summaryDTO.billingProfileDisplayID,
summaryDTO.customerID)
FROM
com.radian.axiom.billing.cuw.bo.dto.BillingProfileSummaryDTO AS summaryDTO
WHERE
((:customerNameFlag = 0) OR (UPPER(summaryDTO.customerName) LIKE UPPER(:customerName)))
AND
((:branchNameFlag = 0) OR (UPPER(summaryDTO.coveredBranchName) LIKE UPPER(:branchName)))

here i need to find the count of these distinct new records.

Let me know the solution if any body knows. I am using oracle 9i and hibernate 2.1

Sunil

emmanuel · **Posted:** Thu Apr 22, 2004 3:07 am

count(distinct ...)

asunilreddy · **Joined:** Thu Oct 16, 2003 7:55 pm **Posts:** 4

i did it but i am getting this exception now

net.sf.hibernate.QueryException: alias or expression expected in SELECT [

if i use
select count(distinct new Object(...,...)

emmanuel · **Posted:** Thu Apr 22, 2004 3:51 pm

Oh,
why creating new objects when you want to have a count. I don't expect Hibernate to support that.

asunilreddy · **Joined:** Thu Oct 16, 2003 7:55 pm **Posts:** 4

i have a requirement where in i need to consider 6 columns to form a distinct record and i want to count those distinct records. You are right I don't need to create an object for counting

emmanuel · **Posted:** Thu Apr 22, 2004 4:45 pm

actually count( distinct a.name, a.value) won't work either. But I can't tell if this is a bug or if it's expected.