We're updating the issue view to help you get more done. 

ejbql select count() and composite keys problem

Description

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.

Environment

Jboss 4.2.2, JDK 1.5.18, Seam 2.1.2, MSSQL2000

Status

Assignee

Unassigned

Reporter

Thierry Accart

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.2.6

Priority

Critical