abstract schema name with word limit in name -------------------------------------------- Key: JBAS-2193 URL: http://jira.jboss.com/jira/browse/JBAS-2193 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: CMP service Affects Versions: JBossAS-4.0.3RC1 Environment: OS: Windows XP and FreeBsd Database: PostgreSQL 7.4 Reporter: Yura Kravchuk Assigned To: Alexey Loubyansky Priority: Minor Fix For: JBossAS-4.0.6.CR1 We have few CMP entity beans with abstract schema name with word "limit", e.g. limitation_categories, limitation_durations, etc. We using dynamiq QL. It seems that query parser confused by word "limit" in schema name and thinks that it's clause LIMIT which placed before FROM clause. I changed schema name to lim_categories for entity bean and all works perfectly. Herewith exception: 17:02:28,671 INFO [STDOUT] javax.ejb.EJBException: SELECT COUNT($limit_category.id) FROM limit_category AS $limit_categ ory; CausedByException is: Can't count entities by expression and parameters; CausedByException is: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "<EOF>" at line 1, column 71. Was expecting: "FROM" ... ; CausedByException is: Can't count entities by expression and parameters; CausedByException is: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "<EOF>" at line 1, column 71.