[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4051) Issue with count(class) when class has a composite (@Embeddable) id

Issue with count(class) when class has a composite (@Embeddable) id ------------------------------------------------------------------- Key: HHH-4051 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4051 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Hibernate 3.2.6 on Oracle 10g Reporter: kareem shabazz Priority: Minor When performing this query [(Long)session.createQuery("select count(c) from " + clazz.getSimpleName() + " c").uniqueResult()], the following error occurs 15:34:52.954 [main] DEBUG org.hibernate.SQL - select count((contingenc0_.client_id, contingenc0_.dataset_id, contingenc0_.jurisdiction_id, contingenc0_.unit_id)) as col_0_0_ from ctg_rates contingenc0_ Hibernate: select count((contingenc0_.client_id, contingenc0_.dataset_id, contingenc0_.jurisdiction_id, contingenc0_.unit_id)) as col_0_0_ from ctg_rates contingenc0_ 15:34:52.985 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 15:34:52.985 [main] DEBUG o.h.util.JDBCExceptionReporter - could not execute query [select count((contingenc0_.client_id, contingenc0_.dataset_id, contingenc0_.jurisdiction_id, contingenc0_.unit_id)) as col_0_0_ from ctg_rates contingenc0_] java.sql.SQLException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) ... The 4 properties (clientId, datasetId, unitid, jurisdictionId) make up an class annotated with @Embeddable and is used as the @Id in class ContingencyRate. The query looks fine, I can't imagine what could possibly be wrong other than a bug. ContingencyRate is persisted and retrived from the db without an issue in the same integration test suite. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira