[richfaces-issues] [JBoss JIRA] Created: (RF-9879) ILLEGAL SYMBOL "-" exception when sorting is used on a datatable component

[Timmy Storms (JIRA)]

ILLEGAL SYMBOL "-" exception when sorting is used on a datatable component
--------------------------------------------------------------------------

                 Key: RF-9879
                 URL: https://jira.jboss.org/browse/RF-9879
             Project: RichFaces
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: component-tables
    Affects Versions: 3.3.3.Final
         Environment: DB2 8
Tomcat 6
Spring 2.5.6
Hibernate 3.3.2.GA
            Reporter: Timmy Storms


When I use sorting on a datatable, I'm getting the following exception when the page is rendered:" com.ibm.db2.jcc.b.SqlException: ILLEGAL SYMBOL "-". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER>".

It appears that this is caused by the -1 in the following sql statement: 
select
     a.b        
from
     mytable
order by
    upper(column) asc fetch first -1 rows only

We use DB2 as database. org.hibernate.dialect.DB2390Dialect is the hibernate dialect we use. I've tried the other DB2 ones to.

I'm wondering if this issue is related to hibernate/db2 or that it originates from the datatable component.


-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira