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

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