[jboss-jira] [JBoss JIRA] Updated: (JBAS-2193) abstract schema name with word limit in name

[Dimitris Andreadis (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBAS-2193?page=all ]

Dimitris Andreadis updated JBAS-2193:
-------------------------------------

    Fix Version/s: JBossAS-4.0.6.CR1
                       (was: JBossAS-4.0.5.GA)

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira