Uploaded image for project: 'Hibernate ORM'
  1. HHH-4044

ejbql select count() and composite keys problem

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 3.2.6
    • Fix Version/s: None
    • Component/s: hibernate-core
    • Labels:
      None
    • Environment:
      Jboss 4.2.2, JDK 1.5.18, Seam 2.1.2, MSSQL2000
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      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.

        Attachments

          Issue links

            Activity

              People

              • Votes:
                8 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified