[jboss-jira] [JBoss JIRA] Created: (EJBTHREE-984) Named queries containing sql reserved words survive deployment but fail at runtime.

[Thomas Skj￸lberg (JIRA)]

Named queries containing sql reserved words survive deployment but fail at runtime. 
------------------------------------------------------------------------------------

                 Key: EJBTHREE-984
                 URL: http://jira.jboss.com/jira/browse/EJBTHREE-984
             Project: EJB 3.0
          Issue Type: Bug
    Affects Versions: AS 4.2.0 GA
         Environment: Windows, eclipse 3.1.2 and Jboss 4.2GA and the built-in database, EJB 3.0
            Reporter: Thomas Skj￸lberg
            Priority: Optional


Named queries in the entity beans are accepted at deployment however fail at runtime. 

It looks like the reserved words just are removed from the consequent sql command used by JBoss, hence resulting in an unexpected token exception during parsing.

... A <= B ...
becomes 
... <= B

Altering tables from entity beans that have fields with the sql reserved word START, END and TIME fail, probably due to the same reason. No other reserved words tried.


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