[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4044) ejbql select count() and composite keys problem

[Thierry Accart (JIRA)]

ejbql select count() and composite keys problem
-----------------------------------------------

                 Key: HHH-4044
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4044
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.2.6
         Environment: Jboss 4.2.2, JDK 1.5.18, Seam 2.1.2, MSSQL2000
            Reporter: Thierry Accart
            Priority: Critical


Hi

we're using seam 2.1.2 on JBoss 4.2.2 with JDK 1.5.18.
Our db is hosted on mssql server.

our persistence.xml contains sets hibernate.dialect to org.hibernate.dialect.SQLServerDialect.


UserRole is an entity containing userid and roleid as a composite key.

When the following  ejbql query is run :
select count(userRole) from UserRole userRole

sql receives the following statement : 
declare @P1 int
set @P1=NULL
declare @P2 int
set @P2=0
declare @P3 int
set @P3=0
exec sp_cursorprepexec @P1 output, @P2 output, NULL, N'select count((userrole0_.roleId, userrole0_.userId)) as col_0_0_ from TP_UM_UserRole userrole0_', 16, 8193, @P3 output
select @P1, @P2, @P3

the   count((userrole0_.roleId, userrole0_.userId)) is not understood by mssql server, causing  an error " Incorrect syntax near ','."

I think that a simple select count (*) would work fine.





-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira