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

[Alexey Loubyansky (JIRA)]

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

Alexey Loubyansky closed JBAS-2193.
-----------------------------------

    Fix Version/s:     (was: JBossAS-4.0.6.CR1)
       Resolution: Out of Date

This one was probably fixed as a side effect of some other issue. It's working against the current Branch_4_0.
15:42:00,685 INFO  [FacadeSessionBean] RUN>
15:42:00,685 DEBUG [A#ejbSelectSelect] DYNAMIC-QL: select count(limit_a.id) from limita limit_a
15:42:00,685 DEBUG [A#ejbSelectSelect] Executing SQL: SELECT count( t0_limit_a.id) FROM A t0_limit_a
15:42:00,685 INFO  [STDOUT] [1]

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