[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4056) Invalid count(*) syntax with org.hibernate.dialect.ProgressDialect

[Stefan Penndorf (JIRA)]

Invalid count(*) syntax with org.hibernate.dialect.ProgressDialect
------------------------------------------------------------------

                 Key: HHH-4056
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4056
             Project: Hibernate Core
          Issue Type: Bug
    Affects Versions: 3.3.2
         Environment: Hibernate 3.3.2
org.hibernate.dialect.ProgressDialect
Progress 09.1D07
Accessed via sun.jdbc.odbc.JdbcOdbcDriver
Using Hibernate as JPA Provider with Hibernate EntityManager
            Reporter: Stefan Penndorf


I'm trying to connect to a Progress Database using sun's JdbcOdbc bridge. I noticed the following issues:

- I have to quote the entities manually:

@Entity
@Table(name = "\"MYTABLENAME\"", schema = "PUB" ) // notice the escaped double quotes 
public class MyEntity { .... }

- I have an entity with a composite primary key. The query

SELECT COUNT(X) FROM MyEntity x

doesn't work. It will be rewritten to

SELECT COUNT(X.col1, X.col2) FROM PUB."table" x

Which is not valid and causes a SQLGrammarException / SQLException .

-- 
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